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