1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
import jfr_playoff.sql as p_sql
from jfr_playoff.logger import PlayoffLogger
from jfr_playoff.data.tournament import TournamentInfoClient
SWISS_TIE_WARNING = 'tie detected in swiss %s.' + \
' Make sure to resolve the tie by arranging teams' + \
' in configuration file.'
class JFRDbTournamentInfo(TournamentInfoClient):
@property
def priority(self):
return 50
def is_capable(self):
return (self.database is not None) and ('database' in self.settings)
def get_exceptions(self, method):
return (IOError, TypeError, IndexError, KeyError)
def get_results_link(self, suffix='leaderb.html'):
row = self.database.fetch(
self.settings['database'], p_sql.PREFIX, ())
if row is not None:
if len(row) > 0:
link = row[0] + suffix
PlayoffLogger.get('tournament.jfrdb').info(
'generating tournament-specific link from DB %s prefix: %s -> %s',
self.settings['database'], suffix, link)
return link
raise ValueError('unable to fetch db link')
def is_finished(self):
finished = self.database.fetch(
self.settings['database'], p_sql.SWISS_ENDED, {})
PlayoffLogger.get('tournament.jfrdb').info(
'fetching tournament finished status from DB %s: %s',
self.settings['database'], finished)
return (len(finished) > 0) and (finished[0] > 0)
def get_tournament_results(self):
if 'ties' not in self.settings:
self.settings['ties'] = []
swiss_teams = self.database.fetch_all(
self.settings['database'], p_sql.SWISS_RESULTS, {})
swiss_results = sorted(
swiss_teams,
key=lambda t: self.settings['ties'].index(t[0]) \
if t[0] in self.settings['ties'] else -1)
swiss_results = sorted(
swiss_results, key=lambda t: t[1], reverse=True)
swiss_results = sorted(swiss_results, key=lambda team: team[2])
PlayoffLogger.get('tournament.jfrdb').info(
'fetched tournament results from database %s: %s',
self.settings['database'], swiss_results)
prev_result = None
for team in swiss_results:
if prev_result == team[1]:
PlayoffLogger.get('tournament.jfrdb').warning(
SWISS_TIE_WARNING, self.settings['database'])
prev_result = team[1]
db_teams = [[team[0], team[3], team[4]] for team in swiss_results]
PlayoffLogger.get('tournament.jfrdb').info(
'fetched team list from database %s: %s',
self.settings['database'], db_teams)
return db_teams
|