def add_tasks(session):
session.add(
Task(
task_id=keys.task_id_1,
name="Sample Task 1",
project_id=keys.project_id_1,
_taskType=session.query(TaskType).filter_by(
name="Audio Checking").one(),
))
def initDb(self, name, encoding):
"""Initializing SQLite database"""
self.dbName = name
self.db = SQLite(self.dbName, encoding)
self.priority = Priority(self.db)
self.task = Task(self.db)
# for testing purposes
if self.task.count() == 0:
self.db.execSql(
"insert into {} (name, priority, deadline) values(?, ?, ?)".
format(self.task._tableName),
("Low Test", 1, date.today() + timedelta(2)))
self.db.commit()
