def makePlayersSheet(book, tournamentID, tournamentName, sheet=None): if sheet is None: sheet = book.create_sheet() sheet.title = 'Players' players = tournament.getPlayers(tournamentID) header_row = 3 first_column = 1 row = header_row columns = Player_Columns merge_cells(sheet, header_row - 2, first_column, 1, len(columns), font=title_font, border=thin_outline, value='{} Players'.format(tournamentName)) sheet.row_dimensions[header_row - 2].height = title_font.size * 3 // 2 for i, column in enumerate(columns): cell = sheet.cell(row, first_column + i, value=column) cell.font = column_header_font cell.alignment = top_center_align for player in players: row += 1 for i, f in enumerate(columns): cell = sheet.cell(row=row, column=first_column + i, value=tournamentName if f == 'Tournament' else player[f.lower()]) for col in range(first_column, first_column + len(columns)): resizeColumn(sheet, col, min_row=header_row) return sheet
def load_players_from_db(self): """ This will load the players from the database and setup the first pairing. After this it will get them from the database :return: """ del self.swisspairing[:] players = tournament.getPlayers(self.database, self.cursor) count = 0 pairing = 0 odd_player = None if self.numplayers % 2 != 0: odd_index = randint(0, len(players)-1) odd_player = players[odd_index] del players[odd_index] for player in players: if len(player) == 2: count += 1 self.players[player[0]] = player[1] if count % 2 != 0: pairinglist = [] pairinglist.append(player[0]) pairinglist.append(player[1]) self.swisspairing.append(pairinglist) else: pairinglist = self.swisspairing[pairing] pairinglist.append(player[0]) pairinglist.append(player[1]) pairing += 1 if odd_player: pairinglist = [] pairinglist.append(odd_player[0]) pairinglist.append(odd_player[1]) pairinglist.append(-1) pairinglist.append("Loser") self.swisspairing.append(pairinglist)
def display_players(): ''' display_players(): Display players for the currently selected Tournament. Argument: None Return: None ''' header = tour.TournamentHeader() tid = header.tid if tid < 100: # TODO fix the raise statement raise "TID_Error - tid must be set to 100 or greater" players = tour.getPlayers(tid) print '''{:^45}'''.format('PLAYERS') print '''{:^5} {:^5} {:^35}'''.format('TID','PID','NAME') print '-'*45 for (tid,pid,name) in players: print '''{0:^5d} {1:^5d} {2:<35}'''.format(tid, pid, name) queryEnter() return
def display_players(): ''' display_players(): Display players for the currently selected Tournament. Argument: None Return: None ''' header = tour.TournamentHeader() tid = header.tid if tid < 100: # TODO fix the raise statement raise "TID_Error - tid must be set to 100 or greater" players = tour.getPlayers(tid) print '''{:^45}'''.format('PLAYERS') print '''{:^5} {:^5} {:^35}'''.format('TID', 'PID', 'NAME') print '-' * 45 for (tid, pid, name) in players: print '''{0:^5d} {1:^5d} {2:<35}'''.format(tid, pid, name) queryEnter() return