X-Git-Url: https://git.yukkurigames.com/?p=mlpccg-meta.git;a=blobdiff_plain;f=mlpccg%2FTournament.py;fp=mlpccg%2FTournament.py;h=94723eb57690d8293b0d66b1caf271f6e67e6726;hp=0000000000000000000000000000000000000000;hb=0f08a0d1ebcd8d825a7df448221a7eb23600bba5;hpb=5d20db255bfeff5d47c0a7fd9aef9839f57f6d77

diff --git a/mlpccg/Tournament.py b/mlpccg/Tournament.py
new file mode 100644
index 0000000..94723eb
--- /dev/null
+++ b/mlpccg/Tournament.py
@@ -0,0 +1,29 @@
+import csv
+import sqlite3
+
+class Tournament:
+    def __init__(self):
+        #self.from_sqlite('data/db.sqlite3')
+        self.from_csv('data/tournaments.csv')
+
+    def from_sqlite(self, sqlite_path):
+        conn = sqlite3.connect(sqlite_path)
+        conn.row_factory = sqlite3.Row
+
+        c = conn.cursor()
+        for row in c.execute("SELECT strftime('%s', date) - 0 AS t, * FROM tournaments_record"):
+            self.records += [dict(zip(row.keys(), row))]
+        conn.close()
+
+    def from_csv(self, csv_path):
+        with open(csv_path) as f:
+            reader = csv.DictReader(f)
+            for row in reader:
+                pass #row['date']
+            self.records = [row for row in reader]
+
+    def add(self, record):
+        self.records += [record]
+
+    def all(self):
+        return self.records