def receiveAddEditTaskForm():
session = Database.Session()
T = Database.Task
t = T()
Form = createFormContructor(t, [])
f = Form()
if f.validates():
if f.d.task_id == "new":
t = T()
else:
q = session.query(T).filter(T.task_id == int(f.d.task_id))
t = q.one()
t.task_name = f.d.task_name
t.task_status = f.d.task_status
t.project_id = int(f.d.task_project)
if t.task_id == None:
session.add(t)
session.commit()
if f.d.task_time_estimate != "":
t_est = Database.TaskTimeEst()
t_est.task_id = t.task_id
t_est.task_time_estimate = f.d.task_time_estimate
session.add(t_est)
session.commit()
return f.d.task_project
def receiveAddEditProjectForm():
session = Database.Session()
P = Database.Project
p = P()
Form = createFormContructor(p, [])
f = Form()
if f.validates():
if f.d.project_id == "new":
p = P()
else:
q = session.query(P).filter(P.project_id == int(f.d.project_id))
p = q.one()
p.project_name = f.d.project_name
p.project_status = f.d.project_status
p.category_id = int(f.d.project_category)
if p.project_id == None:
session.add(p)
session.commit()
if f.d.project_time_estimate != "":
p_est = Database.ProjectTimeEst()
p_est.project_id = p.project_id
p_est.project_time_estimate = f.d.project_time_estimate
session.add(p_est)
session.commit()
return p.project_id
def receiveAddEditCategoryForm():
session = Database.Session()
C = Database.Category
c = C()
Form = createFormContructor(c, [])
f = Form()
if f.validates():
if f.d.category_id == "new":
c = C()
else:
q = session.query(C).filter(C.category_id == int(f.d.category_id))
c = q.one()
c.category_name = f.d.category_name
c.category_status = f.d.category_status
if c.category_id == None:
session.add(c)
session.commit()
print f.d.category_id
return f.d.category_id
