def updateTaskStatus(self, id, status): db_session.query(TaskEntity).filter(TaskEntity.id == id).update({'status_id': status}) db_session.commit()
def insertOrUpdateTask(self, task): db_session.add(task) db_session.commit() return task.id
def deleteTask(self, id): db_session.query(TaskEntity).filter(TaskEntity.id == id).delete() db_session.commit() return id
def getHistory(self): db_session.flush() db_session.commit() return db_session.query(HistoryEntity).all()
def updateHistory(self, hEvent): db_session.add(hEvent) db_session.commit()
def getProjectHistory(self, pid): db_session.flush() db_session.commit() return db_session.query(HistoryEntity).filter(HistoryEntity.pid == pid).all()
def getUserHistory(self, uid): db_session.flush() db_session.commit() return db_session.query(HistoryEntity).filter(HistoryEntity.uid == uid).all()
def insertOrUpdateProject(self, project): db_session.add(project) db_session.commit() return project.pid