Example usage for org.hibernate.criterion DetachedCriteria createAlias

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria createAlias.

Prototype

public DetachedCriteria createAlias(String associationPath, String alias)

Source Link

Document

Creates an association path alias within this DetachedCriteria.

Usage

From source file:org.encuestame.persistence.dao.imp.GroupDaoImp.java

License:Apache License

/**
 * Get Group by Id and User./*w ww. ja va  2  s. c  om*/
 * @param groupId group id
 * @param secUser {@link Account}
 * @return
 */
public Group getGroupByIdandUser(final Long groupId, final Long userId) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Group.class);
    criteria.createAlias("account", "account");
    criteria.add(Restrictions.eq("account.uid", userId));
    criteria.add(Restrictions.eq("tweetPollId", groupId));
    return (Group) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:org.encuestame.persistence.dao.imp.PollDao.java

License:Apache License

public Long getMaxPollLikeVotesbyUser(final Long userId, final Date dateFrom, final Date dateTo) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Poll.class);
    criteria.setProjection(Projections.max("likeVote"));
    criteria.createAlias("editorOwner", "editorOwner");
    criteria.add(Restrictions.eq("editorOwner.uid", userId));
    criteria.add(Restrictions.between("createDate", dateFrom, dateTo));
    @SuppressWarnings("unchecked")
    List<Poll> results = (List<Poll>) getHibernateTemplate().findByCriteria(criteria);
    return (Long) (results.get(0) == null ? 0 : results.get(0));
}

From source file:org.encuestame.persistence.dao.imp.PollDao.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Poll> retrieveFavouritesPoll(final UserAccount userAccount, final Integer maxResults,
        final Integer start) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Poll.class);
    criteria.createAlias("editorOwner", "editorOwner");
    criteria.add(Restrictions.eq("favourites", Boolean.TRUE));
    criteria.add(Restrictions.eq("editorOwner", userAccount));
    return (List<Poll>) filterByMaxorStart(criteria, maxResults, start);
}

From source file:org.encuestame.persistence.dao.imp.PollDao.java

License:Apache License

public Poll getPollbyQuestion(final Long questionId) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Poll.class);
    criteria.createAlias("question", "question");
    criteria.add(Restrictions.eq("question.qid", questionId));
    return (Poll) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:org.encuestame.persistence.dao.imp.PollDao.java

License:Apache License

/**
 *
 * @param property/* w w w.  j  ava2  s.c  om*/
 * @param property_value
 * @param itemId
 * @param criteria
 * @param isCompleted
 * @param isScheduled
 * @param isFavourite
 * @param isPublished
 * @param keyword
 * @param period
 */
public void criteriaAdvancedSearch(final String property, final String property_value, final Object itemId,
        final DetachedCriteria criteria, final Boolean isCompleted, final Boolean isScheduled,
        final Boolean isFavourite, final Boolean isPublished, final Boolean isHidden,
        final Boolean isPasswordProtected, final String keyword, final String period) {
    // criteria.add(Restrictions.eq("editorOwner.uid", userId)); -- POLL
    criteria.createAlias(property, property);
    criteria.add(Restrictions.eq(property + "." + property_value, itemId));
    criteria.addOrder(Order.desc("createDate"));
    this.advancedPollSearchOptions(criteria, isCompleted, isScheduled, isFavourite, isPublished, isHidden,
            isPasswordProtected, keyword, period);
}

From source file:org.encuestame.persistence.dao.imp.PollDao.java

License:Apache License

public List<Poll> retrievePollByDate(final PollSearchBean bean, final Long userId, final Date initDate) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Poll.class);
    criteria.createAlias("owner", "owner");
    criteria.add(Restrictions.eq("owner.id", userId));
    criteria.add(Restrictions.between("createDate", initDate, getNextDayMidnightDate()));
    return useAvancedSearch(criteria, bean);
}

From source file:org.encuestame.persistence.dao.imp.PollDao.java

License:Apache License

public List<Poll> retrieveFavouritesPoll(final PollSearchBean bean, final Long userId) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Poll.class);
    criteria.createAlias("owner", "owner");
    criteria.add(Restrictions.eq("owner.uid", userId));
    return useAvancedSearch(criteria, bean);
}

From source file:org.encuestame.persistence.dao.imp.PollDao.java

License:Apache License

public List<Poll> retrieveScheduledPoll(final PollSearchBean bean, final Long userId) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Poll.class);
    criteria.createAlias("owner", "owner");
    criteria.add(Restrictions.eq("owner.uid", userId));
    // To retrieve all and only scheduled Tweetpoll period should be = ALLTIME
    return useAvancedSearch(criteria, bean);
}

From source file:org.encuestame.persistence.dao.imp.QuestionDaoImp.java

License:Apache License

@SuppressWarnings("unchecked")
public final List<QuestionAnswer> getAnswersByQuestionId(final Long questionId) throws HibernateException {
    /*   return getHibernateTemplate().findByNamedParam("from QuestionAnswer where questions.id =:questionId ",
                                               "questionId", questionId);*/
    final DetachedCriteria criteria = DetachedCriteria.forClass(QuestionAnswer.class);
    criteria.createAlias("questions", "questions");
    criteria.add(Restrictions.eq("questions.qid", questionId));
    return (List<QuestionAnswer>) getHibernateTemplate().findByCriteria(criteria);

}

From source file:org.encuestame.persistence.dao.imp.QuestionDaoImp.java

License:Apache License

@SuppressWarnings("unchecked")
public List<QuestionPreferences> getQuestionPreference(final Question question, final String pref) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(QuestionPreferences.class);
    criteria.createAlias("question", "question");
    criteria.add(Restrictions.eq("question", question));
    //criteria.add(Restrictions.eq("preference", preference));
    criteria.add(Restrictions.like("preference", pref, MatchMode.ANYWHERE));
    return (List<QuestionPreferences>) getHibernateTemplate().findByCriteria(criteria);
}