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()