import platform
import mysql.connector
 
mydb=mysql.connector.connect(host="localhost",user="root",passwd="root",database="sms",charset="utf8")
mycursor=mydb.cursor()
 
#MODULE FOR NEW ADMISSION
def newStudent():
    createTable	="""CREATE	TABLE	IF	NOT	EXISTS	STUDENT(SROLL_NO	VARCHAR(5),SNAME VARCHAR(30),FNAME VARCHAR(30),MNAME VARCHAR(30) ,PHONE	VARCHAR(12),	ADDRESS	VARCHAR(100),SCLASS VARCHAR(5),SSECTION VARCHAR(5), SADMISSION_NO    VARCHAR(10) PRIMARY KEY)"""
    mycursor.execute(createTable)
    sroll_no=input(" ENTER ROLL_NO : ")
    sname=input("\n ENTER STUDENT'S NAME : ")
    fname=input(" ENTER FATHER'S NAME : ")
    mname=input(" ENTER MOTHER'S NAME : ")
    phone=input(" ENTER CONTACT NO. : ")
    address=input(" ENTER ADDRESS : ")
    sclass =input(" ENTER CLASS : ")
    ssection=input(" ENTER SECTION : ")
    sadmission_no=input(" ENTER ADMISSION_NO   :   ")
    sql="insert into student (sroll_no,sname,fname,mname,phone,address,sclass,ssection,sadmission_no) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)"
    values=(sroll_no,sname,fname,mname,phone,address ,sclass,ssection,sadmission_no)
    mycursor.execute(sql,values)
    mycursor.execute("COMMIT")
    mycursor.close()
 
 
#MODULE TO DISPLAY STUDENT'S DATA
def displayStudent():
    mycursor.execute("SELECT * FROM student")
    data=mycursor.fetchall()
    print(data)
    mycursor.close()
 
#MODULE TO UPDATE STUDENT'S RECORD
def updateStudent():
    admission_no=input("ENTER ADMISSION NO :")
    sql="SELECT * FROM student WHERE sadmission_no= %s"
    mycursor.execute(sql,(admission_no,))
    data=mycursor.fetchall()
    if data:
        print("PRESS 1 FOR NAME")
        print("PRESS 2 FOR CLASS")
        print("PRESS 3 FOR ROLL NO")
        choice=int(input("Enter Your Choice"))
        if choice==1:
            name=input("ENTER NAME OF THE STUDENT  :")
            sql="UPDATE student SET sname= %s WHERE sadmission_no =%s"
            mycursor.execute(sql,(name,admission_no))
            mycursor.execute("COMMIT")
            print("NAME UPDATED")
        elif choice == 2:
            std=input("ENTER CLASS OF THE STUDENT   :")
            sql="UPDATE student SET sclass= %s WHERE sadmission_no=%s"
            mycursor.execute(sql,(std,admission_no))
            mycursor.execute("COMMIT")
            print("CLASS UPDATED")
        elif choice==3:
            roll_no=int(input("ENTER ROLL NO OF THE STUDENT  :"))
            sql="UPDATE	student	SET	sroll_no=	%s	WHERE sadmission_no = %s"
            mycursor.execute(sql,(roll_no,admission_no))
            mycursor.execute("COMMIT")
            print("ROLL NO UPDATED")
        else:
            print("Record Not Found Try Again !")
            mycursor.close()
    else:
        print("\nSomthing Went Wrong ,Please Try Again !")
 
#MODULE TO ENTER MARKS OF THE STUDENT
def marksStudent () :
    createTable ="""CREATE TABLE IF NOT EXISTS MARKS(SADMISSION_NO VARCHAR(10) PRIMARY KEY,HINDI INT,ENGLISH INT ,MATH INT ,SCIENCE INT,SOCIAL INT,COMPUTER INT,TOTAL INT ,AVERAGE DECIMAL)"""
    mycursor.execute(createTable)
    admission_no=input("ENTER ADMISSION NO OF THE STUDENT :")
    hindi=int(input("\n ENTER MARKS OF HINDI : "))
    english=int(input("\n ENTER MARKS OF ENGLISH : "))
    math=int(input("\n ENTER MARKS OF MATH : "))
    science=int(input("\n ENTER MARKS OF SCIENCE : "))
    social=int(input("\n ENTER MARKS OF SOCIAL : "))
    computer =int(input("\n ENTER MARKS OF COMPUTER : "))
    total = hindi + english + math + science + social + computer
    average = total/6
    sql="INSERT INTO MARKS(SADMISSION_NO,HINDI,ENGLISH,MATH,SCIENCE,SOCIAL,COMPUTER, TOTAL,AVERAGE) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)"
    values=(admission_no,hindi,english,math,science,social,computer , total , average)
    mycursor.execute(sql,values)
    mycursor.execute("COMMIT")
    mycursor.close()
    print("\nMarks of the Student Entered Successfully !")
 
def reportCardAllStudent () :
    mycursor.execute("SELECT * FROM MARKS")
    data=mycursor.fetchall()
    print(data)
    mycursor.close()
 
#MODULE TO GENERATE REPORT CARD OF ONE STUDENTS
def reportCardOneStudent():
    admission_no=input("ENTER ADMISSION NO OF THE STUDENT :")
 
    sql="SELECT * FROM MARKS WHERE SADMISSION_NO= %s"
    mycursor.execute(sql,(admission_no,))
    data=mycursor.fetchall()
    if data:
        print(data)
    else:
        print("Record Not Found , Please Try Again !")
        mycursor.close()
 
 
def helpMe():
    print("Please, Visit The Offcial Website Of Vidyalaya To Download The Mannual !!!")
 
print("############################################################# #######")
while(1):
    print("|	Enter 1 -  Add Student		                                        |")
    print("|	Enter 2 -  Display Student's Data.					|")
    print("|	Enter 3 -  Update Students's Data .					|")
    print("|	Enter 4 -  Add Student's Marks Detail.					|")
    print("|	Enter 5 - Generate All Student's Report Card.                           |")
    print("|	Enter 6 - Generate Student Wise Report Card.                            |")
    print("|	Enter 7-  Exit.	                                                        |")
    print("|	Enter 0(ZERO) - Help.	                                                |")
    choice=int(input("PLEASE  ENTER  YOUR  CHOICE  :	"))
    if choice==1:
        newStudent()
    elif choice==2:
        displayStudent()
    elif choice==3:
        updateStudent()
    elif choice==4:
        marksStudent()
    elif choice==5:
        reportCardAllStudent()
    elif choice==6:
        reportCardOneStudent()
    elif choice==7:
        quit()
    elif choice==0:
        helpMe()
    else:
        print("Sorry ,May Be You Are Giving Me Wrong Input, Please Try Again !!! ")
 

aW1wb3J0IHBsYXRmb3JtCmltcG9ydCBteXNxbC5jb25uZWN0b3IKCm15ZGI9bXlzcWwuY29ubmVjdG9yLmNvbm5lY3QoaG9zdD0ibG9jYWxob3N0Iix1c2VyPSJyb290IixwYXNzd2Q9InJvb3QiLGRhdGFiYXNlPSJzbXMiLGNoYXJzZXQ9InV0ZjgiKQpteWN1cnNvcj1teWRiLmN1cnNvcigpCgojTU9EVUxFIEZPUiBORVcgQURNSVNTSU9OCmRlZiBuZXdTdHVkZW50KCk6CiAgICBjcmVhdGVUYWJsZQk9IiIiQ1JFQVRFCVRBQkxFCUlGCU5PVAlFWElTVFMJU1RVREVOVChTUk9MTF9OTwlWQVJDSEFSKDUpLFNOQU1FIFZBUkNIQVIoMzApLEZOQU1FIFZBUkNIQVIoMzApLE1OQU1FIFZBUkNIQVIoMzApICxQSE9ORQlWQVJDSEFSKDEyKSwJQUREUkVTUwlWQVJDSEFSKDEwMCksU0NMQVNTIFZBUkNIQVIoNSksU1NFQ1RJT04gVkFSQ0hBUig1KSwgU0FETUlTU0lPTl9OTyAgICBWQVJDSEFSKDEwKSBQUklNQVJZIEtFWSkiIiIKICAgIG15Y3Vyc29yLmV4ZWN1dGUoY3JlYXRlVGFibGUpCiAgICBzcm9sbF9ubz1pbnB1dCgiIEVOVEVSIFJPTExfTk8gOiAiKQogICAgc25hbWU9aW5wdXQoIlxuIEVOVEVSIFNUVURFTlQnUyBOQU1FIDogIikKICAgIGZuYW1lPWlucHV0KCIgRU5URVIgRkFUSEVSJ1MgTkFNRSA6ICIpCiAgICBtbmFtZT1pbnB1dCgiIEVOVEVSIE1PVEhFUidTIE5BTUUgOiAiKQogICAgcGhvbmU9aW5wdXQoIiBFTlRFUiBDT05UQUNUIE5PLiA6ICIpCiAgICBhZGRyZXNzPWlucHV0KCIgRU5URVIgQUREUkVTUyA6ICIpCiAgICBzY2xhc3MgPWlucHV0KCIgRU5URVIgQ0xBU1MgOiAiKQogICAgc3NlY3Rpb249aW5wdXQoIiBFTlRFUiBTRUNUSU9OIDogIikKICAgIHNhZG1pc3Npb25fbm89aW5wdXQoIiBFTlRFUiBBRE1JU1NJT05fTk8gICA6ICAgIikKICAgIHNxbD0iaW5zZXJ0IGludG8gc3R1ZGVudCAoc3JvbGxfbm8sc25hbWUsZm5hbWUsbW5hbWUscGhvbmUsYWRkcmVzcyxzY2xhc3Msc3NlY3Rpb24sc2FkbWlzc2lvbl9ubykgVkFMVUVTKCVzLCVzLCVzLCVzLCVzLCVzLCVzLCVzLCVzKSIKICAgIHZhbHVlcz0oc3JvbGxfbm8sc25hbWUsZm5hbWUsbW5hbWUscGhvbmUsYWRkcmVzcyAsc2NsYXNzLHNzZWN0aW9uLHNhZG1pc3Npb25fbm8pCiAgICBteWN1cnNvci5leGVjdXRlKHNxbCx2YWx1ZXMpCiAgICBteWN1cnNvci5leGVjdXRlKCJDT01NSVQiKQogICAgbXljdXJzb3IuY2xvc2UoKQogICAgICAKCiNNT0RVTEUgVE8gRElTUExBWSBTVFVERU5UJ1MgREFUQQpkZWYgZGlzcGxheVN0dWRlbnQoKToKICAgIG15Y3Vyc29yLmV4ZWN1dGUoIlNFTEVDVCAqIEZST00gc3R1ZGVudCIpCiAgICBkYXRhPW15Y3Vyc29yLmZldGNoYWxsKCkKICAgIHByaW50KGRhdGEpCiAgICBteWN1cnNvci5jbG9zZSgpCiAgICAKI01PRFVMRSBUTyBVUERBVEUgU1RVREVOVCdTIFJFQ09SRApkZWYgdXBkYXRlU3R1ZGVudCgpOgogICAgYWRtaXNzaW9uX25vPWlucHV0KCJFTlRFUiBBRE1JU1NJT04gTk8gOiIpCiAgICBzcWw9IlNFTEVDVCAqIEZST00gc3R1ZGVudCBXSEVSRSBzYWRtaXNzaW9uX25vPSAlcyIKICAgIG15Y3Vyc29yLmV4ZWN1dGUoc3FsLChhZG1pc3Npb25fbm8sKSkKICAgIGRhdGE9bXljdXJzb3IuZmV0Y2hhbGwoKQogICAgaWYgZGF0YToKICAgICAgICBwcmludCgiUFJFU1MgMSBGT1IgTkFNRSIpCiAgICAgICAgcHJpbnQoIlBSRVNTIDIgRk9SIENMQVNTIikKICAgICAgICBwcmludCgiUFJFU1MgMyBGT1IgUk9MTCBOTyIpCiAgICAgICAgY2hvaWNlPWludChpbnB1dCgiRW50ZXIgWW91ciBDaG9pY2UiKSkKICAgICAgICBpZiBjaG9pY2U9PTE6CiAgICAgICAgICAgIG5hbWU9aW5wdXQoIkVOVEVSIE5BTUUgT0YgVEhFIFNUVURFTlQgIDoiKQogICAgICAgICAgICBzcWw9IlVQREFURSBzdHVkZW50IFNFVCBzbmFtZT0gJXMgV0hFUkUgc2FkbWlzc2lvbl9ubyA9JXMiCiAgICAgICAgICAgIG15Y3Vyc29yLmV4ZWN1dGUoc3FsLChuYW1lLGFkbWlzc2lvbl9ubykpCiAgICAgICAgICAgIG15Y3Vyc29yLmV4ZWN1dGUoIkNPTU1JVCIpCiAgICAgICAgICAgIHByaW50KCJOQU1FIFVQREFURUQiKQogICAgICAgIGVsaWYgY2hvaWNlID09IDI6CiAgICAgICAgICAgIHN0ZD1pbnB1dCgiRU5URVIgQ0xBU1MgT0YgVEhFIFNUVURFTlQgICA6IikKICAgICAgICAgICAgc3FsPSJVUERBVEUgc3R1ZGVudCBTRVQgc2NsYXNzPSAlcyBXSEVSRSBzYWRtaXNzaW9uX25vPSVzIgogICAgICAgICAgICBteWN1cnNvci5leGVjdXRlKHNxbCwoc3RkLGFkbWlzc2lvbl9ubykpCiAgICAgICAgICAgIG15Y3Vyc29yLmV4ZWN1dGUoIkNPTU1JVCIpCiAgICAgICAgICAgIHByaW50KCJDTEFTUyBVUERBVEVEIikKICAgICAgICBlbGlmIGNob2ljZT09MzoKICAgICAgICAgICAgcm9sbF9ubz1pbnQoaW5wdXQoIkVOVEVSIFJPTEwgTk8gT0YgVEhFIFNUVURFTlQgIDoiKSkKICAgICAgICAgICAgc3FsPSJVUERBVEUJc3R1ZGVudAlTRVQJc3JvbGxfbm89CSVzCVdIRVJFIHNhZG1pc3Npb25fbm8gPSAlcyIKICAgICAgICAgICAgbXljdXJzb3IuZXhlY3V0ZShzcWwsKHJvbGxfbm8sYWRtaXNzaW9uX25vKSkKICAgICAgICAgICAgbXljdXJzb3IuZXhlY3V0ZSgiQ09NTUlUIikKICAgICAgICAgICAgcHJpbnQoIlJPTEwgTk8gVVBEQVRFRCIpCiAgICAgICAgZWxzZToKICAgICAgICAgICAgcHJpbnQoIlJlY29yZCBOb3QgRm91bmQgVHJ5IEFnYWluICEiKQogICAgICAgICAgICBteWN1cnNvci5jbG9zZSgpCiAgICBlbHNlOgogICAgICAgIHByaW50KCJcblNvbXRoaW5nIFdlbnQgV3JvbmcgLFBsZWFzZSBUcnkgQWdhaW4gISIpCgojTU9EVUxFIFRPIEVOVEVSIE1BUktTIE9GIFRIRSBTVFVERU5UCmRlZiBtYXJrc1N0dWRlbnQgKCkgOgogICAgY3JlYXRlVGFibGUgPSIiIkNSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIE1BUktTKFNBRE1JU1NJT05fTk8gVkFSQ0hBUigxMCkgUFJJTUFSWSBLRVksSElOREkgSU5ULEVOR0xJU0ggSU5UICxNQVRIIElOVCAsU0NJRU5DRSBJTlQsU09DSUFMIElOVCxDT01QVVRFUiBJTlQsVE9UQUwgSU5UICxBVkVSQUdFIERFQ0lNQUwpIiIiCiAgICBteWN1cnNvci5leGVjdXRlKGNyZWF0ZVRhYmxlKQogICAgYWRtaXNzaW9uX25vPWlucHV0KCJFTlRFUiBBRE1JU1NJT04gTk8gT0YgVEhFIFNUVURFTlQgOiIpCiAgICBoaW5kaT1pbnQoaW5wdXQoIlxuIEVOVEVSIE1BUktTIE9GIEhJTkRJIDogIikpCiAgICBlbmdsaXNoPWludChpbnB1dCgiXG4gRU5URVIgTUFSS1MgT0YgRU5HTElTSCA6ICIpKQogICAgbWF0aD1pbnQoaW5wdXQoIlxuIEVOVEVSIE1BUktTIE9GIE1BVEggOiAiKSkKICAgIHNjaWVuY2U9aW50KGlucHV0KCJcbiBFTlRFUiBNQVJLUyBPRiBTQ0lFTkNFIDogIikpCiAgICBzb2NpYWw9aW50KGlucHV0KCJcbiBFTlRFUiBNQVJLUyBPRiBTT0NJQUwgOiAiKSkKICAgIGNvbXB1dGVyID1pbnQoaW5wdXQoIlxuIEVOVEVSIE1BUktTIE9GIENPTVBVVEVSIDogIikpCiAgICB0b3RhbCA9IGhpbmRpICsgZW5nbGlzaCArIG1hdGggKyBzY2llbmNlICsgc29jaWFsICsgY29tcHV0ZXIKICAgIGF2ZXJhZ2UgPSB0b3RhbC82CiAgICBzcWw9IklOU0VSVCBJTlRPIE1BUktTKFNBRE1JU1NJT05fTk8sSElOREksRU5HTElTSCxNQVRILFNDSUVOQ0UsU09DSUFMLENPTVBVVEVSLCBUT1RBTCxBVkVSQUdFKSBWQUxVRVMoJXMsJXMsJXMsJXMsJXMsJXMsJXMsJXMsJXMpIgogICAgdmFsdWVzPShhZG1pc3Npb25fbm8saGluZGksZW5nbGlzaCxtYXRoLHNjaWVuY2Usc29jaWFsLGNvbXB1dGVyICwgdG90YWwgLCBhdmVyYWdlKQogICAgbXljdXJzb3IuZXhlY3V0ZShzcWwsdmFsdWVzKQogICAgbXljdXJzb3IuZXhlY3V0ZSgiQ09NTUlUIikKICAgIG15Y3Vyc29yLmNsb3NlKCkKICAgIHByaW50KCJcbk1hcmtzIG9mIHRoZSBTdHVkZW50IEVudGVyZWQgU3VjY2Vzc2Z1bGx5ICEiKQogCmRlZiByZXBvcnRDYXJkQWxsU3R1ZGVudCAoKSA6CiAgICBteWN1cnNvci5leGVjdXRlKCJTRUxFQ1QgKiBGUk9NIE1BUktTIikKICAgIGRhdGE9bXljdXJzb3IuZmV0Y2hhbGwoKQogICAgcHJpbnQoZGF0YSkKICAgIG15Y3Vyc29yLmNsb3NlKCkKICAgIAojTU9EVUxFIFRPIEdFTkVSQVRFIFJFUE9SVCBDQVJEIE9GIE9ORSBTVFVERU5UUwpkZWYgcmVwb3J0Q2FyZE9uZVN0dWRlbnQoKToKICAgIGFkbWlzc2lvbl9ubz1pbnB1dCgiRU5URVIgQURNSVNTSU9OIE5PIE9GIFRIRSBTVFVERU5UIDoiKQogIAogICAgc3FsPSJTRUxFQ1QgKiBGUk9NIE1BUktTIFdIRVJFIFNBRE1JU1NJT05fTk89ICVzIgogICAgbXljdXJzb3IuZXhlY3V0ZShzcWwsKGFkbWlzc2lvbl9ubywpKQogICAgZGF0YT1teWN1cnNvci5mZXRjaGFsbCgpCiAgICBpZiBkYXRhOgogICAgICAgIHByaW50KGRhdGEpCiAgICBlbHNlOgogICAgICAgIHByaW50KCJSZWNvcmQgTm90IEZvdW5kICwgUGxlYXNlIFRyeSBBZ2FpbiAhIikKICAgICAgICBteWN1cnNvci5jbG9zZSgpCgogICAgCmRlZiBoZWxwTWUoKToKICAgIHByaW50KCJQbGVhc2UsIFZpc2l0IFRoZSBPZmZjaWFsIFdlYnNpdGUgT2YgVmlkeWFsYXlhIFRvIERvd25sb2FkIFRoZSBNYW5udWFsICEhISIpCgpwcmludCgiIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyAjIyMjIyMjIikKd2hpbGUoMSk6CiAgICBwcmludCgifAlFbnRlciAxIC0gIEFkZCBTdHVkZW50CQkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCIpCiAgICBwcmludCgifAlFbnRlciAyIC0gIERpc3BsYXkgU3R1ZGVudCdzIERhdGEuCQkJCQl8IikKICAgIHByaW50KCJ8CUVudGVyIDMgLSAgVXBkYXRlIFN0dWRlbnRzJ3MgRGF0YSAuCQkJCQl8IikKICAgIHByaW50KCJ8CUVudGVyIDQgLSAgQWRkIFN0dWRlbnQncyBNYXJrcyBEZXRhaWwuCQkJCQl8IikKICAgIHByaW50KCJ8CUVudGVyIDUgLSBHZW5lcmF0ZSBBbGwgU3R1ZGVudCdzIFJlcG9ydCBDYXJkLiAgICAgICAgICAgICAgICAgICAgICAgICAgIHwiKQogICAgcHJpbnQoInwJRW50ZXIgNiAtIEdlbmVyYXRlIFN0dWRlbnQgV2lzZSBSZXBvcnQgQ2FyZC4gICAgICAgICAgICAgICAgICAgICAgICAgICAgfCIpCiAgICBwcmludCgifAlFbnRlciA3LSAgRXhpdC4JICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8IikKICAgIHByaW50KCJ8CUVudGVyIDAoWkVSTykgLSBIZWxwLgkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8IikKICAgIGNob2ljZT1pbnQoaW5wdXQoIlBMRUFTRSAgRU5URVIgIFlPVVIgIENIT0lDRSAgOgkiKSkKICAgIGlmIGNob2ljZT09MToKICAgICAgICBuZXdTdHVkZW50KCkKICAgIGVsaWYgY2hvaWNlPT0yOgogICAgICAgIGRpc3BsYXlTdHVkZW50KCkKICAgIGVsaWYgY2hvaWNlPT0zOgogICAgICAgIHVwZGF0ZVN0dWRlbnQoKQogICAgZWxpZiBjaG9pY2U9PTQ6CiAgICAgICAgbWFya3NTdHVkZW50KCkKICAgIGVsaWYgY2hvaWNlPT01OgogICAgICAgIHJlcG9ydENhcmRBbGxTdHVkZW50KCkKICAgIGVsaWYgY2hvaWNlPT02OgogICAgICAgIHJlcG9ydENhcmRPbmVTdHVkZW50KCkKICAgIGVsaWYgY2hvaWNlPT03OgogICAgICAgIHF1aXQoKQogICAgZWxpZiBjaG9pY2U9PTA6CiAgICAgICAgaGVscE1lKCkKICAgIGVsc2U6CiAgICAgICAgcHJpbnQoIlNvcnJ5ICxNYXkgQmUgWW91IEFyZSBHaXZpbmcgTWUgV3JvbmcgSW5wdXQsIFBsZWFzZSBUcnkgQWdhaW4gISEhICIpCg==