Innovacer internship SDE-Intern (Platform) assignment
The Language Used-Python2
Additional Features:
I am printing the name of the episode alogn with airdate.
Steps:
1)Initially u should create a database in mysql with name "script"
2)In connect command in the script fill in the password of your database like this
db=MySQLdb.connect('localhost','root','password of database','script')
3)In the from emailaddress fill in the email address from which u want to send the mail
fromaddr="your emailaddress"
4)In username fill in the mail from which u want to send and fill the password of that mail in password like
username="innovacer@gmail.com" password="innovacer"
5)Make sure you give permissions to less secure apps for your sending mail to send mails
6)Run the script with the command
sudo python2 script.py
7)If you are running the script for morethan once then comment the createtable function i.e createtable() because Once u run the script table is created and it can't create table with same name
Requirements: sudo pip install beautifulsoup4, sudo pip install google, sudo apt-get install python-pip python-dev libmysqlclient-dev, sudo pip install MySQL-python.