def deletion_menu(): cursor.execute("USE _ctf_c_t") sp.call('clear',shell=True) print('======================= Deletion Menu =======================') print('1)--> Demolition of a Venue') print('2)--> Back to main menu') print('-------------------------------------------------------------') inp = int(input("Enter Option:- ")) deletion(inp)
def print_table(inp): if inp == 9: main_menu() elif inp == 1: print('======================= Region =======================',end="\n\n") sql = "select * from `region`" print("") elif inp==2: print('======================= Team =======================',end="\n\n") sql = "select * from `team`" print("") elif inp==3: print('======================= Venue =======================',end="\n\n") sql = "select * from `venue`" print("") elif inp==4: print('======================= Player =======================',end="\n\n") sql = "select * from `player`" print("") elif inp==5: print('======================= Player Type =======================',end="\n\n") sql = "select * from `player_type`" print("") elif inp==6: print('======================= Battle =======================',end="\n\n") sql = "select * from `battle`" print("") elif inp==7: print('======================= Attacker =======================',end="\n\n") sql = "select * from `attacker`" print("") elif inp==8: print('======================= Defender =======================',end="\n\n") sql = "select * `defender`" print("") else: report_menu() cursor.execute(sql) result=cursor.fetchall() print(result) inp = input("Enter any key to go back to the main menu> ") main_menu()
def updation_menu(): cursor.execute("USE _ctf_c_t") sp.call('clear',shell=True) print('======================= Updation Menu =======================') print('1)--> Updating records of attacker after every match') print('2)--> Updating records of defender after every match') print('3)--> Updating venue if there is relocation') print('4)--> Updating age of player to -1 if he dies') print('5)--> Back to Main Menu') print('-------------------------------------------------------------') inp = int(input("Enter Option:- ")) updation(inp)
def create_tables(): cursor.execute("USE {}".format(DB_NAME)) for table_name in TABLES: table_description = TABLES[table_name] try: print("--> Creating table {} ".format(table_name), end="") cursor.execute(table_description) except mysql.connector.Error as err: if err.errno == errorcode.ER_TABLE_EXISTS_ERROR: print(" ; table {} exists".format(table_name)) else: print(err.msg) time.sleep(1)
def report_menu(): cursor.execute("USE _ctf_c_t") sp.call('clear',shell=True) print('======================= Report Menu =======================') print('1)--> Number of wins for each team') print('2)--> Best attacker of the competition') print('3)--> Best defender of the competition') print('4)--> Highest individual score of an attacker') print('5)--> Number of players who are both attackers and defenders') print('6)--> Back to Main Menu') print('-----------------------------------------------------------') inp = int(input("Enter Option:- ")) generate_report(inp)
def deletion(inp): if inp==1: print('======================= Deletion =======================',end="\n\n") sql = "SELECT * FROM venue;" cursor.execute(sql) result=cursor.fetchall() print("The venue list -->",end="\n\n") print(result,end="\n\n") sql = "SELECT * FROM `match`;" cursor.execute(sql) result=cursor.fetchall() print("The match list -->",end="\n\n") print(result,end="\n\n") Venue_ID_Demolish=int(input("enter the venue ID you want to delete > ")) Venue_ID_Replace=int(input("enter the venue ID of the replacement for the match > ")) sql = "UPDATE `match` SET Venue_ID = '%d' WHERE Venue_ID = '%d'" %(Venue_ID_Replace, Venue_ID_Demolish) cursor.execute(sql) db.commit() sql = "DELETE FROM venue WHERE (Venue_ID = '%d')" %(Venue_ID_Demolish) cursor.execute(sql) db.commit() print('--> The venue has been succesfully deleted!') elif inp==2: main_menu() else: deletion_menu() inp = input("Enter any key to go back to the main menu> ") main_menu()
def insertion_menu(): cursor.execute("USE _ctf_c_t") sp.call('clear',shell=True) print('======================= Insertion Menu =======================') print('1)--> Insertion of a New Player into a Team') print('2)--> Insertion of a New Team into the Competition') print('3)--> Insertion of a New Defender record if an Attacker starts Defending') print('4)--> Insertion of a New Attacker record if a Defender starts Attacking') print('5)--> Insertion of a New Venue if a new stadium is constructed') print('6)--> Inserting the MVP entry after a match is over') print('7)--> Inserting the Won By entry after the match is over') print('8)--> Back to Main menu') print('--------------------------------------------------------------') inp = int(input("Enter Option:- ")) insertion(inp)
def show_table(): cursor.execute("USE _ctf_c_t") sp.call('clear',shell=True) print('======================= Select Table =======================') print('1)--> Region') print('2)--> Team') print('3)--> Venue') print('4)--> Player') print('5)--> Player Type') print('6)--> Battle') print('7)--> Attacker') print('8)--> Defender') print('9)--> Back to Main Menu') print('-----------------------------------------------------------') inp = int(input("Enter Option:- ")) print_table(inp)
def generate_report(inp): if inp == 6: main_menu() elif inp == 1: print('======================= Report =======================',end="\n\n") print("Number of wins per team [wins, teamID]") sql = "SELECT COUNT(M.WonBy) \"COUNT\", T.Team_ID FROM `match` as M, `team` as T WHERE WonBy IS NOT NULL AND T.Team_ID = M.WonBy GROUP BY T.Team_ID" print("") elif inp==2: print('======================= Report =======================',end="\n\n") print('Best Attacker of the competition [Player ID, Username]') sql = "SELECT Player_ID, Username from player WHERE Player_ID = (SELECT Player_ID from attacker WHERE points = (SELECT MAX(Points) FROM attacker))" print("") elif inp==3: print('======================= Report =======================',end="\n\n") print('Best Defender of the competition [Player ID, Username]') sql = "SELECT Player_ID, Username FROM player WHERE Player_ID = (SELECT Player_ID FROM defender WHERE Traps_Triggered = (SELECT MAX(Traps_Triggered) FROM defender))" print("") elif inp==4: print('======================= Report =======================',end="\n\n") print('Highest Individual Scorer of Competition [Player ID, Username]') sql = "SELECT Player_ID, Username FROM player WHERE Player_ID=(SELECT Player_ID FROM attacker WHERE Highscore = (SELECT MAX(Highscore) FROM attacker))" print("") elif inp==5: print('======================= Report =======================',end="\n\n") print('Number of all rounders in the competition (both attackers and defenders)') sql = "SELECT COUNT(*) FROM (SELECT PLayer_ID, COUNT(Player_ID) FROM player_type GROUP BY Player_ID HAVING COUNT(Player_ID)=2) A" print("") else: report_menu() cursor.execute(sql) result=cursor.fetchall() print(result) inp = input("Enter any key to go back to the main menu> ") main_menu()
def dump_data(): cursor.execute("USE {}".format(DB_NAME)) # ======================= Region Data Dump ======================= try: sql = "INSERT INTO `region` (Region_ID, RName) VALUES (%s,%s)" val = [("1", "South East Asia"), ("2", "North America"), ("3", "South America"), ("4", "Australia"), ("5", "Europe")] cursor.executemany(sql, val) print('-->Region data has been dumped') except: print('-->Region dump data already exists!') # ======================= Team Data Dump ======================= try: sql = "INSERT INTO `team` (Team_ID, TeamName, Coach, Region_ID) VALUES (%s,%s,%s,%s)" val = [("110", "Virtus Pro", "Sream", "1"), ("120", "Cloud9", "Shroud", "2"), ("130", "Australis", "J0hn", "3"), ("140", "ENCE", "DeviCe", "4"), ("150", "NaVi", "kennyS", "5")] cursor.executemany(sql, val) print('-->Team data has been dumped!') except: print('-->Team dump data already exists!') # ======================= Venue Data Dump ======================= try: sql = "INSERT INTO `venue` (Venue_ID, Venue) VALUES (%s,%s)" val = [("68", "Gachibowli Stadium"), ("69", "Lords Stadium"), ("70", "IEM Katowice"), ("20", "IEM Sydney"), ("21", "Buckingham Palace")] cursor.executemany(sql, val) print('-->Venue data has been dumped!') except: print('-->Venue dump data already exists!') # ======================= Match Data Dump ======================= try: sql = "INSERT INTO `match` (TID1, TID2, WonBy, MVP, Day, Venue_ID) VALUES (%s,%s,%s,%s,%s,%s)" val = [("110", "120", "110", "111", "1", "68"), ("130", "150", "150", "152", "2", "70"), ("120", "140", "120", "121", "2", "69"), ("110", "130", "110", "112", "3", "68"), ("140", "150", "140", "141", "3", "21"), ("140", "130", "130", "131", "4", "20"), ("150", "120", None, None, "4", "69"), ("140", "150", None, None, "5", "69"), ("130", "110", None, None, "6", "68")] cursor.executemany(sql, val) print('-->Match data has been dumped!') except: print('-->Match dump data already exists!') # ======================= Player Data Dump ======================= try: sql = "INSERT INTO `player` (PLayer_ID, Username, Age, Team_ID, Captain_ID) VALUES (%s,%s,%s,%s,%s)" val = [("111", "Mu5H1E", "21", "110", "111"), ("112", "Critikal", "19", "110", "111"), ("113", "Champ12134", "24", "110", "111"), ("114", "Negative", "16", "110", "111"), ("121", "Peter", "30", "120", "121"), ("122", "HarryPotter", "20", "120", "121"), ("131", "Vijay", "21", "130", "131"), ("132", "Siddarth", "20", "130", "131"), ("141", "Saud", "29", "140", "142"), ("142", "Sharaf", "27", "140", "142"), ("151", "Zakariya", "21", "150", "151"), ("152", "Razzak", "20", "150", "151")] cursor.executemany(sql, val) print('-->Player data has been dumped!') except: print('-->Player dump data already exists!') # ======================= Player Type Data Dump ======================= try: sql = "INSERT INTO `player_type` (Player_ID,Type) VALUES (%s,%s)" val = [("111", "Attacker"), ("111", "Defender"), ("112", "Attacker"), ("112", "Defender"), ("113", "Attacker"), ("114", "Attacker"), ("121", "Attacker"), ("122", "Attacker"), ("122", "Defender"), ("131", "Attacker"), ("131", "Defender"), ("132", "Defender"), ("141", "Attacker"), ("141", "Defender"), ("142", "Attacker")] cursor.executemany(sql, val) print('-->Player type data has been dumped!') except: print('-->Player type dump data already exists!') # ======================= Battle Data Dump ======================= try: sql = "INSERT INTO `battle` (TID1,TID2,Team_ID,Venue_ID,PLayer_ID) VALUES (%s,%s,%s,%s,%s)" val = [("110", "120", "110", "68", "111"), ("110", "120", "110", "68", "112"), ("110", "120", "110", "68", "113"), ("110", "120", "110", "68", "114"), ("110", "120", "120", "68", "121"), ("110", "120", "120", "68", "122"), ("130", "150", "130", "69", "131"), ("130", "150", "130", "69", "132"), ("130", "150", "150", "69", "151"), ("130", "150", "150", "69", "152")] cursor.executemany(sql, val) print('-->Battle data has been dumped!') except: print('-->Battle dump data already exists!') # ======================= Defender Data Dump ======================= try: sql = "INSERT INTO `defender` (Player_ID,Battles_Played,Points_Given,Traps_Triggered,Avg_Defence) VALUES (%s,%s,%s,%s,%s)" val = [("111", "404", "1324", "342", "4"), ("112", "4", "25", "12", "2"), ("122", "234", "2353", "12", "196"), ("131", "87", "456", "10", "46"), ("132", "123", "2082", "243", "8"), ("141", "27", "1324", "45", "29")] cursor.executemany(sql, val) print('-->Defender data has been dumped!') except: print('-->Defender dump data already exists!') # ======================= Attacker Data Dump ======================= try: sql = "INSERT INTO `attacker` (Player_ID,Points,Battles_Played,Battles_No_Deaths,Avg_Attack,Highscore) VALUES (%s,%s,%s,%s,%s,%s)" val = [("111", "18456", "404", "48", "52", "200"), ("112", "4", "3", "478", "478", "254"), ("113", "11578", "240", "20", "53", "183"), ("114", "8467", "125", "11", "74", "264"), ("121", "6456", "304", "25", "23", "156"), ("122", "3457", "234", "8", "15", "99"), ("131", "2076", "87", "6", "26", "124"), ("141", "786", "27", "1", "30", "67"), ("142", "1256", "54", "6", "26", "163")] cursor.executemany(sql, val) print('-->Attacker data has been dumped!') except: print('-->Attacker dump data already exists!') db.commit()
def create_database(): cursor.execute( "CREATE DATABASE IF NOT EXISTS {} DEFAULT CHARACTER SET 'utf8'".format( DB_NAME)) print("connection to DB {} successful!".format(DB_NAME))
def insertion(inp): if inp==8: main_menu() elif inp==1: print('======================= Insertion =======================',end="\n\n") print("Enter the new players details ->") new_player=[] new_player.append(int(input("Player ID > "))) new_player.append(input("Username > ")) new_player.append(int(input("Age > "))) new_player.append(int(input("Team ID > "))) new_player.append(int(input("Captain ID > "))) print("") sql="INSERT INTO player VALUES('%d','%s','%d','%d','%d')" %(new_player[0],new_player[1],new_player[2],new_player[3],new_player[4]) cursor.execute(sql) print('=======================***********=======================',end="\n\n") print("Select the type of player (1, 2 or 3) ->") print("1)--> Attacker") print("2)--> Defender") print("3)--> Both",end="\n\n") Type=int(input("Your Option > ")) if Type==1: sql="INSERT INTO player_type VALUES (%d, 'Attacker')" %(new_player[0]) cursor.execute(sql) sql="INSERT INTO attacker VALUES (%d,%d,%d,%d,%d,%d)" %(new_player[0],0,0,0,0,0) cursor.execute(sql) db.commit() print('Updated Players Table -->',end="\n\n") sql="SELECT * FROM player" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") print('Updated Attackers Table -->',end="\n\n") sql="SELECT * FROM attacker" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") elif Type==2: sql="INSERT INTO player_type VALUES (%d, 'Defender')" %(new_player[0]) cursor.execute(sql) sql="INSERT INTO defender VALUES (%d,%d,%d,%d,%d)" %(new_player[0],0,0,0,0) cursor.execute(sql) db.commit() print('Updated Players Table -->',end="\n\n") sql="SELECT * FROM player" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") print('Updated Defenders Table -->',end="\n\n") sql="SELECT * FROM defender" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") elif Type==3: sql="INSERT INTO player_type VALUES (%d, 'Defender')" %(new_player[0]) cursor.execute(sql) sql="INSERT INTO defender VALUES (%d,%d,%d,%d,%d)" %(new_player[0],0,0,0,0) cursor.execute(sql) sql="INSERT INTO player_type VALUES (%d, 'Attacker')" %(new_player[0]) cursor.execute(sql) sql="INSERT INTO attacker VALUES (%d,%d,%d,%d,%d,%d)" %(new_player[0],0,0,0,0,0) cursor.execute(sql) db.commit() print('Updated Players Table -->',end="\n\n") sql="SELECT * FROM player" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") print('Updated Attackers Table -->',end="\n\n") sql="SELECT * FROM attacker" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") print('Updated Defenders Table -->',end="\n\n") sql="SELECT * FROM defender" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") else: insertion(inp) elif inp==2: print('======================= Insertion =======================',end="\n\n") print("Enter the new Team's details ->") new_team=[] new_team.append(int(input("Team ID > "))) new_team.append(input("TeamName > ")) new_team.append(input("Coach > ")) new_team.append(int(input("Region_ID > "))) print("") sql="INSERT INTO team VALUES ('%d','%s','%s','%d')" %(new_team[0],new_team[1],new_team[2],new_team[3]) cursor.execute(sql) db.commit() print('Updated Teams Table -->',end="\n\n") sql="SELECT * FROM team" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") elif inp==3: print('======================= Insertion =======================',end="\n\n") Player_ID=int(input("Enter the Player ID of the Attacker who started Defending > ")) sql="INSERT INTO player_type VALUES('%d', 'Defender')" %(Player_ID) cursor.execute(sql) sql="INSERT INTO defender VALUES (%d,%d,%d,%d,%d)" %(Player_ID,0,0,0,0) cursor.execute(sql) db.commit() print('Updated Players Table -->',end="\n\n") sql="SELECT * FROM player" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") print('Updated Player Type Table -->',end="\n\n") sql="SELECT * FROM player_type" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") print('Updated Defenders Table -->',end="\n\n") sql="SELECT * FROM defender" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") elif inp==4: print('======================= Insertion =======================',end="\n\n") Player_ID=int(input("Enter the Player ID of the Defender who started Attacking > ")) sql="INSERT INTO player_type VALUES('%d', 'Attacker')" %(Player_ID) cursor.execute(sql) sql="INSERT INTO attacker VALUES (%d,%d,%d,%d,%d,%d)" %(Player_ID,0,0,0,0,0) cursor.execute(sql) db.commit() print('Updated Players Table -->',end="\n\n") sql="SELECT * FROM player" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") print('Updated Player Type Table -->',end="\n\n") sql="SELECT * FROM player_type" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") print('Updated Defenders Table -->',end="\n\n") sql="SELECT * FROM attacker" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") elif inp==5: print('======================= Insertion =======================',end="\n\n") print("Enter the new Venue's details ->") Venue_ID=int(input("Venue ID > ")) Venue_Name=input("Venue Name > ") sql="INSERT INTO venue VALUES('%d','%s')" %(Venue_ID, Venue_Name) cursor.execute(sql) db.commit() print('Updated Venues Table -->',end="\n\n") sql="SELECT * FROM venue" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") elif inp==6: print('======================= Insertion =======================',end="\n\n") print("Enter the details for the match for which the MVP is to be inserted ->") Tid1=int(input("TeamID 1 > ")) Tid2=int(input("TeamID 2 > ")) Day=int(input("Day > ")) Mvp=int(input("Most Valuable Player > ")) sql="UPDATE `match` SET MVP='%d' WHERE ((TID1='%d' AND TID2='%d' AND Day='%d') OR (TID2='%d' AND TID1='%d' AND Day='%d'))"%(Mvp,Tid1,Tid2,Day,Tid1,Tid2,Day) cursor.execute(sql) db.commit() print('Updated Matches Table -->',end="\n\n") sql="SELECT * FROM `match`" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") elif inp==7: print('======================= Insertion =======================',end="\n\n") print("Enter the details for the match for which Won By is to be inserted ->") Tid1=int(input("TeamID 1 > ")) Tid2=int(input("TeamID 2 > ")) Day=int(input("Day > ")) WonBy=int(input("Team ID of the winner > ")) sql="UPDATE `match` SET WonBy='%d' WHERE ((TID1='%d' AND TID2='%d' AND Day='%d') OR (TID2='%d' AND TID1='%d' AND Day='%d'))"%(WonBy,Tid1,Tid2,Day,Tid1,Tid2,Day) cursor.execute(sql) db.commit() print('Updated Matches Table -->',end="\n\n") sql="SELECT * FROM `match`" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") else: insertion_menu() inp = input("Enter any key to go back to the main menu> ") main_menu()
def updation(inp): if inp==5: main_menu() elif inp==1: print('======================= Updation =======================',end="\n\n") print("Attacker Table -> ",end="\n\n") sql = "SELECT * FROM attacker;" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") Player_ID=int(input("Enter the ID of the attacker who's data needs to be updated > ")) sql = "SELECT * FROM attacker WHERE (Player_ID = %d)" %(Player_ID) cursor.execute(sql) result=cursor.fetchall() points_gained=int(input("Enter the number of points gained by the attacker > ")) Trap_Triggered=int(input("Enter 0 if the attacker did not trigger any traps > ")) if Trap_Triggered: Battle_No_Deaths=0 else: Battle_No_Deaths=1 sql = "UPDATE attacker SET Battles_Played = %d WHERE Player_ID = %d" %(int(int(result[0][2])+1),Player_ID) cursor.execute(sql) db.commit() sql = "UPDATE attacker SET Points = '%d' WHERE Player_ID = '%d'" %(result[0][1]+points_gained , Player_ID) cursor.execute(sql) db.commit() sql = "UPDATE attacker SET Battles_No_Deaths = %d WHERE Player_ID = %d" %(result[0][3]+Battle_No_Deaths, Player_ID) cursor.execute(sql) db.commit() sql = "UPDATE attacker SET Avg_Attack = '%f' WHERE Player_ID = '%d'" %(float(float(result[0][1])/float(result[0][2]-result[0][3])) , Player_ID) cursor.execute(sql) db.commit() if result[0][5] < points_gained: sql = "UPDATE attacker SET Highscore = '%d' WHERE Player_ID = '%d'" %(points_gained, Player_ID) cursor.execute(sql) db.commit() print('Updated Table -->',end="\n\n") sql="SELECT * FROM attacker" cursor.execute(sql) result=cursor.fetchall() print(result) elif inp==2: print('======================= Updation =======================',end="\n\n") print("Defender Table -> ",end="\n\n") sql = "SELECT * FROM defender;" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") Player_ID=int(input("Enter the ID of the defender who's data needs to be updated > ")) sql = "SELECT * FROM defender WHERE (Player_ID = %d)" %(Player_ID) cursor.execute(sql) result=cursor.fetchall() points_given=int(input("Enter the number of points given by the defender > ")) Trap_Laid=int(input("Number of successful traps laid by the defender > ")) sql = "UPDATE defender SET Battles_played = '%d' WHERE Player_ID = '%d'" %(result[0][1]+1, Player_ID) cursor.execute(sql) db.commit() sql = "UPDATE defender SET Points_Given = '%d' WHERE Player_ID = '%d'" %(result[0][2]+points_given , Player_ID) cursor.execute(sql) db.commit() sql = "UPDATE defender SET Traps_Triggered = '%d' WHERE Player_ID = '%d'" %(result[0][3]+Trap_Laid , Player_ID) cursor.execute(sql) db.commit() sql = "UPDATE defender SET Avg_Defence = '%f' WHERE Player_ID = '%d'" %(float(float(result[0][2])/float(result[0][1])) , Player_ID) cursor.execute(sql) db.commit() print('Updated Table -->',end="\n\n") sql="SELECT * FROM defender" cursor.execute(sql) result=cursor.fetchall() print(result) elif inp==3: print('======================= Updation =======================',end="\n\n") print("Venue Table -> ",end="\n\n") sql = "SELECT * FROM venue;" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") print("Matches Table -> ",end="\n\n") sql = "SELECT * FROM `match`;" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") Tid1 = int(input("Enter the first team's ID > ")) Tid2 = int(input("Enter the second teams ID > ")) Day = int(input("Enter the day of the Match > ")) Venue_ID = int(input("Enter the Venue ID where match is to be held instead > ")) sql = "UPDATE `match` SET Venue_ID = '%d' WHERE Day = '%d' AND TID1 = '%d' AND TID2 = '%d'" %(Venue_ID, Day, Tid1, Tid2) cursor.execute(sql) db.commit() print("Updated Matches Table -> ",end="\n\n") sql = "SELECT * FROM `match`;" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") elif inp==4: print('======================= Updation =======================',end="\n\n") print("Players Table -> ",end="\n\n") sql = "SELECT * FROM player;" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") Player_ID=int(input("Enter the ID of the player who has been deceased > ")) sql = "UPDATE player SET Age = '%d' WHERE Player_ID = '%d'" %(-1, Player_ID) cursor.execute(sql) db.commit() print("Updated players Table -> ",end="\n\n") sql = "SELECT * FROM player;" cursor.execute(sql) result=cursor.fetchall() print(result,end="\n\n") else: updation_menu() inp = input("Enter any key to go back to the main menu> ") main_menu()