def getUsersForProject(self, pid): usersInvolved = db_session.query(UserProjectEntity).filter(UserProjectEntity.pid == pid).all() return usersInvolved
def getUserById(self, id): user = db_session.query(UserEntity).filter(UserEntity.uid == id).first() return user
def getTasksForProject(self, pid): return db_session.query(TaskEntity).filter(TaskEntity.project_id == pid).all()
def getProjectsForUser(self, uid): projects = db_session.query(UserProjectEntity).filter(uid=uid).all() return projects
def deleteTask(self, id): db_session.query(TaskEntity).filter(TaskEntity.id == id).delete() db_session.commit() return id
def updateTaskStatus(self, id, status): db_session.query(TaskEntity).filter(TaskEntity.id == id).update({'status_id': status}) db_session.commit()
def getTask(self, id): return db_session.query(TaskEntity).filter(TaskEntity.id == id).first()
def getAllProjects(self): projects = db_session.query(ProjectEntity).all() for project in projects: project.release_date = str(project.release_date) return projects
def getProjectHistory(self, pid): db_session.flush() db_session.commit() return db_session.query(HistoryEntity).filter(HistoryEntity.pid == pid).all()
def getHistory(self): db_session.flush() db_session.commit() return db_session.query(HistoryEntity).all()
def getUserHistory(self, uid): db_session.flush() db_session.commit() return db_session.query(HistoryEntity).filter(HistoryEntity.uid == uid).all()
def getEvents(self): return db_session.query(EventEntity).all()
def getEventByName(self, name): return db_session.query(EventEntity).filter(EventEntity.name == name).first()
def getUserByUsername(self, username): user = db_session.query(UserEntity).filter(UserEntity.username == username).first() return user
def getTasksAssignedTo(self, id): return db_session.query(TaskEntity).filter(TaskEntity.reported_id == id)
def getAllUsers(self): users = db_session.query(UserEntity).all() for user in users: user.last_connect = str(user.last_connect) return users
def getProject(self, id): project = db_session.query(ProjectEntity).filter(ProjectEntity.pid == id).first() return project