def runAccess():
try:
conn = sql(DB_LOCATION)
cursor = conn.cursor()
cursor.execute("PRAGMA foreign_keys=ON;")
fn(cursor)
except Exception as ex:
ex = ex.args[0].replace("constraint ", "").replace(" failed", "")
if ex in DB_EXCEPTIONS:
ui.errorMsg(DB_EXCEPTIONS[ex])
else:
ui.errorMsg("An unexpected error occurred.")
finally:
cursor.close()
conn.commit()
conn.close()
def runAccess():
try:
conn = sql(DB_LOCATION)
cursor = conn.cursor()
cursor.execute("PRAGMA foreign_keys=ON;")
fn(cursor)
except Exception as ex:
ex = ex.args[0].replace("constraint ", "").replace(" failed", "")
if ex in DB_EXCEPTIONS:
ui.errorMsg(DB_EXCEPTIONS[ex])
else:
ui.errorMsg("An unexpected error occurred.")
finally:
cursor.close()
conn.commit()
conn.close()
from sqlite3 import connect as sql
conn = sql("narrowboats.db")
cursor = conn.cursor()
# Drops all the tables before recreating them.
cursor.execute("""DROP TABLE IF EXISTS customers""")
cursor.execute("""DROP TABLE IF EXISTS jobs""")
cursor.execute("""DROP TABLE IF EXISTS boats""")
cursor.execute("""DROP TABLE IF EXISTS employees""")
cursor.execute("""DROP TABLE IF EXISTS skills""")
cursor.execute("""PRAGMA foreign_keys=ON;""")
# Create tables.
cursor.execute("""CREATE TABLE customers (
customerId INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
address TEXT,
postCode VARCHAR2(10),
phoneNumber VARCHAR2(11)
)""")
cursor.execute("""CREATE TABLE employees (
employeeId INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT
)""")
cursor.execute("""CREATE TABLE boats (
boatId INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
ownerId INTEGER,
