diff options
Diffstat (limited to 'src/db/init.py')
-rw-r--r-- | src/db/init.py | 51 |
1 files changed, 0 insertions, 51 deletions
diff --git a/src/db/init.py b/src/db/init.py deleted file mode 100644 index 5d847a3..0000000 --- a/src/db/init.py +++ /dev/null @@ -1,51 +0,0 @@ -import sqlite3 -import os.path -import time - -def init(path): - - is_db_new = not os.path.isfile(path) - - database = sqlite3.connect(path) - - cursor = database.cursor() - - if is_db_new: - - cursor.execute( - " CREATE TABLE IF NOT EXISTS tasks(" - " id INTEGER PRIMARY KEY," - " created_at INTEGER NOT NULL," - " updated_at INTEGER NOT NULL," - " name TEXT NOT NULL," - " duration INTEGER," - " difficulty INT," - " priority INT," - " description TEXT," - " status TEXT" - " )") - - cursor.execute( - " CREATE TABLE IF NOT EXISTS tags(" - " id INTEGER PRIMARY KEY," - " created_at INTEGER NOT NULL," - " updated_at INTEGER NOT NULL," - " name TEXT NOT NULL," - " color TEXT NOT NULL" - " )") - - cursor.execute( - " CREATE TABLE IF NOT EXISTS task_tags(" - " task_id INTEGER NOT NULL," - " tag_id INTEGER NOT NULL," - " created_at INTEGER NOT NULL," - " FOREIGN KEY (task_id) REFERENCES tasks(id)," - " FOREIGN KEY (tag_id) REFERENCES tags(id)," - " PRIMARY KEY (task_id, tag_id)" - " )") - - cursor.execute("PRAGMA foreign_keys = ON") - - database.commit() - - return database |