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
