import mysql.

connector as a
con=a.connect(host='localhost',user='root',
database='test',passwd='rema')
def AddSt():
n=input("Student name:")
cl = input("Class:")
r=int(input("Roll no:"))
a=input("Address:")
ph=input("Phone:")
data=(n,cl,r,a,ph)
sql='insert into student values(%s,%s,%s,%s,%s)'
c=con.cursor()
c.execute(sql,data)
con.commit()
print("Data entered successfully")
print(" ")
main()
def RemoveSt():
cl = input("Class:")
r=int(input("Roll no:"))
data=(cl,r)
sql='delete from student where class = %s and roll = %s'
c=con.cursor()
c.execute(sql,data)
con.commit()
print("Data Updated")
print(" ")
main()
def DisplaSt():
cl = input("Class:")
data=(cl,)
sql='select * from student where class = %s'
c=con.cursor()
c.execute(sql,data)
d=c.fetchall()
for i in d:
print("Name:",i[0])
print("Class:",i[1])
print("Roll no:",i[2])
print("Address:",i[3])
 print("Phone:",i[4])
print(" ")
print(" ")
main()
def AddT():
tcode=int(input("TCode:))
n=input("Teacher name:")
s=int(input("Salary:"))
a=input("Address:")
ph=input("Phone:")
data=(tcode,n,s,a,ph)
sql='insert into teacher values(%s,%s,%s,%s,%s)'
c=con.cursor()
c.execute(sql,data)
con.commit()
print("Data entered successfully")
print(" ")
main()
def RemoveT():
n=input("Teacher:")
tcode=int(input("Tcode:")
data=(n,tcode)
sql='delete from teacher where name=%s and tcode = %s'
c=con.cursor()
c.execute(sql,data)
con.commit()
print("Data Updated")
print(" ")
main()
def UpdateSal():
n=input("Teacher:")
tcode=int(input("Tcode:"))
salary=int(input("Salary:"))
data=(n,tcode)
sql='update teacher set salary=%s where name=%s and
tcode = %s'
c=con.cursor()
c.execute(sql,data)
con.commit()
print("Data Updated")
 print(" ")
main()
def DisplayT():
sql='select * from teacher'
c=con.cursor()
c.execute(sql)
d=c.fetchall()
for i in d:
print("Tcode:",i[0])
print("Name:",i[1])
print("salary:",i[2])
print("Address:",i[3])
print("Phone:",i[4])
print(" ")
print(" ")
main()
def ClAttd():
d = input("Class:")
clt=input("Class teacher:")
t=int(input("Class strength:"))
d=input("Date:")
ab=int(input("No of absentees:"))
data=(d,clt,t,d,ab)
sql='insert into ClAttendance values(%s,%s,%s,%s,%s)'
c=con.cursor()
c.execute(sql,data)
con.commit()
print("Data entered successfully")
print(" ")
main()
def DisplayClAttd():
sql='select * from ClAttendance'
c=con.cursor()
c.execute(sql)
d=c.fetchall()
for i in d:
print("Class:",i[0])
print("Class teacher:",i[1])
print("Total St:",i[2])
print("Date:",i[3])
 print("Absentees:",i[4])
print(" ")
print(" ")
main()
def TAttd():
n=input("Name:")
d=input("Date:")
a=input("Attendance:")
data=(n,d,a)
sql='insert into tattendance values(%s,%s,%s)'
c=con.cursor()
c.execute(sql,data)
con.commit()
print("Data entered successfully")
print(" ")
main()
def DisplayTAttd():
sql='select * from tattendance'
c=con.cursor()
c.execute(sql)
d=c.fetchall()
for i in d:
print("Name:",i[0])
print("Date:",i[1])
print("Attendance:",i[2])
print(" ")
print(" ")
main()
def UpdateFees():
cl=input("Class:")
m=input("Monthly:")
b=input("BusFee:")
sc=input("ScFee:")
tc=input("TechFee:")
t=input("Total:")
data=(cl,)
sql= 'update FeeStructure set month;y=%s, BusFee=%s,
ScFee=%s, TechFee=%s, Total=%s'
c.execute(sql,data)
con.commit()
 print("Data Updated")
print(" ")
main()
def DisplayFees():
sql='select from FeeStructure'
c=con.cursor()
c.execute(sql)
d=c.fetchall()
for i in d:
print("Class:",i[0])
print("Monthly:",i[1])
print("BusFee:",i[2])
print("ScFee:",i[3])
print("TechFee:",i[4])
print("Total:",i[5])
print(" ")
print(" ")
main()
def AddBook():
bid=int(input("Book id:"))
t=input("Title:")
a=input("Author:")
p=input("Publisher:")
g=input("Genre:")
data=(bid,t,a,p,g)
sql = 'insert into library values((%s,%s,%s,%s,%s)'
c=con.cursor()
c.execute(sql,data)
con.commit()
print("Data entered successfully")
print(" ")
main()
def RemoveB():
t=input("Title:")
bid=int(input("Book id:"))
data=(t,bid)
sql = 'delete from library where t=%s and bid= %s'
c=con.cursor()
c.execute(sql,data)
con.commit()
 print("Data Updated")
print(" ")
main()
def DisplayB():
sql='select * from library'
c=con.cursor()
c.execute(sql)
d=c.fetchall()
op='y'
while op in ['y', 'Y']:
print("1. Teacher attendance")
print("2. Display Tattd details")
task = int(input("enter task no:"))
if task==1:
TAttd()
elif task==2:
DisplayTAttd ()
else:
print("Enter Valid Choice!!")
op=input("Continue in this table(y/n):")
elif table==5:
op='y'
while op in ['y','Y']:
print("1.Update Fees")
print("2.Display Fees details")
task=int(input("enter task no:"))
if task ==1:
UpdateFees()
elif task==2:
DisplayFees()
else:
print("Enter Valid Choice!!")
op=input("Continue in this table(y/n):")
elif table==6:
op='y'
while op in ['y','Y']:
print("1. Add Book")
print("2. Remove Book")
print("3. Display Book")
task = int(input("enter task no:"))
 if task==1:
AddBook()
elif task==2:
print("Enter Valid Choice!!")
op=input("Continue in this table(y/n):")
elif table==2:
op='y'
while op in ['y','Y']:
print("1.Add teacher")
print("2.Remove teacher")
print("3.Update Salary")
print("4.Display Tdetails")
task = int(input("enter task no:"))
if task==1:
AddT()
elif task==2:
RemoveT()
elif task==3:
UpdateSal()
elif task==4:
DisplayT()
else:
print("Enter Valid Choice!!")
op=input("Continue in this table(y/n):")
elif table==3:
op='y'
while op in ['y','Y']:
print("1.Class Attendance")
print("2.Display ClAttd details")
task = int(input("enter task no:"))
if task==1:
ClAddT()
elif task==2:
DisplayClAttd()
else:
print("Enter Valid Choice!!")
op=input("Continue in this table(y/n):")
elif table==4:
for i in d:
print("Bid:",i[0])
 print("Title:",i[1])
print("Author:",i[2])
print("Publisher:",i[3])
print("Genre:",i[4])
print(" ")
print(" ")
main()
def main():
ch='y'
while ch in ['y','Y']:
print("Pitts Modern School")
print("1. Student")
print("2. Teacher")
print("3. ClAttendance")
print("4. TAttendance")
print("5. FeeStructure")
print("6. Library")
table=int(input("Enter table no:"))
print(" ")
if table==1:
op='y'
while op in ['y','Y']:
print("1.Add Student")
print("2.Remove Student")
print("3.Display Student Detail")
task = int(input("enter task no:"))
if task==1:
AddSt()
elif task==2:
RemoveSt()
elif task==3:
DisplaySt()
else:
RemoveB()
elif task==3:
DisplayB()
else:
print("Enter Valid Choice!!")
op=input("Continue in this table(y/n):")
else:
 print("ENTER VALID CHOICE!!")
ch=input("Do you want to Continue(y/n):")