bwnkvqM6

1import sqlite3
2class Database:
3    def databaseMaker():
4        with sqlite3.connect("Review.db") as db:
5            cursor = db.cursor()
6
7            cursor.execute("""
8            CREATE TABLE IF NOT EXISTS games(
9            gameID INTEGER PRIMARY KEY AUTOINCREMENT,
10            gameName TEXT);
11            """)
12            
13
14            cursor.execute("""
15            CREATE TABLE IF NOT EXISTS website(
16            websiteID INTEGER PRIMARY KEY AUTOINCREMENT,
17            websiteName TEXT,
18            reviewCheck BOOLEAN,
19            scoreCheck BOOLEAN,
20            summaryCheck BOOLEAN
21            );
22            """)#change web crawlers to give one summary
23            
24
25            cursor.execute("""
26            CREATE TABLE IF NOT EXISTS review(
27            reviewID INTEGER PRIMARY KEY AUTOINCREMENT,
28            gameID INTEGER,
29            websiteID INTEGER,
30            review TEXT,
31            score TEXT,
32            summary TEXT,
33            FOREIGN KEY (gameID) REFERENCES games(gameID),
34            FOREIGN KEY (websiteID) REFERENCES website(websiteID));
35            """)