SbVsNr2P

1import sqlite3
2from sqlite3 import Error
3
4quiz_results = 'quiz_results.sqlite'  # defines quiz_results as the name 
5of the db
6
7try:
8    conn = sqlite3.connect(quiz_results)
9except Error as e:
10    print(e)
11
12c = conn.cursor()
13c.execute('PRAGMA foreign_keys = ON')
14
15
16
17c.execute(''' CREATE TABLE IF NOT EXISTS Tests(
18        id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
19        Name TEXT,
20        Surname TEXT,
21        Class TEXT)
22        ''')
23
24c.execute(''' CREATE TABLE IF NOT EXISTS Questions  (
25        Test INTEGER,
26        FOREIGN KEY(Test) REFERENCES Tests(id),
27        Operand1 INTEGER,
28        Operator TEXT,
29        Operand2 INTEGER,
30        ExpectedAnswer INTEGER,
31        Answer INTEGER,
32        Correct INTEGER)
33        ''')
34
35c.execute(''' CREATE TABLE IF NOT EXISTS Results    (
36        Test INTEGER,
37        FOREIGN KEY(Test) REFERENCES Tests(id),
38        nAnswers INTEGER,
39        nCorrect INTEGER)
40        ''')