diff options
author | Jackson Taylor <jtaylor@classicalconversations.com> | 2021-11-01 14:05:36 -0400 |
---|---|---|
committer | Jackson Taylor <jtaylor@classicalconversations.com> | 2021-11-01 14:05:36 -0400 |
commit | 98fbae3fd64d66e9c07e531aa9b49af04ceb57c3 (patch) | |
tree | 7470c851ceecdecbbcac71c9e143a25f1a550364 | |
parent | d80ea2862f4e0a95b5c1e115770a1a9b51a7caed (diff) |
Pull times from db
Right now it just stores an ID and a time
-rwxr-xr-x | jacsr | 12 |
1 files changed, 12 insertions, 0 deletions
@@ -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() |