summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJackson Taylor <jtaylor@classicalconversations.com>2021-11-01 14:05:36 -0400
committerJackson Taylor <jtaylor@classicalconversations.com>2021-11-01 14:05:36 -0400
commit98fbae3fd64d66e9c07e531aa9b49af04ceb57c3 (patch)
tree7470c851ceecdecbbcac71c9e143a25f1a550364
parentd80ea2862f4e0a95b5c1e115770a1a9b51a7caed (diff)
Pull times from db
Right now it just stores an ID and a time
-rwxr-xr-xjacsr12
1 files changed, 12 insertions, 0 deletions
diff --git a/jacsr b/jacsr
index 82ed1ac..151d77d 100755
--- a/jacsr
+++ b/jacsr
@@ -28,6 +28,16 @@ def insert_times_into_db(connection, result_file):
cursor.close()
+
+def read_times_from_database(connection):
+ cursor = connection.cursor()
+
+ rows = cursor.execute('SELECT * from solves').fetchall()
+ print(rows)
+
+ cursor.close()
+
+
if __name__ == "__main__":
connection = sqlite3.connect(DATABASE_FILE)
@@ -35,5 +45,7 @@ if __name__ == "__main__":
insert_times_into_db(connection, RESULT_FILE)
+ read_times_from_database(connection)
+
connection.commit()
connection.close()