Package org.hibernate.criterion

Examples of org.hibernate.criterion.DetachedCriteria.createAlias()

202
203
204
205
206
207
208
209
210
211
212
      final TypeSearchResult itemType, final CommentOptions commentOptions, final SearchPeriods period) {
    final DetachedCriteria criteria = DetachedCriteria
        .forClass(Comment.class);
    criteria.setProjection(Projections.rowCount());
    if (itemType.equals(TypeSearchResult.TWEETPOLL)) {
      criteria.createAlias("tweetPoll", "tweetPoll");
      criteria.add(Restrictions.isNotNull("tweetPoll"));
    } else if (itemType.equals(TypeSearchResult.POLL)) {
      criteria.createAlias("poll", "poll");
      criteria.add(Restrictions.isNotNull("poll"));
    } else if (itemType.equals(TypeSearchResult.SURVEY)) {
View Full Code Here
205
206
207
208
209
210
211
212
213
214
215
    criteria.setProjection(Projections.rowCount());
    if (itemType.equals(TypeSearchResult.TWEETPOLL)) {
      criteria.createAlias("tweetPoll", "tweetPoll");
      criteria.add(Restrictions.isNotNull("tweetPoll"));
    } else if (itemType.equals(TypeSearchResult.POLL)) {
      criteria.createAlias("poll", "poll");
      criteria.add(Restrictions.isNotNull("poll"));
    } else if (itemType.equals(TypeSearchResult.SURVEY)) {
      criteria.createAlias("survey", "survey");
      criteria.add(Restrictions.isNotNull("survey"));
    } else {
View Full Code Here
208
209
210
211
212
213
214
215
216
217
218
      criteria.add(Restrictions.isNotNull("tweetPoll"));
    } else if (itemType.equals(TypeSearchResult.POLL)) {
      criteria.createAlias("poll", "poll");
      criteria.add(Restrictions.isNotNull("poll"));
    } else if (itemType.equals(TypeSearchResult.SURVEY)) {
      criteria.createAlias("survey", "survey");
      criteria.add(Restrictions.isNotNull("survey"));
    } else {
      log.error(" Search result type undefined " + itemType);
    }
    if (!commentOptions.equals(CommentOptions.ALL)) {
View Full Code Here
281
282
283
284
285
286
287
288
289
290
291
     * @return
     */
    @SuppressWarnings("unchecked")
    public SocialAccount getAccountConnection(final String accountId, final SocialProvider provider){
        final DetachedCriteria criteria = DetachedCriteria.forClass(SocialAccount.class);
        criteria.createAlias("userAccout","userAccout");
        criteria.add(Restrictions.eq("userAccout.uid", accountId));
        criteria.add(Restrictions.eq("accounType", provider));
        return (SocialAccount) DataAccessUtils.uniqueResult(getHibernateTemplate()
                .findByCriteria(criteria));
    }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
     * @return
     */
    @SuppressWarnings("unchecked")
    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));
    }

View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
            final SearchPeriods period,
            final Integer start,
            final Integer maxResults,
            final Integer firstResult) {
        final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPoll.class);
        criteria.createAlias("question", "question");
        calculateSearchPeriodsDates(period, criteria, "createDate");
        criteria.add(Restrictions.eq("publishTweetPoll", Boolean.TRUE)); //should be published
        criteria.add(Restrictions.gt("relevance", 0L));
        criteria.addOrder(Order.desc("relevance"));
        criteria.addOrder(Order.desc("createDate"));
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
            final SearchPeriods period,
            final Integer start,
            final Integer maxResults,
            final Integer firstResult) {
        final DetachedCriteria criteria = DetachedCriteria.forClass(Poll.class);
        criteria.createAlias("question", "question");
        calculateSearchPeriodsDates(period, criteria, "createDate");
        criteria.add(Restrictions.gt("relevance", 0L));
        criteria.addOrder(Order.desc("relevance"));
        criteria.add(Restrictions.eq("publish", Boolean.TRUE)); //should be published
        criteria.addOrder(Order.desc("createDate"));
View Full Code Here
315
316
317
318
319
320
321
322
323
324
325
    public List getAllHitsByType(final TweetPoll tweetpoll,
            final Poll poll,
            final Survey survey) {
        final DetachedCriteria criteria = DetachedCriteria.forClass(Hit.class);
        if (poll != null) {
            criteria.createAlias("poll", "poll");
            criteria.add(Restrictions.eq("poll", poll));
        } else if (tweetpoll != null) {
            criteria.createAlias("tweetPoll", "tweetPoll");
            criteria.add(Restrictions.eq("tweetPoll", tweetpoll));
        } else if (survey != null) {
View Full Code Here
318
319
320
321
322
323
324
325
326
327
328
        final DetachedCriteria criteria = DetachedCriteria.forClass(Hit.class);
        if (poll != null) {
            criteria.createAlias("poll", "poll");
            criteria.add(Restrictions.eq("poll", poll));
        } else if (tweetpoll != null) {
            criteria.createAlias("tweetPoll", "tweetPoll");
            criteria.add(Restrictions.eq("tweetPoll", tweetpoll));
        } else if (survey != null) {
            criteria.createAlias("survey", "survey");
            criteria.add(Restrictions.eq("survey", survey));
        }
View Full Code Here
321
322
323
324
325
326
327
328
329
330
331
            criteria.add(Restrictions.eq("poll", poll));
        } else if (tweetpoll != null) {
            criteria.createAlias("tweetPoll", "tweetPoll");
            criteria.add(Restrictions.eq("tweetPoll", tweetpoll));
        } else if (survey != null) {
            criteria.createAlias("survey", "survey");
            criteria.add(Restrictions.eq("survey", survey));
        }
        return getHibernateTemplate().findByCriteria(criteria);
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.