def db_delete_task(taskid):
# connect to todo.db
db = DaBa("todo")
# construct query to retrieve rows from todo table
query = "DELETE FROM todo WHERE id = {id}"
query = query.format(id=taskid)
# execute query
print("Query: " + query)
db.que(query)
result = db.new_id()
# close db to release lock on database
db.close()
return result
def db_create_task(new_task):
''' stores new record in db
returns new record id
'''
# connect to todo.db
db = DaBa("todo")
# construct query to retrieve rows from todo table
query = "INSERT INTO todo (task, status) Values('{td}', {status})"
query = query.format(td=new_task[0], status=(new_task[1]))
# execute query
print("Query: " + query)
db.que(query)
result = db.new_id()
# close db to release lock on database
db.close()
return result
def db_delete_task(a_new_task):
""" stores new record in db
returns new record id
"""
# connect to todo.db
db = DaBa("todo")
# construct query to retrieve rows from todo table
query = "DELETE FROM todo WHERE id='{task_id}'".format(
task_id=a_new_task[0])
# execute query
db.que(query)
result = db.new_id()
# close db to release lock on database
db.close()
return result
def db_create_task(a_new_task):
""" stores new record in db
returns new record id
"""
# connect to todo.db
db = DaBa("todo")
# construct query to retrieve rows from todo table
query = "INSERT INTO todo (task, status) VALUES('{td}', '{status}')"
query = query.format(td=a_new_task[0], status=(a_new_task[1]))
# execute query
db.que(query)
result = db.new_id()
# close db to release lock on database
db.close()
return result
