def getUserByID(cls, id):
cls.initDAO()
session = Session()
return session.query(User).filter(User.id == id).limit(1).first()
def getAllUsers(cls):
cls.initDAO()
session = Session()
return session.query(User).all()
def getResultByID(cls, id):
cls.initDAO()
session = Session()
return session.query(Result).filter(Result.id == id).limit(1).first()
def getAggregatedResultForUser(cls, user):
cls.initDAO()
session = Session()
return session.query(func.sum(Result.correct).label("total_correct"),
func.sum(Result.wrong).label("total_wrong")).filter(Result.user_id == user).first()
def getLogin(cls, login):
cls.initDAO()
session = Session()
return session.query(Login).filter(
Login.username == login.username).first()
def getAllEmails(cls):
cls.initDAO()
session = Session()
return session.query(Email).all()
def getRandomNEmails(cls, n):
cls.initDAO()
session = Session()
return session.query(Email).order_by(func.random()).limit(5)
def getEmailByID(cls, id):
cls.initDAO()
session = Session()
return session.query(Email).order_by().limit(1)
def getTrainingSessionByID(cls, id):
cls.initDAO()
session = Session()
return session.query(TrainingSession).filter(TrainingSession.id == id).limit(1).first()