def setStatusForUser(self, movie_id, user_id, userStatus):
movie = session.query(Movie).filter(Movie.id == movie_id).first()
for listeningUser in movie.listeningUsers:
if listeningUser.user_id == user_id:
listeningUser.status = userStatus
self.saveMovie(movie)
print movie.listeningUsers
def findNonArchivedForUser(self, userId):
return session.query(Movie).filter(Movie.listeningUsers.any(user_id=userId)).\
filter(~Movie.listeningUsers.any(status=UserStatus.ARCHIVED)).all()
def findByStatus(self, status):
return session.query(Movie).filter(Movie.status == status).all()
def findById(self, id):
return session.query(Movie).filter(Movie.id == id).one()
def findByIMDBId(self, imdbId):
return session.query(Movie).filter(Movie.imdbId == imdbId).all()
def findForUser(self, user_id):
return session.query(Movie).filter(
Movie.listeningUsers.any(user_id=user_id)).all()
def findByEmailIdAndPassword(self, emailId, password):
return session.query(User).filter(User.emailId == emailId).filter(
User.password == md5.new(password).hexdigest()).one()
def findByEmailId(self, emailId):
return session.query(User).filter(User.emailId == emailId).first()
def findById(self, id):
return session.query(User).filter(User.id == id).one()
def findAll(self):
return session.query(User).all()