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()
