-
Notifications
You must be signed in to change notification settings - Fork 1
/
server_sql_connection.py
29 lines (25 loc) · 1.11 KB
/
server_sql_connection.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
#!/usr/bin/env python3.7
# Isaac Diaby 090492276
# this is just making a connection to the database and setting it up
import sqlite3 # used to talk to the SQL database
class SqlServerConnection():
def __init__(self, databaseCredential="application.db"):
# connect with the database
# check_same_thread needs to be false because it will be running on different threads.
self.connection = sqlite3.connect(databaseCredential, check_same_thread=False)
# self.connection = sqlite3.connect(":memory:") # testing
# init db
self.setup_db()
def setup_db(self):
# this will create the users and leader board table in the sql database if they dont already exists
c = self.connection.cursor()
c.execute("""
CREATE TABLE IF NOT EXISTS users (
username VARCHAR(25) NOT NULL UNIQUE,
password VARCHAR(25) NOT NULL,
wins INT UNSIGNED DEFAULT 0,
loses INT UNSIGNED DEFAULT 0,
games_played int UNSIGNED DEFAULT 0
);
""")
self.connection.commit()