def get_employee(employee_id):
q = "SELECT lastName, firstName FROM SE_DB.employees WHERE ID = " + str(
employee_id) + ";"
c = db_util.db_open()
employee = db_util.db_query(c, q)
db_util.db_close(c)
return employee
def get_incomplete_tasks():
q = "SELECT * FROM SE_DB.tasks WHERE state = \"Incomplete\";"
c = db_util.db_open()
tasks = db_util.db_query(c, q)
db_util.db_close(c)
return tasks
def get_inprogress_tasks():
q = "SELECT * FROM SE_DB.tasks WHERE state = \"In Progress\";"
c = db_util.db_open()
tasks = db_util.db_query(c, q)
db_util.db_close(c)
return tasks
def get_task(taskID):
q = "SELECT * FROM SE_DB.tasks WHERE taskID = " + taskID + ";"
c = db_util.db_open()
task = db_util.db_query(c, q)
db_util.db_close(c)
return task
def get_all_tasks():
q = "SELECT * FROM SE_DB.tasks ORDER BY taskID desc;"
c = db_util.db_open()
tasks = db_util.db_query(c, q)
db_util.db_close(c)
return tasks