#LOGIN MODULE
import mysql.connector as ms
db=ms.connect(host="localhost",user="root",password="suni13",database="library")
cn=db.cursor()
cn.execute("select * from login;")  
#variable rec is list having all rows and column of list
t=0
un=True 
up=False
tuname= " "
pword = " "
 
def login(uname):
    global un
    global up
    tuname=uname
    cn.execute("select * from login")
    rec=cn.fetchall()
    for i in range (0,len(rec)): 
        while un == True: 
            if tuname in rec[i][0]: 
                print("Username found, enter correct password")
                up=True 
                un = False 
                break 
            else: 
                print("Username not found") 
                print("Please try Again") 
                tuname = input("Enter username")
        if up== True:
            break
    if up==True and un == False:
        pword = input("Enter password") 
        for i in range (0,len(rec)): 
            while up== True: 
                if pword in rec[i][1]:
                    print("User Found")
 
 
#CHOICE MODULE
def choice(uname): 
    ch="" #making variable public for whole function 
    if uname=='Admin': 
        print("1 for Adding extra user") 
        print("2 for removing user") 
        print("3 for checking all book") #print all the books in main list 
        print("4 for checking books borrowed")#print all the books in borrowed list along with name 
        print("5 for list of users") 
        print("6 for printing all available books") 
        print("7 for adding extra book") 
        print("8 for removing extra book") 
        print("9 for updating passowrd for this current user") 
        print("M for returning to main menu") 
        print("O for logging out but not exiting the program") 
        print("X for closing the program") 
        ch=input("Please enter choice: ") 
    else: 
        print("A for borrowing book") 
        print("B for returing back book") 
        print("9 for updating passowrd for this current user") 
        print("M for returning to main menu") 
        print("O for logging out and exit") 
        ch=input("Please enter choice: ") 
    ch.upper()
    return ch
 
 
#MANAGER MODULE
import mysql.connector as ms 
from datetime import date 
db=ms.connect(host="localhost",user="root",password="suni13", database="library") 
cn=db.cursor() #login table 
mn=db.cursor() #library table 
def manager(ch,uname): 
    tuname = uname 
    if uname=="Admin" and ch=='1': #proper 
        newname=input("Enter new user name to add")
        newpassword=input("Enter password for new username")
        cn.execute("insert into login values('0','0')".format(newname,newpassword))
        db.commit() 
        print("Task completed") 
        print() 
    elif uname=="Admin" and ch=='2': #proper 
        a = "Admin" 
        cn.execute("select * from login where username!='0' ".format(a))
        rec=cn.fetchall() 
        print("Username        Passwords")
        for i in rec: 
            print(i) 
            deluser=input("Enter username to remove") 
            cn.execute("delete from login where username='(".format(deluser))
            db.commit() 
            print("Task completed") 
            print() 
    elif uname=="Admin" and ch=="3": #done 
        header=["ID"," Borrowed"]
        print(Book_Name,",", Book_Type ,",", Borrower ,",",Date_Borrowed)
        mn.execute("select * from library;") 
        rec=mn.fetchall() 
        try:
            tt.print(list(rec),header,style=tt.styles.rounded,padding=(0,1),) 
        except Exception as e: 
            print("No Book Available")
 
 
#MAINFRAME MODULE
login(tuname)
choice()
manager()
print("********** *LIBRARY MANAGEMENT PROGRAM****************")
uname=input("Enter username") 
uname-uname.login(uname) 
ch-choice.choice(uname) 
print("Entered choice is",ch) 
while True: 
    if ch== 'M' or ch== 'm': 
        ch-choice.choice(uname) 
        print("Entered choice is",ch) 
        manager.manager(ch,uname) 
        continue 
    elif ch== '0': 
        print("Logging out") 
        print("Successfully logged out") 
        print("Please login again to continue") 
        uname = input("Enter username") 
        uname=login.login(uname) 
        print("Logged in as",uname) 
        ch-choice.choice(uname) 
        print("Entered choice is",ch) 
        continue 
    else: 
        manager.manager(ch,uname) 
        ch-choice.choice(uname) 
        print("Entered choice is",ch) 
        continue
 
 
 
 
 

I0xPR0lOIE1PRFVMRQppbXBvcnQgbXlzcWwuY29ubmVjdG9yIGFzIG1zCmRiPW1zLmNvbm5lY3QoaG9zdD0ibG9jYWxob3N0Iix1c2VyPSJyb290IixwYXNzd29yZD0ic3VuaTEzIixkYXRhYmFzZT0ibGlicmFyeSIpCmNuPWRiLmN1cnNvcigpCmNuLmV4ZWN1dGUoInNlbGVjdCAqIGZyb20gbG9naW47IikgIAojdmFyaWFibGUgcmVjIGlzIGxpc3QgaGF2aW5nIGFsbCByb3dzIGFuZCBjb2x1bW4gb2YgbGlzdAp0PTAKdW49VHJ1ZSAKdXA9RmFsc2UKdHVuYW1lPSAiICIKcHdvcmQgPSAiICIKCmRlZiBsb2dpbih1bmFtZSk6CiAgICBnbG9iYWwgdW4KICAgIGdsb2JhbCB1cAogICAgdHVuYW1lPXVuYW1lCiAgICBjbi5leGVjdXRlKCJzZWxlY3QgKiBmcm9tIGxvZ2luIikKICAgIHJlYz1jbi5mZXRjaGFsbCgpCiAgICBmb3IgaSBpbiByYW5nZSAoMCxsZW4ocmVjKSk6IAogICAgICAgIHdoaWxlIHVuID09IFRydWU6IAogICAgICAgICAgICBpZiB0dW5hbWUgaW4gcmVjW2ldWzBdOiAKICAgICAgICAgICAgICAgIHByaW50KCJVc2VybmFtZSBmb3VuZCwgZW50ZXIgY29ycmVjdCBwYXNzd29yZCIpCiAgICAgICAgICAgICAgICB1cD1UcnVlIAogICAgICAgICAgICAgICAgdW4gPSBGYWxzZSAKICAgICAgICAgICAgICAgIGJyZWFrIAogICAgICAgICAgICBlbHNlOiAKICAgICAgICAgICAgICAgIHByaW50KCJVc2VybmFtZSBub3QgZm91bmQiKSAKICAgICAgICAgICAgICAgIHByaW50KCJQbGVhc2UgdHJ5IEFnYWluIikgCiAgICAgICAgICAgICAgICB0dW5hbWUgPSBpbnB1dCgiRW50ZXIgdXNlcm5hbWUiKQogICAgICAgIGlmIHVwPT0gVHJ1ZToKICAgICAgICAgICAgYnJlYWsKICAgIGlmIHVwPT1UcnVlIGFuZCB1biA9PSBGYWxzZToKICAgICAgICBwd29yZCA9IGlucHV0KCJFbnRlciBwYXNzd29yZCIpIAogICAgICAgIGZvciBpIGluIHJhbmdlICgwLGxlbihyZWMpKTogCiAgICAgICAgICAgIHdoaWxlIHVwPT0gVHJ1ZTogCiAgICAgICAgICAgICAgICBpZiBwd29yZCBpbiByZWNbaV1bMV06CiAgICAgICAgICAgICAgICAgICAgcHJpbnQoIlVzZXIgRm91bmQiKQoKCiNDSE9JQ0UgTU9EVUxFCmRlZiBjaG9pY2UodW5hbWUpOiAKICAgIGNoPSIiICNtYWtpbmcgdmFyaWFibGUgcHVibGljIGZvciB3aG9sZSBmdW5jdGlvbiAKICAgIGlmIHVuYW1lPT0nQWRtaW4nOiAKICAgICAgICBwcmludCgiMSBmb3IgQWRkaW5nIGV4dHJhIHVzZXIiKSAKICAgICAgICBwcmludCgiMiBmb3IgcmVtb3ZpbmcgdXNlciIpIAogICAgICAgIHByaW50KCIzIGZvciBjaGVja2luZyBhbGwgYm9vayIpICNwcmludCBhbGwgdGhlIGJvb2tzIGluIG1haW4gbGlzdCAKICAgICAgICBwcmludCgiNCBmb3IgY2hlY2tpbmcgYm9va3MgYm9ycm93ZWQiKSNwcmludCBhbGwgdGhlIGJvb2tzIGluIGJvcnJvd2VkIGxpc3QgYWxvbmcgd2l0aCBuYW1lIAogICAgICAgIHByaW50KCI1IGZvciBsaXN0IG9mIHVzZXJzIikgCiAgICAgICAgcHJpbnQoIjYgZm9yIHByaW50aW5nIGFsbCBhdmFpbGFibGUgYm9va3MiKSAKICAgICAgICBwcmludCgiNyBmb3IgYWRkaW5nIGV4dHJhIGJvb2siKSAKICAgICAgICBwcmludCgiOCBmb3IgcmVtb3ZpbmcgZXh0cmEgYm9vayIpIAogICAgICAgIHByaW50KCI5IGZvciB1cGRhdGluZyBwYXNzb3dyZCBmb3IgdGhpcyBjdXJyZW50IHVzZXIiKSAKICAgICAgICBwcmludCgiTSBmb3IgcmV0dXJuaW5nIHRvIG1haW4gbWVudSIpIAogICAgICAgIHByaW50KCJPIGZvciBsb2dnaW5nIG91dCBidXQgbm90IGV4aXRpbmcgdGhlIHByb2dyYW0iKSAKICAgICAgICBwcmludCgiWCBmb3IgY2xvc2luZyB0aGUgcHJvZ3JhbSIpIAogICAgICAgIGNoPWlucHV0KCJQbGVhc2UgZW50ZXIgY2hvaWNlOiAiKSAKICAgIGVsc2U6IAogICAgICAgIHByaW50KCJBIGZvciBib3Jyb3dpbmcgYm9vayIpIAogICAgICAgIHByaW50KCJCIGZvciByZXR1cmluZyBiYWNrIGJvb2siKSAKICAgICAgICBwcmludCgiOSBmb3IgdXBkYXRpbmcgcGFzc293cmQgZm9yIHRoaXMgY3VycmVudCB1c2VyIikgCiAgICAgICAgcHJpbnQoIk0gZm9yIHJldHVybmluZyB0byBtYWluIG1lbnUiKSAKICAgICAgICBwcmludCgiTyBmb3IgbG9nZ2luZyBvdXQgYW5kIGV4aXQiKSAKICAgICAgICBjaD1pbnB1dCgiUGxlYXNlIGVudGVyIGNob2ljZTogIikgCiAgICBjaC51cHBlcigpCiAgICByZXR1cm4gY2gKCgojTUFOQUdFUiBNT0RVTEUKaW1wb3J0IG15c3FsLmNvbm5lY3RvciBhcyBtcyAKZnJvbSBkYXRldGltZSBpbXBvcnQgZGF0ZSAKZGI9bXMuY29ubmVjdChob3N0PSJsb2NhbGhvc3QiLHVzZXI9InJvb3QiLHBhc3N3b3JkPSJzdW5pMTMiLCBkYXRhYmFzZT0ibGlicmFyeSIpIApjbj1kYi5jdXJzb3IoKSAjbG9naW4gdGFibGUgCm1uPWRiLmN1cnNvcigpICNsaWJyYXJ5IHRhYmxlIApkZWYgbWFuYWdlcihjaCx1bmFtZSk6IAogICAgdHVuYW1lID0gdW5hbWUgCiAgICBpZiB1bmFtZT09IkFkbWluIiBhbmQgY2g9PScxJzogI3Byb3BlciAKICAgICAgICBuZXduYW1lPWlucHV0KCJFbnRlciBuZXcgdXNlciBuYW1lIHRvIGFkZCIpCiAgICAgICAgbmV3cGFzc3dvcmQ9aW5wdXQoIkVudGVyIHBhc3N3b3JkIGZvciBuZXcgdXNlcm5hbWUiKQogICAgICAgIGNuLmV4ZWN1dGUoImluc2VydCBpbnRvIGxvZ2luIHZhbHVlcygnMCcsJzAnKSIuZm9ybWF0KG5ld25hbWUsbmV3cGFzc3dvcmQpKQogICAgICAgIGRiLmNvbW1pdCgpIAogICAgICAgIHByaW50KCJUYXNrIGNvbXBsZXRlZCIpIAogICAgICAgIHByaW50KCkgCiAgICBlbGlmIHVuYW1lPT0iQWRtaW4iIGFuZCBjaD09JzInOiAjcHJvcGVyIAogICAgICAgIGEgPSAiQWRtaW4iIAogICAgICAgIGNuLmV4ZWN1dGUoInNlbGVjdCAqIGZyb20gbG9naW4gd2hlcmUgdXNlcm5hbWUhPScwJyAiLmZvcm1hdChhKSkKICAgICAgICByZWM9Y24uZmV0Y2hhbGwoKSAKICAgICAgICBwcmludCgiVXNlcm5hbWUgICAgICAgIFBhc3N3b3JkcyIpCiAgICAgICAgZm9yIGkgaW4gcmVjOiAKICAgICAgICAgICAgcHJpbnQoaSkgCiAgICAgICAgICAgIGRlbHVzZXI9aW5wdXQoIkVudGVyIHVzZXJuYW1lIHRvIHJlbW92ZSIpIAogICAgICAgICAgICBjbi5leGVjdXRlKCJkZWxldGUgZnJvbSBsb2dpbiB3aGVyZSB1c2VybmFtZT0nKCIuZm9ybWF0KGRlbHVzZXIpKQogICAgICAgICAgICBkYi5jb21taXQoKSAKICAgICAgICAgICAgcHJpbnQoIlRhc2sgY29tcGxldGVkIikgCiAgICAgICAgICAgIHByaW50KCkgCiAgICBlbGlmIHVuYW1lPT0iQWRtaW4iIGFuZCBjaD09IjMiOiAjZG9uZSAKICAgICAgICBoZWFkZXI9WyJJRCIsIiBCb3Jyb3dlZCJdCiAgICAgICAgcHJpbnQoQm9va19OYW1lLCIsIiwgQm9va19UeXBlICwiLCIsIEJvcnJvd2VyICwiLCIsRGF0ZV9Cb3Jyb3dlZCkKICAgICAgICBtbi5leGVjdXRlKCJzZWxlY3QgKiBmcm9tIGxpYnJhcnk7IikgCiAgICAgICAgcmVjPW1uLmZldGNoYWxsKCkgCiAgICAgICAgdHJ5OgogICAgICAgICAgICB0dC5wcmludChsaXN0KHJlYyksaGVhZGVyLHN0eWxlPXR0LnN0eWxlcy5yb3VuZGVkLHBhZGRpbmc9KDAsMSksKSAKICAgICAgICBleGNlcHQgRXhjZXB0aW9uIGFzIGU6IAogICAgICAgICAgICBwcmludCgiTm8gQm9vayBBdmFpbGFibGUiKQoKCiNNQUlORlJBTUUgTU9EVUxFCmxvZ2luKHR1bmFtZSkKY2hvaWNlKCkKbWFuYWdlcigpCnByaW50KCIqKioqKioqKioqICpMSUJSQVJZIE1BTkFHRU1FTlQgUFJPR1JBTSoqKioqKioqKioqKioqKioiKQp1bmFtZT1pbnB1dCgiRW50ZXIgdXNlcm5hbWUiKSAKdW5hbWUtdW5hbWUubG9naW4odW5hbWUpIApjaC1jaG9pY2UuY2hvaWNlKHVuYW1lKSAKcHJpbnQoIkVudGVyZWQgY2hvaWNlIGlzIixjaCkgCndoaWxlIFRydWU6IAogICAgaWYgY2g9PSAnTScgb3IgY2g9PSAnbSc6IAogICAgICAgIGNoLWNob2ljZS5jaG9pY2UodW5hbWUpIAogICAgICAgIHByaW50KCJFbnRlcmVkIGNob2ljZSBpcyIsY2gpIAogICAgICAgIG1hbmFnZXIubWFuYWdlcihjaCx1bmFtZSkgCiAgICAgICAgY29udGludWUgCiAgICBlbGlmIGNoPT0gJzAnOiAKICAgICAgICBwcmludCgiTG9nZ2luZyBvdXQiKSAKICAgICAgICBwcmludCgiU3VjY2Vzc2Z1bGx5IGxvZ2dlZCBvdXQiKSAKICAgICAgICBwcmludCgiUGxlYXNlIGxvZ2luIGFnYWluIHRvIGNvbnRpbnVlIikgCiAgICAgICAgdW5hbWUgPSBpbnB1dCgiRW50ZXIgdXNlcm5hbWUiKSAKICAgICAgICB1bmFtZT1sb2dpbi5sb2dpbih1bmFtZSkgCiAgICAgICAgcHJpbnQoIkxvZ2dlZCBpbiBhcyIsdW5hbWUpIAogICAgICAgIGNoLWNob2ljZS5jaG9pY2UodW5hbWUpIAogICAgICAgIHByaW50KCJFbnRlcmVkIGNob2ljZSBpcyIsY2gpIAogICAgICAgIGNvbnRpbnVlIAogICAgZWxzZTogCiAgICAgICAgbWFuYWdlci5tYW5hZ2VyKGNoLHVuYW1lKSAKICAgICAgICBjaC1jaG9pY2UuY2hvaWNlKHVuYW1lKSAKICAgICAgICBwcmludCgiRW50ZXJlZCBjaG9pY2UgaXMiLGNoKSAKICAgICAgICBjb250aW51ZQoKCgogICAgICAgICAgICAK