quotes/dbsetup.py

12 lines
262 B
Python

import sqlite3, app
db = sqlite3.connect(app.DATABASE)
cur = db.cursor()
cur.execute("CREATE TABLE QUOTES (ID INT PRIMARY_KEY, CONTENT TEXT, SCORE INT)")
cur.execute("INSERT INTO QUOTES VALUES (?,?,?)", (1, "welp, this is empty.", 0))
db.commit()
db.close()