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