3cb-data

commit 82a3d10811064cda5a9c6142edc9d96a22e549af
parent 28e27087d95c4c0e55e67cf1a71699866946faf8
Author: alex wennerberg <alex@alexwennerberg.com>
Date:   Tue,  5 Dec 2023 22:13:43 -0500

Updatesss

Diffstat:
M
getdata.py
 | 
3
+++
A
runround.sh
 | 
4
++++
M
sql/new.sql
 | 
6
+++---

3 files changed, 10 insertions(+), 3 deletions(-)
diff --git a/getdata.py b/getdata.py
@@ -161,6 +161,9 @@ def replacement(card):
             "Monty Python and the Holy Grail Black Knight (Oathsworn Knight)": "Oathsworn Knight",
             "Red Sun's Zenith (Again)": "Red Sun's Zenith",
             "Dwarven Hold (Again)": "Dwarven Hold",
+            "Speaker of the Heavens!?!?!?!": "Speaker of the Heavens",
+            "Dark Ritual (STA #89)": "Dark Ritual",
+            "Swamp (8ED #339)": "Swamp",
         }
     if card in m:
         return m[card]
diff --git a/runround.sh b/runround.sh
@@ -0,0 +1,4 @@
+python getdata.py
+sqlite3 3cb.db < sql/new.sql 
+sqlite3 3cb.db < sql/export.sql  > export.csv
+
diff --git a/sql/new.sql b/sql/new.sql
@@ -1,14 +1,14 @@
 /* awkward and repetitive bc my sql is bad */
 
-select "New cards this round:";
+select 'New cards this round:';
 with new as (
 select min(card.round) as rnd, group_name = 'final' as isfinal, name
 from match join card on match.round = card.round and match.player = card.player
 group by 2,3 order by 1,2)
 
 select name from new where rnd = (select max(rnd) from new) and not isfinal;
-select "";
-select "Cards that made finals for the first time:";
+select '';
+select 'Cards that made finals for the first time:';
 with new as (
 select min(card.round) as rnd, group_name = 'final' as isfinal, name
 from match join card on match.round = card.round and match.player = card.player