%s

From f118c0f3704fa07a33543ee2aa018f16ac993b5a Mon Sep 17 00:00:00 2001 From: emkael Date: Wed, 22 Feb 2017 14:25:36 +0100 Subject: Initial commit --- playoff/__init__.py | 0 playoff/sql.py | 23 +++++++++++ playoff/template.py | 116 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 3 files changed, 139 insertions(+) create mode 100644 playoff/__init__.py create mode 100644 playoff/sql.py create mode 100644 playoff/template.py (limited to 'playoff') diff --git a/playoff/__init__.py b/playoff/__init__.py new file mode 100644 index 0000000..e69de29 diff --git a/playoff/sql.py b/playoff/sql.py new file mode 100644 index 0000000..0bd2df7 --- /dev/null +++ b/playoff/sql.py @@ -0,0 +1,23 @@ +MATCH_RESULTS = ''' +SELECT t1.fullname, t2.fullname, matches.carry, matches.vph, matches.vpv, matches.corrh, matches.corrv +FROM #db#.matches matches +JOIN #db#.teams t1 + ON t1.id = #db#.matches.homet +JOIN #db#.teams t2 + ON t2.id = #db#.matches.visit +WHERE matches.tabl = %s AND matches.rnd = %s +''' + +BOARD_COUNT = ''' +SELECT segmentsperround*boardspersegment, SUM(sc1.contract IS NOT NULL AND sc2.contract IS NOT NULL) +FROM #db#.scores sc1 +JOIN #db#.scores sc2 + ON sc1.rnd = sc2.rnd + AND sc1.segment = sc2.segment + AND sc1.tabl = sc2.tabl + AND sc1.board = sc2.board + AND sc1.room = 1 + AND sc2.room = 2 +JOIN #db#.admin +WHERE sc1.tabl = %s AND sc1.rnd = %s +''' diff --git a/playoff/template.py b/playoff/template.py new file mode 100644 index 0000000..5fe855c --- /dev/null +++ b/playoff/template.py @@ -0,0 +1,116 @@ +#encoding=utf-8 + +MATCH_TABLE = ''' + + + + + +%s +

wynik

+''' + +MATCH_TEAM_ROW = ''' + + %s + %.1f + +''' + +MATCH_RUNNING = ''' + +

+%d +

+ +''' + +MATCH_GRID = ''' +

+%s + +

+''' + +MATCH_GRID_PHASE = ''' +%s +''' + +MATCH_GRID_RUNNING_PHASE = ''' + +

+%s +

+ +''' + +MATCH_BOX = ''' +

+%s +

+''' + +LEADERBOARD = ''' + + + + + + + + + + + +%s +

KLASYFIKACJA KOŃCOWA

miejsce	drużyna

+''' + +LEADERBOARD_ROW = ''' + +%d + %s + +''' + +PAGE_HEAD = ''' + + + + + + +%s +%s + + +''' + +PAGE_HEAD_REFRESH = ''' + +''' + +PAGE_BODY = ''' + +%s +%s +%s +%s +''' + +PAGE_BODY_FOOTER = ''' +

+''' + +PAGE = ''' + + + +%s + + +%s + + +''' -- cgit v1.2.3