def openDatabase(self, tourneyName, openwindow):
#Make sure that the tournament name entered exists
try:
self.cursor.execute("select name from "+tourneyName)
teams = self.cursor.fetchall()
teamList = []
#Turn the tuple into a list
for i in range(len(teams)):
teamList.append(teams[i][0])
#Get the list of teams, as well as their information from the database and pass it on to the bracket window
self.cursor.execute("select name, startPos, currentRound, currentPos from "+tourneyName)
openteams = self.cursor.fetchall()
self.connection.close()
openwindow.destroy()
bracketWindow.window(tourneyName, len(teams), teamList, True, openteams)
except:
#Give an error message if the tournament doesn't exist
error = messagebox.showerror("Error", "Please enter the name of a tournament that exists.")
def createTournament(self, tourneyName, numTeams, teamList):
teamData=[]
#Create a list of tuples that contain the data for each team
for i in range(numTeams):
teamData.append((i, teamList[i], i, 0, i))
#Create and update the table using the list of teams
self.cursor.execute('''create table '''+tourneyName+'''(
teamNum integer,
name text,
startPos integer,
currentRound integer,
currentPos integer)''')
for i in range(len(teamData)):
self.cursor.execute('''insert into '''+tourneyName+'''(
teamNum, name, startPos, currentRound, currentPos)
values(?,?,?,?,?)''', teamData[i]
)
self.connection.commit()
#Create the bracket window with the list of teams
bracketWindow.window(tourneyName, numTeams, teamList, False, (0,))
