import sqlite3 import os.path import time def init(path): is_db_new = not os.path.isfile(path) database = sqlite3.connect('database') if is_db_new: database.cursor().execute( " CREATE TABLE IF NOT EXISTS tasks(" " id INTEGER PRIMARY KEY," " created_at INTEGER NOT NULL," " modified_at INTEGER NOT NULL," " name TEXT NOT NULL," " description TEXT," " duration INTEGER," " tag TEXT" " )") database.commit() return database