3cb-data

commit 93c2627ab0e5a5dfa3dd0070734ffb906027f8e0
parent 50aeb140d9ecbe11114c7bf24e675ffe9a510467
Author: alex wennerberg <alex@alexwennerberg.com>
Date:   Sun,  4 Feb 2024 00:18:44 -0500

update export and group

Diffstat:
M
runround.sh
 | 
3
+--
M
sql/export.sql
 | 
4
++++

2 files changed, 5 insertions(+), 2 deletions(-)
diff --git a/runround.sh b/runround.sh
@@ -1,4 +1,3 @@
 python getdata.py
 sqlite3 3cb.db < sql/new.sql 
-sqlite3 3cb.db < sql/export.sql  > export.csv
-
+sqlite3 3cb.db < sql/export.sql  > export.tsv
diff --git a/sql/export.sql b/sql/export.sql
@@ -1,5 +1,8 @@
 /* best-per-round */
 .headers on
+.mode list
+.separator "\t"
+
 with card as (
 select round,player,card1 as card from deck
 union select round,player,card2 as card from deck
@@ -23,6 +26,7 @@ select deck.round,deck.player,
 card1,
 card2,
 card3,
+min(match.group_name) as prelim_group,
 sum(case when match.group_name != 'final' then match.score else 0 end) as prelim_score,
 sum(case when match.group_name = 'final' then match.score else null end) as final_score
 from deck join match