datepgTheory.py

import requests
from bs4 import BeautifulSoup as bs
import MySQLdb
db=MySQLdb.connect("localhost","root","icancode23","dufeed")
cursor2=db.cursor()
cmd="""select * from api_pgdatecounters"""
cursor2.execute(cmd)
alt=cursor2.fetchone()
db.commit()
#last_notification="run"
src=requests.get("http://exam.du.ac.in/PG-datesheets.html").text
soup=bs(src,"html.parser")
j=21     
soup1=soup.find_all('a')
soup2=soup1[21]
href=soup2
print soup2
while soup2!=last_notification and j<141:
	#print soup2
	try:
		link=soup2["href"]
		name=soup2.decode_contents(formatter="html")
		print name
		print "\n"
	except:
		print "nahi hai"
	
	j=j+1
	print j
	soup2=soup1[j]

	sql="""insert into api_pgdate(id,link,title) values(NULL,'%s','%s')"""%(link,name)
	cursor2.execute(sql)
cursor2.execute("""update api_pgdatecounters set link=%s""",(href,))
db.commit()
db.close()