public List<User> fetchUsersBeginningByAndAddableToWorkout(final String prefix, final long id) { final Query query = entityManager.createQuery( "select u from UserImpl u, WorkoutImpl workout where u.name<>'googlebot' AND u.name LIKE CONCAT(:prefix, '%')" + " AND u not MEMBER OF workout.participants AND workout.id = :id "); query.setParameter("prefix", prefix); query.setParameter("id", id); return query.getResultList(); }
public void forgotPassword(final String email) throws UserNotFoundException, MailException { final Query query = entityManager.createQuery("select u from UserImpl u where u.email=:cryptedMail"); query.setParameter("cryptedMail", CipherHelper.cipher(email)); final List<UserImpl> list = query.getResultList(); if (list.isEmpty()) throw new UserNotFoundException(); for (final UserImpl user : list) { final String password = Helper.randomstring(); user.setPassword(password); MailSender.forgotPasswordMail(user.getName(), password, email); entityManager.merge(user); } }
public List<Track> fetchTracks() { final Query query = entityManager.createQuery("select t from TrackImpl t"); return query.getResultList(); }
public List<Track> fetchTracks(final User user) { final Query query = entityManager.createQuery("select t from TrackImpl t where t.user =:user"); query.setParameter("user", user); return query.getResultList(); }
private Query query(final String queryString) { return entityManager.createQuery(queryString); }