diff options
| author | emkael <emkael@tlen.pl> | 2017-08-01 14:06:25 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2017-08-01 14:06:25 +0200 |
| commit | ca6c87f457f49cf33f357984d7642b1c83a0eefb (patch) | |
| tree | 52cb557a89f7819a844ee394b1c0ccadbb52c607 /jfr_playoff/sql.py | |
| parent | de7260322d60eeb5fd0afa57ec2e250ce7f52261 (diff) | |
Code formatting
Diffstat (limited to 'jfr_playoff/sql.py')
| -rw-r--r-- | jfr_playoff/sql.py | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/jfr_playoff/sql.py b/jfr_playoff/sql.py index 76ea728..b01bd08 100644 --- a/jfr_playoff/sql.py +++ b/jfr_playoff/sql.py @@ -1,5 +1,6 @@ MATCH_RESULTS = ''' -SELECT t1.fullname, t2.fullname, matches.carry, matches.vph, matches.vpv, matches.corrh, matches.corrv +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 @@ -9,7 +10,8 @@ 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) +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 |