Package jodd.db.oom

Examples of jodd.db.oom.DbOomQuery

100
101
102
103
104
105
106
107
108
109
110
  /**
   * Increments repeat count.
   */
  public void incrementRepeatCount(EmailMessage emailMessage) {
    DbOomQuery q = query(sql("update $T{EmailMessage email} set $email.repeatCount=:take where $email.id=:id"));
    emailMessage.incrementRepeatCount();
    q.setInteger("take", emailMessage.getRepeatCount());
    q.setLong("id", emailMessage.getId());
    q.autoClose().executeUpdate();
  }
View Full Code Here
111
112
113
114
115
116
117
118
  /**
   * Updates repeat count to 0 for all message.
   */
  public void enableAllEmails() {
    DbOomQuery q = query(sql("update $T{EmailMessage email} set $email.repeatCount=0"));
    q.autoClose().executeUpdate();
  }
View Full Code Here
119
120
121
122
123
124
125
126
127
  /**
   * Enables single message for sending.
   */
  public void enableEmail(EmailMessage emailMessage){
    DbOomQuery q = query(sql("update $T{EmailMessage email} set $email.repeatCount=0 where $email.id=:id"));
    q.setLong("id", emailMessage.getId());
    q.autoClose().executeUpdate();
  }
View Full Code Here
24
25
26
27
28
29
30
31
32
33
  /**
   * Finds user favorites or <code>null</code> if user has not marked question as favorite.
   */
  protected Favorites findUserFavorite(Question question, User user) {
    DbOomQuery dbOom = query(sql("select $C{f.*} from $T{Favorites f} where $f.questionId = :questionId and $f.userId = :userId"));
    dbOom.setLong(1, question.getId());
    dbOom.setLong(2, user.getId());
    return (Favorites) dbOom.autoClose().find();
  }
View Full Code Here
60
61
62
63
64
65
66
67
68
  /**
   * Find favorite question for user.
   */
  public List<Question> findUserFavorites(User user){
    DbOomQuery dbOom = query(sql("select $C{q.*} from $T{Question q} join $T{Favorites f} on $q.id = $f.questionId where $f.userId = :userId order by $q.date desc"));
    dbOom.setInteger("userId", user.getId());
    return dbOom.autoClose().list(Question.class);
  }
View Full Code Here
362
363
364
365
366
367
368
  /**
   * Returns {@link jodd.db.oom.DbOomQuery} instance for more fluent interface.
   *
   */
  public DbOomQuery query() {
    return new DbOomQuery(this);
  }
View Full Code Here
366
367
368
369
370
371
372
  public DbOomQuery query() {
    return new DbOomQuery(this);
  }

  public DbOomQuery query(DbSession session) {
    return new DbOomQuery(session, this);
  }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
    int from = (page - 1) * pageSize;

    String pageSql = buildPageSql(sql, from, pageSize);
    DbSqlBuilder dbsql = sql(pageSql);

    DbOomQuery query = query(dbsql);
    query.setMaxRows(pageSize);
    query.setFetchSize(pageSize);
    query.setMap(params);

    List<T> list = query.list(pageSize, target);
    query.close();

    String countSql = buildCountSql(sql);
    dbsql = sql(countSql);
    query = query(dbsql);
    query.setMap(params);
    long count = query.executeCount();
    query.close();

    return new PageData<T>(page, (int) count, pageSize, list);
  }
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
  public Question findQuestionForDate(int date) {
    if (log.isDebugEnabled()) {
      log.debug("finding question for " + date);
    }
    DbOomQuery dbOom = query(sql("select $C{q.*} from $T{Question q} where $q.countryId is null and $q.date <= :date order by $q.date desc limit 0,1"));
    dbOom.setMaxRows(1);
    dbOom.setFetchSize(1);
    dbOom.setInteger("date", date);
    return dbOom.autoClose().find(Question.class);
  }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
  /**
   * Finds next question of current one.
   * Returns <code>null</code> if there is no next question.
   */
  public Question findNextQuestion(Question q) {
    DbOomQuery dbOom = query(sql("select $C{q.*} from $T{Question q} where $q.date > :date order by $q.date limit 0,1"));
    dbOom.setMaxRows(1);
    dbOom.setFetchSize(1);
    dbOom.setInteger("date", q.getDate());
    return dbOom.autoClose().find(Question.class);
  }
View Full Code Here
TOP

Related Classes of jodd.db.oom.DbOomQuery

  • com.uphea.install.DbInstaller
  • com.uphea.service.AnswerService
  • com.uphea.service.EmailService
  • com.uphea.service.FavoritesService
  • com.uphea.service.QuestionService
  • jodd.db.oom.mapper.DefaultResultSetMapper
  • jodd.db.oom.mapper.ResultSetMapper
  • jodd.db.oom.sqlgen.DbSqlBuilder
  • jodd.db.oom.sqlgen.ParameterValue
  • jodd.joy.db.DbIdGenerator
    • Copyright © 2018 www.massapicom. 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.