3cb-data

Unnamed repository; edit this file 'description' to name the repository.
git clone git://git.alexwennerberg.com/3cb-data.git
Log | Files | Refs | README | LICENSE
commit d456f40056d8c6464fab8352fa0e8e244595b933
parent cbd60818b49ac5930160f4ed0c81271c268f24f4
Author: alex wennerberg <alex@alexwennerberg.com>
Date:   Tue, 12 Mar 2024 00:04:12 -0400

small bug fixes

Diffstat:

Mgetdata.py | 6+++++-


Msql/delete-last.sql | 6+++---


Mtemplates/index.html | 2+-


3 files changed, 9 insertions(+), 5 deletions(-)

diff --git a/getdata.py b/getdata.py
@@ -115,6 +115,8 @@ def save_sheet(cur, sheet, n, final):
             if not final: #already done
                 cur.execute("insert into deck values (?,?,?,?,?);", (n, player, clean_card(cards[0]), clean_card(cards[1]), clean_card(cards[2])))
             for o, s in enumerate(row[start:end]):
+                if s == "?":
+                    s = 0
                 cur.execute("insert into match values (?, ?, ?, ?, ?);", 
                             (n, group, player,players[o],int(s)));
 
@@ -147,12 +149,14 @@ def best_guess(card):
     return card
 
 
+# data cleaning
 def replacement(card):
     m = {
             "Thallid Oh Yeah": "Thallid",
             "Forest!!!!!!": "Forest",
+            "Bayou - Not Legal": "Bayou",
             "Bottomless Depths": "Bottomless Vault",
-            "Gargadon (Neither Greater Nor lesser": "Gargadon",
+            "Gargadon (Neither Greater Nor Lesser)": "Gargadon",
             "Tabernacle at Penrall Vale": "The Tabernacle at Pendrell Value",
             "Nesumi Shortfang": "Nezumi Shortfang // Stabwhisker the Odious",
             "Filigree Sylex": "The Filigree Sylex",
diff --git a/sql/delete-last.sql b/sql/delete-last.sql
@@ -1,3 +1,3 @@
-delete from round where id > 53;
-delete from deck where round > 53;
-delete from match where round  > 53;
+delete from round where id > 40;
+delete from deck where round > 40;
+delete from match where round  > 40;
diff --git a/templates/index.html b/templates/index.html
@@ -1,5 +1,5 @@
-<html charset='UTF-8'>
 <head>
+	<meta charset="utf-8">
 <style>
 table { font-family: Arial, Helvetica, sans-serif; border-collapse: collapse; width: 100%; }
 td, th { border: 1px solid #ddd; padding: 8px; }