Ideone.com

fork download

copy

#***************KENDRIYA VIDYALAYA PALAMPUR **********************" 
#******************VIDYALAYA MANAGER *****************************" 
#*******Designed and Maintained By:" 
#*******AKHIL        - CLASS XII A - ROLL NO - 2  [ 2019-2020 ]" 
#*******HARSH KUMAR  - CLASS XII A - ROLL NO - 7  [ 2019-2020 ]" #*******JAGDISH V.L. - CLASS XII A - ROLL NO - 8  [ 2019-2020 ]" 
 
import mysql.connector 
 
 
# GLOBAL VARIABLES DECLARATION 
 
myConnnection ="" cursor=""- userName="" password ="" 
 
#MODULE TO CHECK  MYSQL CONNECTIVITY def MYSQLconnectionCheck (): 
 
    global myConnection     global userName 
    global password 
 
    userName = input("\n ENTER MYSQL SERVER'S USERNAME : ")     password = input("\n ENTER MYSQL SERVER'S PASSWORD : ") 
 
 
myConnection=mysql.connector.connect(host="localhost",user=userName,passwd
=password , auth_plugin='mysql_native_password' )     if myConnection: 
        print("\n CONGRATULATIONS ! YOUR MYSQL CONNECTION HAS BEEN ESTABLISHED !") 
        cursor=myConnection.cursor() 
        cursor.execute("CREATE DATABASE IF NOT EXISTS SMS")         cursor.execute("COMMIT") 
        cursor.close()         return myConnection     else: 
        print("\nERROR ESTABLISHING MYSQL CONNECTION CHECK 
USERNAME AND PASSWORD !") 
 
 
#MODULE TO ESTABLISHED  MYSQL CONNECTION def MYSQLconnection (): 
 
    global userName     global password 
    global myConnection 
 
 
myConnection=mysql.connector.connect(host="localhost",user=userName,passwd
=password , database="SMS" , auth_plugin='mysql_native_password' )     if myConnection: 
        return myConnection     else: 
        print("\nERROR ESTABLISHING MYSQL CONNECTION !")         myConnection.close() 
 
#MODULE FOR NEW ADMISSION  def newStudent(): 
 
    if myConnection: 
 
        cursor=myConnection.cursor() 
        createTable ="""CREATE TABLE IF NOT EXISTS STUDENT(SNAME VARCHAR(30),FNAME VARCHAR(30),MNAME VARCHAR(30) 
                       ,PHONE 	VARCHAR(12), 	ADDRESS 	VARCHAR(100),SCLASS VARCHAR(5),SSECTION VARCHAR(5), 
                        SROLL_NO VARCHAR(5),SADMISSION_NO VARCHAR(10) 
PRIMARY KEY) 
                     """ 
        cursor.execute(createTable) 
 
        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  :  ")         sroll_no=input(" ENTER ROLL_NO  :  ") 
        sadmission_no=input(" ENTER ADMISSION_NO  :  ") 
 
        sql="INSERT 	INTO 
student(SNAME,FNAME,MNAME,PHONE,ADDRESS,SCLASS,SSECTION,SROLL_
NO,SADMISSION_NO) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)" 
        values=(sname,fname,mname,phone,address 
,sclass,ssection,sroll_no,sadmission_no) 
        cursor.execute(sql,values)         cursor.execute("COMMIT") 
        cursor.close() 
        print("\nNew Student Enrolled Successfully !") 
             else: 
        print("\nERROR ESTABLISHING MYSQL CONNECTION !") 
 
 
#MODULE TO DISPLAY STUDENT'S DATA         def displayStudent(): 
    cursor=myConnection.cursor()     if myConnection: 
        cursor.execute("SELECT * FROM STUDENT")         data=cursor.fetchall() 
        print(data)         cursor.close()     else: 
        print("\nSomthing Went Wrong ,Please Try Again !")   
 
 
#MODULE TO UPDATE STUDENT'S RECORD    def updateStudent(): 
    cursor=myConnection.cursor()     if myConnection: 
        admission_no=input("ENTER ADMISSION NO") 
        sql="SELECT * FROM STUDENT WHERE SADMISSION_NO= %s" 
        cursor.execute(sql,(admission_no,))         data=cursor.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" 
                cursor.execute(sql,(name,admission_no))                 cursor.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" 
                cursor.execute(sql,(std,admission_no))                 cursor.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" 
                cursor.execute(sql,(roll_no,admission_no))                 cursor.execute("COMMIT") 
                print("ROLL NO UPDATED") 
                         else: 
            print("Record Not Found Try Again !")         cursor.close()     else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
 
 
#MODULE TO ENTER MARKS OF THE STUDENT def marksStudent () :     if myConnection: 
 
        cursor=myConnection.cursor() 
        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) 
                     """ 
        cursor.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)         cursor.execute(sql,values)         cursor.execute("COMMIT") 
        cursor.close()         print("\nMarks of the Student Entered Successfully !") 
             else: 
        print("\nERROR ESTABLISHING MYSQL CONNECTION !") 
 
 
#MODULE TO GENERATE REPORT CARD OF ALL STUDENTS         
def reportCardAllStudent () : 
    cursor=myConnection.cursor()     if myConnection: 
        cursor.execute("SELECT * FROM MARKS") 
        data=cursor.fetchall() 
        print(data)         cursor.close()     else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
 
 
#MODULE TO GENERATE REPORT CARD OF ONE STUDENTS            def reportCardOneStudent(): 
    cursor=myConnection.cursor()     if myConnection: 
        admission_no=input("ENTER ADMISSION NO OF THE STUDENT  :")         cursor=myConnection.cursor()         sql="SELECT * FROM MARKS WHERE SADMISSION_NO= %s" 
        cursor.execute(sql,(admission_no,))         data=cursor.fetchall()         if data: 
          print(data)         else: 
            print("Record Not Found , Please Try Again !")         cursor.close() 
                 else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
 
 
#MODULE TO ENTER FEES OF THE STUDENTS    def feeStudent () :     if myConnection: 
 
        cursor=myConnection.cursor() 
        createTable ="""CREATE TABLE IF NOT EXISTS FEES(SADMISSION_NO VARCHAR(10) PRIMARY KEY,MONTH INT ,TUTION_FEES INT,VVN INT 
,COMPUTER_FEES INT , 
                        MUSIC_FEES INT, TOTAL INT) 
                     """ 
        cursor.execute(createTable) 
        admission_no=input("ENTER ADMISSION NO OF THE STUDENT  :")         month=int(input("\n ENTER MONTH IN NUMERIC FORM (1-12) :  ")) 
        tutionfee=int(input("\n ENTER TUTION FEES  :  "))         vvn=int(input("\n ENTER VVN  :  ")) 
        computerfee=int(input("\n ENTER COMPUTER FEES  :  "))         musicfee=int(input("\n ENTER MUSIC FEES  :  "))         total = tutionfee + vvn + computerfee + musicfee         sql="INSERT 	INTO 
FEES(SADMISSION_NO,MONTH,TUTION_FEES,VVN,COMPUTER_FEES,MUSIC_ FEES,TOTAL) VALUES(%s,%s,%s,%s,%s,%s,%s)" 
        values=(admission_no,month,tutionfee,vvn,computerfee,musicfee,total)         cursor.execute(sql,values)         cursor.execute("COMMIT") 
        cursor.close() 
        print("\nFees of Student Accepted Successfully !") 
             else: 
        print("\nERROR ESTABLISHING MYSQL CONNECTION !") 
 
 
#MODULE TO GENERATE FEES RECEIPT OF ALL STUDENTS   def feeReceiptAllStudent(): 
    cursor=myConnection.cursor()     if myConnection: 
        cursor.execute("SELECT * FROM FEES") 
        data=cursor.fetchall() 
        print(data)         cursor.close()     else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
 
 
#MODULE TO GENERATE FEES RECEIPT OF ONE STUDENT def feeReceiptOneStudent(): 
    cursor=myConnection.cursor()     if myConnection: 
        admission_no=input("ENTER ADMISSION NO OF THE STUDENT  :")         cursor=myConnection.cursor() 
        sql="SELECT * FROM FEES WHERE SADMISSION_NO= %s"         cursor.execute(sql,(admission_no,))         data=cursor.fetchall()         if data: 
          print(data)         else: 
            print("Record Not Found , Please Try Again !")         cursor.close() 
                 else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
 
 
#MODULE TO ISSUE TRANSFER CERTIFICATE    def transferStudent(): 
    cursor=myConnection.cursor() 
    if myConnection: 
        admission_no=input("ENTER ADMISSION NO OF THE STUDENT  :")         cursor=myConnection.cursor() 
        sql="SELECT * FROM STUDENT WHERE SADMISSION_NO= %s"         cursor.execute(sql,(admission_no,))         data=cursor.fetchall()         if data: 
          sql=("DELETE FROM STUDENT WHERE SADMISSION_NO=%s")           cursor.execute(sql,(admission_no,))           cursor.execute("COMMIT")           print("Student's Transfer Certificate Generated !!!")         else: 
            print("Record Not Found , Please Try Again !")         cursor.close() 
                 else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
 
 
#MODULE TO PROVIDE HELP FOR USER    def helpMe(): 
    print("Please, Visit The Offcial Website Of Vidyalaya To Download The Mannual 
!!!") 
 
 
 
# MAIN SCREEN OF THE SYSTEM 
print("############################################################# #######") 
 
print("\n|--------------------SESSION 2019 - 2020 ----------------------|")   
print("\n|                          WELCOME                             |")                                      print("\n|             KENDRIYA VIDYALAYA PALAMPUR HOLTA                |") print("\n|********************VIDYALAYA MANAGER  ***********************|") print("\n|******************DESIGNED AND MAINTAINED BY:*****************|") print("\n|*************AKHIL        - CLASS XII A - ROLL NO - 2 ********|") print("\n|*************HARSH KUMAR  - CLASS XII A - ROLL NO - 7 ********|") print("\n|*************JAGDISH V.L. - CLASS XII A - ROLL NO - 8 ********|") 
print("\n|--------------------------------------------------------------|") print("\n|                   VIDYALAYA MANAGER                          |") print("\n|--------------------------------------------------------------|") 
 
print("############################################################# #######") 
 
 
 
#STARTING POINT OF THE SYSTEM 
 
myConnection = MYSQLconnectionCheck () if myConnection:  MYSQLconnection ()  while(1): 
 
    print("|-------------------------------------------------------------|")     print("|              Enter 1 -  New Admission.                      |")     print("|              Enter 2 -  Display Student's Data.             |")     print("|              Enter 3 -  Update Students's Data .            |")     print("|              Enter 4 -  Issue Transfer Certififcate .       |")     print("|              Enter 5 -  Add Student's Marks Detail.         |")     print("|              Enter 6 -  Generate All Student's Report Card. |")     print("|              Enter 7 -  Generate Student Wise Report Card.  |")     print("|              Enter 8 -  Pay Student's Fee.                  |")     print("|              Enter 9 -  Generate Student Wise Fees Receipt. |")     print("|              Enter 10 - Generate Student's Fee Receipt.     |") 
    print("|              Enter 11-  Exit.                               |")     print("|-------------------------------------------------------------|")     print("|              Enter 0(ZERO) - Help.                          |")     print("|-------------------------------------------------------------|") 
 
    choice=int(input("PLEASE ENTER YOUR CHOICE :   "))     if choice==1:         newStudent()     elif choice==2: 
        displayStudent()     elif choice==3: 
 
         updateStudent()     elif choice==4: 
         transferStudent()     elif choice==5: 
         marksStudent()     elif choice==6: 
         reportCardAllStudent()     elif choice==7: 
         reportCardOneStudent()          elif choice==8:          feeStudent()     elif choice==9: 
         feeReceiptAllStudent()     elif choice==10: 
         feeReceiptOneStudent()     elif choice==11: 
         myConnection.close() 
         break     elif choice==0:          helpMe()     else:         print("Sorry ,May Be You Are Giving Me Wrong Input, Please Try Again !!!  ") else: 
  print("Check Your MYSQL Connection First !!!  ") 
 
 
# END OF THE PROJECT

IyoqKioqKioqKioqKioqKktFTkRSSVlBIFZJRFlBTEFZQSBQQUxBTVBVUiAqKioqKioqKioqKioqKioqKioqKioqIiAKIyoqKioqKioqKioqKioqKioqKlZJRFlBTEFZQSBNQU5BR0VSICoqKioqKioqKioqKioqKioqKioqKioqKioqKioqIiAKIyoqKioqKipEZXNpZ25lZCBhbmQgTWFpbnRhaW5lZCBCeToiIAojKioqKioqKkFLSElMICAgICAgICAtIENMQVNTIFhJSSBBIC0gUk9MTCBOTyAtIDIgIFsgMjAxOS0yMDIwIF0iIAojKioqKioqKkhBUlNIIEtVTUFSICAtIENMQVNTIFhJSSBBIC0gUk9MTCBOTyAtIDcgIFsgMjAxOS0yMDIwIF0iICMqKioqKioqSkFHRElTSCBWLkwuIC0gQ0xBU1MgWElJIEEgLSBST0xMIE5PIC0gOCAgWyAyMDE5LTIwMjAgXSIgCiAKaW1wb3J0IG15c3FsLmNvbm5lY3RvciAKIAogCiMgR0xPQkFMIFZBUklBQkxFUyBERUNMQVJBVElPTiAKIApteUNvbm5uZWN0aW9uID0iIiBjdXJzb3I9IiItIHVzZXJOYW1lPSIiIHBhc3N3b3JkID0iIiAKIAojTU9EVUxFIFRPIENIRUNLICBNWVNRTCBDT05ORUNUSVZJVFkgZGVmIE1ZU1FMY29ubmVjdGlvbkNoZWNrICgpOiAKICAgICAKICAgIGdsb2JhbCBteUNvbm5lY3Rpb24gICAgIGdsb2JhbCB1c2VyTmFtZSAKICAgIGdsb2JhbCBwYXNzd29yZCAKIAogICAgdXNlck5hbWUgPSBpbnB1dCgiXG4gRU5URVIgTVlTUUwgU0VSVkVSJ1MgVVNFUk5BTUUgOiAiKSAgICAgcGFzc3dvcmQgPSBpbnB1dCgiXG4gRU5URVIgTVlTUUwgU0VSVkVSJ1MgUEFTU1dPUkQgOiAiKSAKICAgICAgICAgCiAgICAKbXlDb25uZWN0aW9uPW15c3FsLmNvbm5lY3Rvci5jb25uZWN0KGhvc3Q9ImxvY2FsaG9zdCIsdXNlcj11c2VyTmFtZSxwYXNzd2QKPXBhc3N3b3JkICwgYXV0aF9wbHVnaW49J215c3FsX25hdGl2ZV9wYXNzd29yZCcgKSAgICAgaWYgbXlDb25uZWN0aW9uOiAKICAgICAgICBwcmludCgiXG4gQ09OR1JBVFVMQVRJT05TICEgWU9VUiBNWVNRTCBDT05ORUNUSU9OIEhBUyBCRUVOIEVTVEFCTElTSEVEICEiKSAKICAgICAgICBjdXJzb3I9bXlDb25uZWN0aW9uLmN1cnNvcigpIAogICAgICAgIGN1cnNvci5leGVjdXRlKCJDUkVBVEUgREFUQUJBU0UgSUYgTk9UIEVYSVNUUyBTTVMiKSAgICAgICAgIGN1cnNvci5leGVjdXRlKCJDT01NSVQiKSAKICAgICAgICBjdXJzb3IuY2xvc2UoKSAgICAgICAgIHJldHVybiBteUNvbm5lY3Rpb24gICAgIGVsc2U6IAogICAgICAgIHByaW50KCJcbkVSUk9SIEVTVEFCTElTSElORyBNWVNRTCBDT05ORUNUSU9OIENIRUNLIApVU0VSTkFNRSBBTkQgUEFTU1dPUkQgISIpIAogICAgICAgICAKIAojTU9EVUxFIFRPIEVTVEFCTElTSEVEICBNWVNRTCBDT05ORUNUSU9OIGRlZiBNWVNRTGNvbm5lY3Rpb24gKCk6IAogICAgIAogICAgZ2xvYmFsIHVzZXJOYW1lICAgICBnbG9iYWwgcGFzc3dvcmQgCiAgICBnbG9iYWwgbXlDb25uZWN0aW9uIAogICAgIAogICAgCm15Q29ubmVjdGlvbj1teXNxbC5jb25uZWN0b3IuY29ubmVjdChob3N0PSJsb2NhbGhvc3QiLHVzZXI9dXNlck5hbWUscGFzc3dkCj1wYXNzd29yZCAsIGRhdGFiYXNlPSJTTVMiICwgYXV0aF9wbHVnaW49J215c3FsX25hdGl2ZV9wYXNzd29yZCcgKSAgICAgaWYgbXlDb25uZWN0aW9uOiAKICAgICAgICByZXR1cm4gbXlDb25uZWN0aW9uICAgICBlbHNlOiAKICAgICAgICBwcmludCgiXG5FUlJPUiBFU1RBQkxJU0hJTkcgTVlTUUwgQ09OTkVDVElPTiAhIikgICAgICAgICBteUNvbm5lY3Rpb24uY2xvc2UoKSAKIAojTU9EVUxFIEZPUiBORVcgQURNSVNTSU9OICBkZWYgbmV3U3R1ZGVudCgpOiAKICAgICAKICAgIGlmIG15Q29ubmVjdGlvbjogCiAgICAgICAgIAogICAgICAgIGN1cnNvcj1teUNvbm5lY3Rpb24uY3Vyc29yKCkgCiAgICAgICAgY3JlYXRlVGFibGUgPSIiIkNSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIFNUVURFTlQoU05BTUUgVkFSQ0hBUigzMCksRk5BTUUgVkFSQ0hBUigzMCksTU5BTUUgVkFSQ0hBUigzMCkgCiAgICAgICAgICAgICAgICAgICAgICAgLFBIT05FIAlWQVJDSEFSKDEyKSwgCUFERFJFU1MgCVZBUkNIQVIoMTAwKSxTQ0xBU1MgVkFSQ0hBUig1KSxTU0VDVElPTiBWQVJDSEFSKDUpLCAKICAgICAgICAgICAgICAgICAgICAgICAgU1JPTExfTk8gVkFSQ0hBUig1KSxTQURNSVNTSU9OX05PIFZBUkNIQVIoMTApIApQUklNQVJZIEtFWSkgCiAgICAgICAgICAgICAgICAgICAgICIiIiAKICAgICAgICBjdXJzb3IuZXhlY3V0ZShjcmVhdGVUYWJsZSkgCiAgICAgICAgIAogICAgICAgIHNuYW1lPWlucHV0KCJcbiBFTlRFUiBTVFVERU5UJ1MgTkFNRSAgOiAgIikgICAgICAgICBmbmFtZT1pbnB1dCgiIEVOVEVSIEZBVEhFUidTIE5BTUUgIDogICIpICAgICAgICAgbW5hbWU9aW5wdXQoIiBFTlRFUiBNT1RIRVInUyBOQU1FICA6ICAiKSAgICAgICAgIHBob25lPWlucHV0KCIgRU5URVIgQ09OVEFDVCBOTy4gIDogICIpICAgICAgICAgYWRkcmVzcz1pbnB1dCgiIEVOVEVSIEFERFJFU1MgIDogICIpICAgICAgICAgc2NsYXNzID1pbnB1dCgiIEVOVEVSIENMQVNTICA6ICAiKSAgICAgICAgIHNzZWN0aW9uPWlucHV0KCIgRU5URVIgU0VDVElPTiAgOiAgIikgICAgICAgICBzcm9sbF9ubz1pbnB1dCgiIEVOVEVSIFJPTExfTk8gIDogICIpIAogICAgICAgIHNhZG1pc3Npb25fbm89aW5wdXQoIiBFTlRFUiBBRE1JU1NJT05fTk8gIDogICIpIAogICAgICAgICAKICAgICAgICBzcWw9IklOU0VSVCAJSU5UTyAKc3R1ZGVudChTTkFNRSxGTkFNRSxNTkFNRSxQSE9ORSxBRERSRVNTLFNDTEFTUyxTU0VDVElPTixTUk9MTF8KTk8sU0FETUlTU0lPTl9OTykgVkFMVUVTKCVzLCVzLCVzLCVzLCVzLCVzLCVzLCVzLCVzKSIgCiAgICAgICAgdmFsdWVzPShzbmFtZSxmbmFtZSxtbmFtZSxwaG9uZSxhZGRyZXNzIAosc2NsYXNzLHNzZWN0aW9uLHNyb2xsX25vLHNhZG1pc3Npb25fbm8pIAogICAgICAgIGN1cnNvci5leGVjdXRlKHNxbCx2YWx1ZXMpICAgICAgICAgY3Vyc29yLmV4ZWN1dGUoIkNPTU1JVCIpIAogICAgICAgIGN1cnNvci5jbG9zZSgpIAogICAgICAgIHByaW50KCJcbk5ldyBTdHVkZW50IEVucm9sbGVkIFN1Y2Nlc3NmdWxseSAhIikgCiAgICAgICAgICAgICBlbHNlOiAKICAgICAgICBwcmludCgiXG5FUlJPUiBFU1RBQkxJU0hJTkcgTVlTUUwgQ09OTkVDVElPTiAhIikgCiAgICAgICAgIAogCiNNT0RVTEUgVE8gRElTUExBWSBTVFVERU5UJ1MgREFUQSAgICAgICAgIGRlZiBkaXNwbGF5U3R1ZGVudCgpOiAKICAgIGN1cnNvcj1teUNvbm5lY3Rpb24uY3Vyc29yKCkgICAgIGlmIG15Q29ubmVjdGlvbjogCiAgICAgICAgY3Vyc29yLmV4ZWN1dGUoIlNFTEVDVCAqIEZST00gU1RVREVOVCIpICAgICAgICAgZGF0YT1jdXJzb3IuZmV0Y2hhbGwoKSAKICAgICAgICBwcmludChkYXRhKSAgICAgICAgIGN1cnNvci5jbG9zZSgpICAgICBlbHNlOiAKICAgICAgICBwcmludCgiXG5Tb210aGluZyBXZW50IFdyb25nICxQbGVhc2UgVHJ5IEFnYWluICEiKSAgIAogCiAKI01PRFVMRSBUTyBVUERBVEUgU1RVREVOVCdTIFJFQ09SRCAgICBkZWYgdXBkYXRlU3R1ZGVudCgpOiAKICAgIGN1cnNvcj1teUNvbm5lY3Rpb24uY3Vyc29yKCkgICAgIGlmIG15Q29ubmVjdGlvbjogCiAgICAgICAgYWRtaXNzaW9uX25vPWlucHV0KCJFTlRFUiBBRE1JU1NJT04gTk8iKSAKICAgICAgICBzcWw9IlNFTEVDVCAqIEZST00gU1RVREVOVCBXSEVSRSBTQURNSVNTSU9OX05PPSAlcyIgCiAgICAgICAgY3Vyc29yLmV4ZWN1dGUoc3FsLChhZG1pc3Npb25fbm8sKSkgICAgICAgICBkYXRhPWN1cnNvci5mZXRjaGFsbCgpICAgICAgICAgaWYgZGF0YTogCiAgICAgICAgICAgIHByaW50KCJQUkVTUyAxIEZPUiBOQU1FIikgICAgICAgICAgICAgcHJpbnQoIlBSRVNTIDIgRk9SIENMQVNTIikgICAgICAgICAgICAgcHJpbnQoIlBSRVNTIDMgRk9SIFJPTEwgTk8iKSAgICAgICAgICAgICBjaG9pY2U9aW50KGlucHV0KCJFbnRlciBZb3VyIENob2ljZSIpKSAgICAgICAgICAgICBpZiBjaG9pY2U9PTE6IAogICAgICAgICAgICAgICAgbmFtZT1pbnB1dCgiRU5URVIgTkFNRSBPRiBUSEUgU1RVREVOVCAgOiIpIAogICAgICAgICAgICAgICAgc3FsPSJVUERBVEUgU1RVREVOVCBTRVQgU05BTUU9ICVzIFdIRVJFIFNBRE1JU1NJT05fTk8gPSAKJXMiIAogICAgICAgICAgICAgICAgY3Vyc29yLmV4ZWN1dGUoc3FsLChuYW1lLGFkbWlzc2lvbl9ubykpICAgICAgICAgICAgICAgICBjdXJzb3IuZXhlY3V0ZSgiQ09NTUlUIikgCiAgICAgICAgICAgICAgICBwcmludCgiTkFNRSBVUERBVEVEIikgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgZWxpZiBjaG9pY2UgPT0gMjogCiAgICAgICAgICAgICAgICBzdGQ9aW5wdXQoIkVOVEVSIENMQVNTIE9GIFRIRSBTVFVERU5UICA6IikgCiAgICAgICAgICAgICAgICBzcWw9IlVQREFURSBTVFVERU5UIFNFVCBTQ0xBU1M9ICVzIFdIRVJFIFNBRE1JU1NJT05fTk89IAolcyIgCiAgICAgICAgICAgICAgICBjdXJzb3IuZXhlY3V0ZShzcWwsKHN0ZCxhZG1pc3Npb25fbm8pKSAgICAgICAgICAgICAgICAgY3Vyc29yLmV4ZWN1dGUoIkNPTU1JVCIpIAogICAgICAgICAgICAgICAgcHJpbnQoIkNMQVNTIFVQREFURUQiKSAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICBlbGlmIGNob2ljZT09MzogCiAgICAgICAgICAgICAgICByb2xsX25vPWludChpbnB1dCgiRU5URVIgUk9MTCBOTyBPRiBUSEUgU1RVREVOVCAgOiIpKSAgICAgICAgICAgICAgICAgc3FsPSJVUERBVEUgCVNUVURFTlQgCVNFVCAJU1JPTExfTk89IAklcyAJV0hFUkUgU0FETUlTU0lPTl9OTyA9ICVzIiAKICAgICAgICAgICAgICAgIGN1cnNvci5leGVjdXRlKHNxbCwocm9sbF9ubyxhZG1pc3Npb25fbm8pKSAgICAgICAgICAgICAgICAgY3Vyc29yLmV4ZWN1dGUoIkNPTU1JVCIpIAogICAgICAgICAgICAgICAgcHJpbnQoIlJPTEwgTk8gVVBEQVRFRCIpIAogICAgICAgICAgICAgICAgICAgICAgICAgZWxzZTogCiAgICAgICAgICAgIHByaW50KCJSZWNvcmQgTm90IEZvdW5kIFRyeSBBZ2FpbiAhIikgICAgICAgICBjdXJzb3IuY2xvc2UoKSAgICAgZWxzZTogCiAgICAgICAgcHJpbnQoIlxuU29tdGhpbmcgV2VudCBXcm9uZyAsUGxlYXNlIFRyeSBBZ2FpbiAhIikgCiAgICAgICAgIAogICAgICAgICAKI01PRFVMRSBUTyBFTlRFUiBNQVJLUyBPRiBUSEUgU1RVREVOVCBkZWYgbWFya3NTdHVkZW50ICgpIDogICAgIGlmIG15Q29ubmVjdGlvbjogCiAgICAgICAgIAogICAgICAgIGN1cnNvcj1teUNvbm5lY3Rpb24uY3Vyc29yKCkgCiAgICAgICAgY3JlYXRlVGFibGUgPSIiIkNSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIE1BUktTKFNBRE1JU1NJT05fTk8gVkFSQ0hBUigxMCkgUFJJTUFSWSBLRVksSElOREkgSU5ULEVOR0xJU0ggSU5UICxNQVRIIElOVCAsIAogICAgICAgICAgICAgICAgICAgICAgICBTQ0lFTkNFIElOVCxTT0NJQUwgSU5ULENPTVBVVEVSIElOVCxUT1RBTCBJTlQgLEFWRVJBR0UgCkRFQ0lNQUwpIAogICAgICAgICAgICAgICAgICAgICAiIiIgCiAgICAgICAgY3Vyc29yLmV4ZWN1dGUoY3JlYXRlVGFibGUpIAogICAgICAgIGFkbWlzc2lvbl9ubz1pbnB1dCgiRU5URVIgQURNSVNTSU9OIE5PIE9GIFRIRSBTVFVERU5UICA6IikgCiAgICAgICAgaGluZGk9aW50KGlucHV0KCJcbiBFTlRFUiBNQVJLUyBPRiBISU5ESSAgOiAgIikpICAgICAgICAgZW5nbGlzaD1pbnQoaW5wdXQoIlxuIEVOVEVSIE1BUktTIE9GIEVOR0xJU0ggIDogICIpKSAgICAgICAgIG1hdGg9aW50KGlucHV0KCJcbiBFTlRFUiBNQVJLUyBPRiBNQVRIICA6ICAiKSkgICAgICAgICBzY2llbmNlPWludChpbnB1dCgiXG4gRU5URVIgTUFSS1MgT0YgU0NJRU5DRSAgOiAgIikpICAgICAgICAgc29jaWFsPWludChpbnB1dCgiXG4gRU5URVIgTUFSS1MgT0YgU09DSUFMICA6ICAiKSkgICAgICAgICBjb21wdXRlciA9aW50KGlucHV0KCJcbiBFTlRFUiBNQVJLUyBPRiBDT01QVVRFUiAgOiAgIikpICAgICAgICAgdG90YWwgPSBoaW5kaSArIGVuZ2xpc2ggKyBtYXRoICsgc2NpZW5jZSArIHNvY2lhbCArIGNvbXB1dGVyICAgICAgICAgYXZlcmFnZSA9IHRvdGFsLzYgCiAgICAgICAgc3FsPSJJTlNFUlQgCUlOVE8gCk1BUktTKFNBRE1JU1NJT05fTk8sSElOREksRU5HTElTSCxNQVRILFNDSUVOQ0UsU09DSUFMLENPTVBVVEVSLCBUT1RBTCxBVkVSQUdFKSBWQUxVRVMoJXMsJXMsJXMsJXMsJXMsJXMsJXMsJXMsJXMpIiAKICAgICAgICB2YWx1ZXM9KGFkbWlzc2lvbl9ubyxoaW5kaSxlbmdsaXNoLG1hdGgsc2NpZW5jZSxzb2NpYWwsY29tcHV0ZXIgLCB0b3RhbCAsIGF2ZXJhZ2UpICAgICAgICAgY3Vyc29yLmV4ZWN1dGUoc3FsLHZhbHVlcykgICAgICAgICBjdXJzb3IuZXhlY3V0ZSgiQ09NTUlUIikgCiAgICAgICAgY3Vyc29yLmNsb3NlKCkgICAgICAgICBwcmludCgiXG5NYXJrcyBvZiB0aGUgU3R1ZGVudCBFbnRlcmVkIFN1Y2Nlc3NmdWxseSAhIikgCiAgICAgICAgICAgICBlbHNlOiAKICAgICAgICBwcmludCgiXG5FUlJPUiBFU1RBQkxJU0hJTkcgTVlTUUwgQ09OTkVDVElPTiAhIikgCiAgICAgICAgIAogCiNNT0RVTEUgVE8gR0VORVJBVEUgUkVQT1JUIENBUkQgT0YgQUxMIFNUVURFTlRTICAgICAgICAgCmRlZiByZXBvcnRDYXJkQWxsU3R1ZGVudCAoKSA6IAogICAgY3Vyc29yPW15Q29ubmVjdGlvbi5jdXJzb3IoKSAgICAgaWYgbXlDb25uZWN0aW9uOiAKICAgICAgICBjdXJzb3IuZXhlY3V0ZSgiU0VMRUNUICogRlJPTSBNQVJLUyIpIAogICAgICAgIGRhdGE9Y3Vyc29yLmZldGNoYWxsKCkgCiAgICAgICAgcHJpbnQoZGF0YSkgICAgICAgICBjdXJzb3IuY2xvc2UoKSAgICAgZWxzZTogCiAgICAgICAgcHJpbnQoIlxuU29tdGhpbmcgV2VudCBXcm9uZyAsUGxlYXNlIFRyeSBBZ2FpbiAhIikgCiAKIAojTU9EVUxFIFRPIEdFTkVSQVRFIFJFUE9SVCBDQVJEIE9GIE9ORSBTVFVERU5UUyAgICAgICAgICAgIGRlZiByZXBvcnRDYXJkT25lU3R1ZGVudCgpOiAKICAgIGN1cnNvcj1teUNvbm5lY3Rpb24uY3Vyc29yKCkgICAgIGlmIG15Q29ubmVjdGlvbjogCiAgICAgICAgYWRtaXNzaW9uX25vPWlucHV0KCJFTlRFUiBBRE1JU1NJT04gTk8gT0YgVEhFIFNUVURFTlQgIDoiKSAgICAgICAgIGN1cnNvcj1teUNvbm5lY3Rpb24uY3Vyc29yKCkgICAgICAgICBzcWw9IlNFTEVDVCAqIEZST00gTUFSS1MgV0hFUkUgU0FETUlTU0lPTl9OTz0gJXMiIAogICAgICAgIGN1cnNvci5leGVjdXRlKHNxbCwoYWRtaXNzaW9uX25vLCkpICAgICAgICAgZGF0YT1jdXJzb3IuZmV0Y2hhbGwoKSAgICAgICAgIGlmIGRhdGE6IAogICAgICAgICAgcHJpbnQoZGF0YSkgICAgICAgICBlbHNlOiAKICAgICAgICAgICAgcHJpbnQoIlJlY29yZCBOb3QgRm91bmQgLCBQbGVhc2UgVHJ5IEFnYWluICEiKSAgICAgICAgIGN1cnNvci5jbG9zZSgpIAogICAgICAgICAgICAgICAgIGVsc2U6IAogICAgICAgIHByaW50KCJcblNvbXRoaW5nIFdlbnQgV3JvbmcgLFBsZWFzZSBUcnkgQWdhaW4gISIpIAogICAgICAgICAKIAojTU9EVUxFIFRPIEVOVEVSIEZFRVMgT0YgVEhFIFNUVURFTlRTICAgIGRlZiBmZWVTdHVkZW50ICgpIDogICAgIGlmIG15Q29ubmVjdGlvbjogCiAgICAgICAgIAogICAgICAgIGN1cnNvcj1teUNvbm5lY3Rpb24uY3Vyc29yKCkgCiAgICAgICAgY3JlYXRlVGFibGUgPSIiIkNSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIEZFRVMoU0FETUlTU0lPTl9OTyBWQVJDSEFSKDEwKSBQUklNQVJZIEtFWSxNT05USCBJTlQgLFRVVElPTl9GRUVTIElOVCxWVk4gSU5UIAosQ09NUFVURVJfRkVFUyBJTlQgLCAKICAgICAgICAgICAgICAgICAgICAgICAgTVVTSUNfRkVFUyBJTlQsIFRPVEFMIElOVCkgCiAgICAgICAgICAgICAgICAgICAgICIiIiAKICAgICAgICBjdXJzb3IuZXhlY3V0ZShjcmVhdGVUYWJsZSkgCiAgICAgICAgYWRtaXNzaW9uX25vPWlucHV0KCJFTlRFUiBBRE1JU1NJT04gTk8gT0YgVEhFIFNUVURFTlQgIDoiKSAgICAgICAgIG1vbnRoPWludChpbnB1dCgiXG4gRU5URVIgTU9OVEggSU4gTlVNRVJJQyBGT1JNICgxLTEyKSA6ICAiKSkgCiAgICAgICAgdHV0aW9uZmVlPWludChpbnB1dCgiXG4gRU5URVIgVFVUSU9OIEZFRVMgIDogICIpKSAgICAgICAgIHZ2bj1pbnQoaW5wdXQoIlxuIEVOVEVSIFZWTiAgOiAgIikpIAogICAgICAgIGNvbXB1dGVyZmVlPWludChpbnB1dCgiXG4gRU5URVIgQ09NUFVURVIgRkVFUyAgOiAgIikpICAgICAgICAgbXVzaWNmZWU9aW50KGlucHV0KCJcbiBFTlRFUiBNVVNJQyBGRUVTICA6ICAiKSkgICAgICAgICB0b3RhbCA9IHR1dGlvbmZlZSArIHZ2biArIGNvbXB1dGVyZmVlICsgbXVzaWNmZWUgICAgICAgICBzcWw9IklOU0VSVCAJSU5UTyAKRkVFUyhTQURNSVNTSU9OX05PLE1PTlRILFRVVElPTl9GRUVTLFZWTixDT01QVVRFUl9GRUVTLE1VU0lDXyBGRUVTLFRPVEFMKSBWQUxVRVMoJXMsJXMsJXMsJXMsJXMsJXMsJXMpIiAKICAgICAgICB2YWx1ZXM9KGFkbWlzc2lvbl9ubyxtb250aCx0dXRpb25mZWUsdnZuLGNvbXB1dGVyZmVlLG11c2ljZmVlLHRvdGFsKSAgICAgICAgIGN1cnNvci5leGVjdXRlKHNxbCx2YWx1ZXMpICAgICAgICAgY3Vyc29yLmV4ZWN1dGUoIkNPTU1JVCIpIAogICAgICAgIGN1cnNvci5jbG9zZSgpIAogICAgICAgIHByaW50KCJcbkZlZXMgb2YgU3R1ZGVudCBBY2NlcHRlZCBTdWNjZXNzZnVsbHkgISIpIAogICAgICAgICAgICAgZWxzZTogCiAgICAgICAgcHJpbnQoIlxuRVJST1IgRVNUQUJMSVNISU5HIE1ZU1FMIENPTk5FQ1RJT04gISIpIAogICAgICAgICAKIAojTU9EVUxFIFRPIEdFTkVSQVRFIEZFRVMgUkVDRUlQVCBPRiBBTEwgU1RVREVOVFMgICBkZWYgZmVlUmVjZWlwdEFsbFN0dWRlbnQoKTogCiAgICBjdXJzb3I9bXlDb25uZWN0aW9uLmN1cnNvcigpICAgICBpZiBteUNvbm5lY3Rpb246IAogICAgICAgIGN1cnNvci5leGVjdXRlKCJTRUxFQ1QgKiBGUk9NIEZFRVMiKSAKICAgICAgICBkYXRhPWN1cnNvci5mZXRjaGFsbCgpIAogICAgICAgIHByaW50KGRhdGEpICAgICAgICAgY3Vyc29yLmNsb3NlKCkgICAgIGVsc2U6IAogICAgICAgIHByaW50KCJcblNvbXRoaW5nIFdlbnQgV3JvbmcgLFBsZWFzZSBUcnkgQWdhaW4gISIpIAogICAgICAgICAKIAojTU9EVUxFIFRPIEdFTkVSQVRFIEZFRVMgUkVDRUlQVCBPRiBPTkUgU1RVREVOVCBkZWYgZmVlUmVjZWlwdE9uZVN0dWRlbnQoKTogCiAgICBjdXJzb3I9bXlDb25uZWN0aW9uLmN1cnNvcigpICAgICBpZiBteUNvbm5lY3Rpb246IAogICAgICAgIGFkbWlzc2lvbl9ubz1pbnB1dCgiRU5URVIgQURNSVNTSU9OIE5PIE9GIFRIRSBTVFVERU5UICA6IikgICAgICAgICBjdXJzb3I9bXlDb25uZWN0aW9uLmN1cnNvcigpIAogICAgICAgIHNxbD0iU0VMRUNUICogRlJPTSBGRUVTIFdIRVJFIFNBRE1JU1NJT05fTk89ICVzIiAgICAgICAgIGN1cnNvci5leGVjdXRlKHNxbCwoYWRtaXNzaW9uX25vLCkpICAgICAgICAgZGF0YT1jdXJzb3IuZmV0Y2hhbGwoKSAgICAgICAgIGlmIGRhdGE6IAogICAgICAgICAgcHJpbnQoZGF0YSkgICAgICAgICBlbHNlOiAKICAgICAgICAgICAgcHJpbnQoIlJlY29yZCBOb3QgRm91bmQgLCBQbGVhc2UgVHJ5IEFnYWluICEiKSAgICAgICAgIGN1cnNvci5jbG9zZSgpIAogICAgICAgICAgICAgICAgIGVsc2U6IAogICAgICAgIHByaW50KCJcblNvbXRoaW5nIFdlbnQgV3JvbmcgLFBsZWFzZSBUcnkgQWdhaW4gISIpIAogICAgICAgICAKIAojTU9EVUxFIFRPIElTU1VFIFRSQU5TRkVSIENFUlRJRklDQVRFICAgIGRlZiB0cmFuc2ZlclN0dWRlbnQoKTogCiAgICBjdXJzb3I9bXlDb25uZWN0aW9uLmN1cnNvcigpIAogICAgaWYgbXlDb25uZWN0aW9uOiAKICAgICAgICBhZG1pc3Npb25fbm89aW5wdXQoIkVOVEVSIEFETUlTU0lPTiBOTyBPRiBUSEUgU1RVREVOVCAgOiIpICAgICAgICAgY3Vyc29yPW15Q29ubmVjdGlvbi5jdXJzb3IoKSAKICAgICAgICBzcWw9IlNFTEVDVCAqIEZST00gU1RVREVOVCBXSEVSRSBTQURNSVNTSU9OX05PPSAlcyIgICAgICAgICBjdXJzb3IuZXhlY3V0ZShzcWwsKGFkbWlzc2lvbl9ubywpKSAgICAgICAgIGRhdGE9Y3Vyc29yLmZldGNoYWxsKCkgICAgICAgICBpZiBkYXRhOiAKICAgICAgICAgIHNxbD0oIkRFTEVURSBGUk9NIFNUVURFTlQgV0hFUkUgU0FETUlTU0lPTl9OTz0lcyIpICAgICAgICAgICBjdXJzb3IuZXhlY3V0ZShzcWwsKGFkbWlzc2lvbl9ubywpKSAgICAgICAgICAgY3Vyc29yLmV4ZWN1dGUoIkNPTU1JVCIpICAgICAgICAgICBwcmludCgiU3R1ZGVudCdzIFRyYW5zZmVyIENlcnRpZmljYXRlIEdlbmVyYXRlZCAhISEiKSAgICAgICAgIGVsc2U6IAogICAgICAgICAgICBwcmludCgiUmVjb3JkIE5vdCBGb3VuZCAsIFBsZWFzZSBUcnkgQWdhaW4gISIpICAgICAgICAgY3Vyc29yLmNsb3NlKCkgCiAgICAgICAgICAgICAgICAgZWxzZTogCiAgICAgICAgcHJpbnQoIlxuU29tdGhpbmcgV2VudCBXcm9uZyAsUGxlYXNlIFRyeSBBZ2FpbiAhIikgCiAgICAgICAgIAogCiNNT0RVTEUgVE8gUFJPVklERSBIRUxQIEZPUiBVU0VSICAgIGRlZiBoZWxwTWUoKTogCiAgICBwcmludCgiUGxlYXNlLCBWaXNpdCBUaGUgT2ZmY2lhbCBXZWJzaXRlIE9mIFZpZHlhbGF5YSBUbyBEb3dubG9hZCBUaGUgTWFubnVhbCAKISEhIikgCiAgICAgCiAKICAgIAojIE1BSU4gU0NSRUVOIE9GIFRIRSBTWVNURU0gCnByaW50KCIjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjICMjIyMjIyMiKSAKIApwcmludCgiXG58LS0tLS0tLS0tLS0tLS0tLS0tLS1TRVNTSU9OIDIwMTkgLSAyMDIwIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS18IikgICAKcHJpbnQoIlxufCAgICAgICAgICAgICAgICAgICAgICAgICAgV0VMQ09NRSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCIpICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBwcmludCgiXG58ICAgICAgICAgICAgIEtFTkRSSVlBIFZJRFlBTEFZQSBQQUxBTVBVUiBIT0xUQSAgICAgICAgICAgICAgICB8IikgcHJpbnQoIlxufCoqKioqKioqKioqKioqKioqKioqVklEWUFMQVlBIE1BTkFHRVIgICoqKioqKioqKioqKioqKioqKioqKioqfCIpIHByaW50KCJcbnwqKioqKioqKioqKioqKioqKipERVNJR05FRCBBTkQgTUFJTlRBSU5FRCBCWToqKioqKioqKioqKioqKioqKnwiKSBwcmludCgiXG58KioqKioqKioqKioqKkFLSElMICAgICAgICAtIENMQVNTIFhJSSBBIC0gUk9MTCBOTyAtIDIgKioqKioqKip8IikgcHJpbnQoIlxufCoqKioqKioqKioqKipIQVJTSCBLVU1BUiAgLSBDTEFTUyBYSUkgQSAtIFJPTEwgTk8gLSA3ICoqKioqKioqfCIpIHByaW50KCJcbnwqKioqKioqKioqKioqSkFHRElTSCBWLkwuIC0gQ0xBU1MgWElJIEEgLSBST0xMIE5PIC0gOCAqKioqKioqKnwiKSAKcHJpbnQoIlxufC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tfCIpIHByaW50KCJcbnwgICAgICAgICAgICAgICAgICAgVklEWUFMQVlBIE1BTkFHRVIgICAgICAgICAgICAgICAgICAgICAgICAgIHwiKSBwcmludCgiXG58LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS18IikgCiAKcHJpbnQoIiMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMgIyMjIyMjIyIpIAogCiAKIAojU1RBUlRJTkcgUE9JTlQgT0YgVEhFIFNZU1RFTSAKIApteUNvbm5lY3Rpb24gPSBNWVNRTGNvbm5lY3Rpb25DaGVjayAoKSBpZiBteUNvbm5lY3Rpb246ICBNWVNRTGNvbm5lY3Rpb24gKCkgIHdoaWxlKDEpOiAKICAgIAogICAgcHJpbnQoInwtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tfCIpICAgICBwcmludCgifCAgICAgICAgICAgICAgRW50ZXIgMSAtICBOZXcgQWRtaXNzaW9uLiAgICAgICAgICAgICAgICAgICAgICB8IikgICAgIHByaW50KCJ8ICAgICAgICAgICAgICBFbnRlciAyIC0gIERpc3BsYXkgU3R1ZGVudCdzIERhdGEuICAgICAgICAgICAgIHwiKSAgICAgcHJpbnQoInwgICAgICAgICAgICAgIEVudGVyIDMgLSAgVXBkYXRlIFN0dWRlbnRzJ3MgRGF0YSAuICAgICAgICAgICAgfCIpICAgICBwcmludCgifCAgICAgICAgICAgICAgRW50ZXIgNCAtICBJc3N1ZSBUcmFuc2ZlciBDZXJ0aWZpZmNhdGUgLiAgICAgICB8IikgICAgIHByaW50KCJ8ICAgICAgICAgICAgICBFbnRlciA1IC0gIEFkZCBTdHVkZW50J3MgTWFya3MgRGV0YWlsLiAgICAgICAgIHwiKSAgICAgcHJpbnQoInwgICAgICAgICAgICAgIEVudGVyIDYgLSAgR2VuZXJhdGUgQWxsIFN0dWRlbnQncyBSZXBvcnQgQ2FyZC4gfCIpICAgICBwcmludCgifCAgICAgICAgICAgICAgRW50ZXIgNyAtICBHZW5lcmF0ZSBTdHVkZW50IFdpc2UgUmVwb3J0IENhcmQuICB8IikgICAgIHByaW50KCJ8ICAgICAgICAgICAgICBFbnRlciA4IC0gIFBheSBTdHVkZW50J3MgRmVlLiAgICAgICAgICAgICAgICAgIHwiKSAgICAgcHJpbnQoInwgICAgICAgICAgICAgIEVudGVyIDkgLSAgR2VuZXJhdGUgU3R1ZGVudCBXaXNlIEZlZXMgUmVjZWlwdC4gfCIpICAgICBwcmludCgifCAgICAgICAgICAgICAgRW50ZXIgMTAgLSBHZW5lcmF0ZSBTdHVkZW50J3MgRmVlIFJlY2VpcHQuICAgICB8IikgCiAgICBwcmludCgifCAgICAgICAgICAgICAgRW50ZXIgMTEtICBFeGl0LiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8IikgICAgIHByaW50KCJ8LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLXwiKSAgICAgcHJpbnQoInwgICAgICAgICAgICAgIEVudGVyIDAoWkVSTykgLSBIZWxwLiAgICAgICAgICAgICAgICAgICAgICAgICAgfCIpICAgICBwcmludCgifC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS18IikgCiAgICAgCiAgICBjaG9pY2U9aW50KGlucHV0KCJQTEVBU0UgRU5URVIgWU9VUiBDSE9JQ0UgOiAgICIpKSAgICAgaWYgY2hvaWNlPT0xOiAgICAgICAgIG5ld1N0dWRlbnQoKSAgICAgZWxpZiBjaG9pY2U9PTI6IAogICAgICAgIGRpc3BsYXlTdHVkZW50KCkgICAgIGVsaWYgY2hvaWNlPT0zOiAKICAgICAgICAgCiAgICAgICAgIHVwZGF0ZVN0dWRlbnQoKSAgICAgZWxpZiBjaG9pY2U9PTQ6IAogICAgICAgICB0cmFuc2ZlclN0dWRlbnQoKSAgICAgZWxpZiBjaG9pY2U9PTU6IAogICAgICAgICBtYXJrc1N0dWRlbnQoKSAgICAgZWxpZiBjaG9pY2U9PTY6IAogICAgICAgICByZXBvcnRDYXJkQWxsU3R1ZGVudCgpICAgICBlbGlmIGNob2ljZT09NzogCiAgICAgICAgIHJlcG9ydENhcmRPbmVTdHVkZW50KCkgICAgICAgICAgZWxpZiBjaG9pY2U9PTg6ICAgICAgICAgIGZlZVN0dWRlbnQoKSAgICAgZWxpZiBjaG9pY2U9PTk6IAogICAgICAgICBmZWVSZWNlaXB0QWxsU3R1ZGVudCgpICAgICBlbGlmIGNob2ljZT09MTA6IAogICAgICAgICBmZWVSZWNlaXB0T25lU3R1ZGVudCgpICAgICBlbGlmIGNob2ljZT09MTE6IAogICAgICAgICBteUNvbm5lY3Rpb24uY2xvc2UoKSAKICAgICAgICAgYnJlYWsgICAgIGVsaWYgY2hvaWNlPT0wOiAgICAgICAgICBoZWxwTWUoKSAgICAgZWxzZTogICAgICAgICBwcmludCgiU29ycnkgLE1heSBCZSBZb3UgQXJlIEdpdmluZyBNZSBXcm9uZyBJbnB1dCwgUGxlYXNlIFRyeSBBZ2FpbiAhISEgICIpIGVsc2U6IAogIHByaW50KCJDaGVjayBZb3VyIE1ZU1FMIENvbm5lY3Rpb24gRmlyc3QgISEhICAiKSAKICAgCiAKIyBFTkQgT0YgVEhFIFBST0pFQ1Qg4oCDCg==

Success #stdin #stdout 0.03s 25308KB

stdin

copy

Standard input is empty

stdout

copy

#***************KENDRIYA VIDYALAYA PALAMPUR **********************" 
#******************VIDYALAYA MANAGER *****************************" 
#*******Designed and Maintained By:" 
#*******AKHIL        - CLASS XII A - ROLL NO - 2  [ 2019-2020 ]" 
#*******HARSH KUMAR  - CLASS XII A - ROLL NO - 7  [ 2019-2020 ]" #*******JAGDISH V.L. - CLASS XII A - ROLL NO - 8  [ 2019-2020 ]" 
 
import mysql.connector 
 
 
# GLOBAL VARIABLES DECLARATION 
 
myConnnection ="" cursor=""- userName="" password ="" 
 
#MODULE TO CHECK  MYSQL CONNECTIVITY def MYSQLconnectionCheck (): 
     
    global myConnection     global userName 
    global password 
 
    userName = input("\n ENTER MYSQL SERVER'S USERNAME : ")     password = input("\n ENTER MYSQL SERVER'S PASSWORD : ") 
         
    
myConnection=mysql.connector.connect(host="localhost",user=userName,passwd
=password , auth_plugin='mysql_native_password' )     if myConnection: 
        print("\n CONGRATULATIONS ! YOUR MYSQL CONNECTION HAS BEEN ESTABLISHED !") 
        cursor=myConnection.cursor() 
        cursor.execute("CREATE DATABASE IF NOT EXISTS SMS")         cursor.execute("COMMIT") 
        cursor.close()         return myConnection     else: 
        print("\nERROR ESTABLISHING MYSQL CONNECTION CHECK 
USERNAME AND PASSWORD !") 
         
 
#MODULE TO ESTABLISHED  MYSQL CONNECTION def MYSQLconnection (): 
     
    global userName     global password 
    global myConnection 
     
    
myConnection=mysql.connector.connect(host="localhost",user=userName,passwd
=password , database="SMS" , auth_plugin='mysql_native_password' )     if myConnection: 
        return myConnection     else: 
        print("\nERROR ESTABLISHING MYSQL CONNECTION !")         myConnection.close() 
 
#MODULE FOR NEW ADMISSION  def newStudent(): 
     
    if myConnection: 
         
        cursor=myConnection.cursor() 
        createTable ="""CREATE TABLE IF NOT EXISTS STUDENT(SNAME VARCHAR(30),FNAME VARCHAR(30),MNAME VARCHAR(30) 
                       ,PHONE 	VARCHAR(12), 	ADDRESS 	VARCHAR(100),SCLASS VARCHAR(5),SSECTION VARCHAR(5), 
                        SROLL_NO VARCHAR(5),SADMISSION_NO VARCHAR(10) 
PRIMARY KEY) 
                     """ 
        cursor.execute(createTable) 
         
        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  :  ")         sroll_no=input(" ENTER ROLL_NO  :  ") 
        sadmission_no=input(" ENTER ADMISSION_NO  :  ") 
         
        sql="INSERT 	INTO 
student(SNAME,FNAME,MNAME,PHONE,ADDRESS,SCLASS,SSECTION,SROLL_
NO,SADMISSION_NO) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)" 
        values=(sname,fname,mname,phone,address 
,sclass,ssection,sroll_no,sadmission_no) 
        cursor.execute(sql,values)         cursor.execute("COMMIT") 
        cursor.close() 
        print("\nNew Student Enrolled Successfully !") 
             else: 
        print("\nERROR ESTABLISHING MYSQL CONNECTION !") 
         
 
#MODULE TO DISPLAY STUDENT'S DATA         def displayStudent(): 
    cursor=myConnection.cursor()     if myConnection: 
        cursor.execute("SELECT * FROM STUDENT")         data=cursor.fetchall() 
        print(data)         cursor.close()     else: 
        print("\nSomthing Went Wrong ,Please Try Again !")   
 
 
#MODULE TO UPDATE STUDENT'S RECORD    def updateStudent(): 
    cursor=myConnection.cursor()     if myConnection: 
        admission_no=input("ENTER ADMISSION NO") 
        sql="SELECT * FROM STUDENT WHERE SADMISSION_NO= %s" 
        cursor.execute(sql,(admission_no,))         data=cursor.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" 
                cursor.execute(sql,(name,admission_no))                 cursor.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" 
                cursor.execute(sql,(std,admission_no))                 cursor.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" 
                cursor.execute(sql,(roll_no,admission_no))                 cursor.execute("COMMIT") 
                print("ROLL NO UPDATED") 
                         else: 
            print("Record Not Found Try Again !")         cursor.close()     else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
         
         
#MODULE TO ENTER MARKS OF THE STUDENT def marksStudent () :     if myConnection: 
         
        cursor=myConnection.cursor() 
        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) 
                     """ 
        cursor.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)         cursor.execute(sql,values)         cursor.execute("COMMIT") 
        cursor.close()         print("\nMarks of the Student Entered Successfully !") 
             else: 
        print("\nERROR ESTABLISHING MYSQL CONNECTION !") 
         
 
#MODULE TO GENERATE REPORT CARD OF ALL STUDENTS         
def reportCardAllStudent () : 
    cursor=myConnection.cursor()     if myConnection: 
        cursor.execute("SELECT * FROM MARKS") 
        data=cursor.fetchall() 
        print(data)         cursor.close()     else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
 
 
#MODULE TO GENERATE REPORT CARD OF ONE STUDENTS            def reportCardOneStudent(): 
    cursor=myConnection.cursor()     if myConnection: 
        admission_no=input("ENTER ADMISSION NO OF THE STUDENT  :")         cursor=myConnection.cursor()         sql="SELECT * FROM MARKS WHERE SADMISSION_NO= %s" 
        cursor.execute(sql,(admission_no,))         data=cursor.fetchall()         if data: 
          print(data)         else: 
            print("Record Not Found , Please Try Again !")         cursor.close() 
                 else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
         
 
#MODULE TO ENTER FEES OF THE STUDENTS    def feeStudent () :     if myConnection: 
         
        cursor=myConnection.cursor() 
        createTable ="""CREATE TABLE IF NOT EXISTS FEES(SADMISSION_NO VARCHAR(10) PRIMARY KEY,MONTH INT ,TUTION_FEES INT,VVN INT 
,COMPUTER_FEES INT , 
                        MUSIC_FEES INT, TOTAL INT) 
                     """ 
        cursor.execute(createTable) 
        admission_no=input("ENTER ADMISSION NO OF THE STUDENT  :")         month=int(input("\n ENTER MONTH IN NUMERIC FORM (1-12) :  ")) 
        tutionfee=int(input("\n ENTER TUTION FEES  :  "))         vvn=int(input("\n ENTER VVN  :  ")) 
        computerfee=int(input("\n ENTER COMPUTER FEES  :  "))         musicfee=int(input("\n ENTER MUSIC FEES  :  "))         total = tutionfee + vvn + computerfee + musicfee         sql="INSERT 	INTO 
FEES(SADMISSION_NO,MONTH,TUTION_FEES,VVN,COMPUTER_FEES,MUSIC_ FEES,TOTAL) VALUES(%s,%s,%s,%s,%s,%s,%s)" 
        values=(admission_no,month,tutionfee,vvn,computerfee,musicfee,total)         cursor.execute(sql,values)         cursor.execute("COMMIT") 
        cursor.close() 
        print("\nFees of Student Accepted Successfully !") 
             else: 
        print("\nERROR ESTABLISHING MYSQL CONNECTION !") 
         
 
#MODULE TO GENERATE FEES RECEIPT OF ALL STUDENTS   def feeReceiptAllStudent(): 
    cursor=myConnection.cursor()     if myConnection: 
        cursor.execute("SELECT * FROM FEES") 
        data=cursor.fetchall() 
        print(data)         cursor.close()     else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
         
 
#MODULE TO GENERATE FEES RECEIPT OF ONE STUDENT def feeReceiptOneStudent(): 
    cursor=myConnection.cursor()     if myConnection: 
        admission_no=input("ENTER ADMISSION NO OF THE STUDENT  :")         cursor=myConnection.cursor() 
        sql="SELECT * FROM FEES WHERE SADMISSION_NO= %s"         cursor.execute(sql,(admission_no,))         data=cursor.fetchall()         if data: 
          print(data)         else: 
            print("Record Not Found , Please Try Again !")         cursor.close() 
                 else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
         
 
#MODULE TO ISSUE TRANSFER CERTIFICATE    def transferStudent(): 
    cursor=myConnection.cursor() 
    if myConnection: 
        admission_no=input("ENTER ADMISSION NO OF THE STUDENT  :")         cursor=myConnection.cursor() 
        sql="SELECT * FROM STUDENT WHERE SADMISSION_NO= %s"         cursor.execute(sql,(admission_no,))         data=cursor.fetchall()         if data: 
          sql=("DELETE FROM STUDENT WHERE SADMISSION_NO=%s")           cursor.execute(sql,(admission_no,))           cursor.execute("COMMIT")           print("Student's Transfer Certificate Generated !!!")         else: 
            print("Record Not Found , Please Try Again !")         cursor.close() 
                 else: 
        print("\nSomthing Went Wrong ,Please Try Again !") 
         
 
#MODULE TO PROVIDE HELP FOR USER    def helpMe(): 
    print("Please, Visit The Offcial Website Of Vidyalaya To Download The Mannual 
!!!") 
     
 
    
# MAIN SCREEN OF THE SYSTEM 
print("############################################################# #######") 
 
print("\n|--------------------SESSION 2019 - 2020 ----------------------|")   
print("\n|                          WELCOME                             |")                                      print("\n|             KENDRIYA VIDYALAYA PALAMPUR HOLTA                |") print("\n|********************VIDYALAYA MANAGER  ***********************|") print("\n|******************DESIGNED AND MAINTAINED BY:*****************|") print("\n|*************AKHIL        - CLASS XII A - ROLL NO - 2 ********|") print("\n|*************HARSH KUMAR  - CLASS XII A - ROLL NO - 7 ********|") print("\n|*************JAGDISH V.L. - CLASS XII A - ROLL NO - 8 ********|") 
print("\n|--------------------------------------------------------------|") print("\n|                   VIDYALAYA MANAGER                          |") print("\n|--------------------------------------------------------------|") 
 
print("############################################################# #######") 
 
 
 
#STARTING POINT OF THE SYSTEM 
 
myConnection = MYSQLconnectionCheck () if myConnection:  MYSQLconnection ()  while(1): 
    
    print("|-------------------------------------------------------------|")     print("|              Enter 1 -  New Admission.                      |")     print("|              Enter 2 -  Display Student's Data.             |")     print("|              Enter 3 -  Update Students's Data .            |")     print("|              Enter 4 -  Issue Transfer Certififcate .       |")     print("|              Enter 5 -  Add Student's Marks Detail.         |")     print("|              Enter 6 -  Generate All Student's Report Card. |")     print("|              Enter 7 -  Generate Student Wise Report Card.  |")     print("|              Enter 8 -  Pay Student's Fee.                  |")     print("|              Enter 9 -  Generate Student Wise Fees Receipt. |")     print("|              Enter 10 - Generate Student's Fee Receipt.     |") 
    print("|              Enter 11-  Exit.                               |")     print("|-------------------------------------------------------------|")     print("|              Enter 0(ZERO) - Help.                          |")     print("|-------------------------------------------------------------|") 
     
    choice=int(input("PLEASE ENTER YOUR CHOICE :   "))     if choice==1:         newStudent()     elif choice==2: 
        displayStudent()     elif choice==3: 
         
         updateStudent()     elif choice==4: 
         transferStudent()     elif choice==5: 
         marksStudent()     elif choice==6: 
         reportCardAllStudent()     elif choice==7: 
         reportCardOneStudent()          elif choice==8:          feeStudent()     elif choice==9: 
         feeReceiptAllStudent()     elif choice==10: 
         feeReceiptOneStudent()     elif choice==11: 
         myConnection.close() 
         break     elif choice==0:          helpMe()     else:         print("Sorry ,May Be You Are Giving Me Wrong Input, Please Try Again !!!  ") else: 
  print("Check Your MYSQL Connection First !!!  ") 
   
 
# END OF THE PROJECT

https://ideone.com/ixZf1q

language:

PHP (php 7.3.5)

created:

visibility:

public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!

Discover > Sphere Engine API

Discover > IDE Widget

Choose your language