Package jodd.db.oom

Examples of jodd.db.oom.DbOomQuery.autoClose()

87
88
89
90
91
92
93
94
95
96
97
   * Counts pending messages.
   */
  public long countPendingEmails() {
    DbOomQuery q = query(sql("select count(1) from $T{EmailMessage email} where $email.repeatCount < :maxTake"));
    q.setInteger(1, maxRepeatsOnError);
    return q.autoClose().executeCount();
  }
  /**
   * Deletes sent message.
   */
  public void deleteEmail(EmailMessage emailMessage) {
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
  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();
  }

  /**
   * Updates repeat count to 0 for all message.
   */
 
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
  /**
   * 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();
  }

  /**
   * Enables single message for sending.
   */
 
View Full Code Here
121
122
123
124
125
126
127
128
129
   * 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
27
28
29
30
31
32
33
34
35
36
37
   */
  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();
  }

  /**
   * Returns <code>true</code> if a question is favorite for a user.
   */
 
View Full Code Here
62
63
64
65
66
67
68
69
70
   * 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
53
54
55
56
57
58
59
60
61
62
63
    }
    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);
  }

  /**
   * Finds next question of current one.
   * Returns <code>null</code> if there is no next question.
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
  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);
  }

  /**
   * Finds previous question of current one.
   * Returns <code>null</code> if there is no previous question.
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
  public Question findPreviousQuestion(Question q) {
    DbOomQuery dbOom = query(sql("select $C{q.*} from $T{Question q} where $q.date < :date order by $q.date desc limit 0,1"));
    dbOom.setMaxRows(1);
    dbOom.setFetchSize(1);
    dbOom.setInteger("date", q.getDate());
    return dbOom.autoClose().find(Question.class);
  }

  /**
   * Returns list of previous questions.
   */
 
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
   */
  public List<Question> findPreviousQuestions(Question q, int howMany) {
    DbOomQuery dbOom = query(sql("select $C{q.*} from $T{Question q} where $q.date < :date order by $q.date desc limit 0,:howMany"));
    dbOom.setInteger("date", q.getDate());
    dbOom.setInteger("howMany", howMany);
    return dbOom.autoClose().list(Question.class);
  }

  /**
   * Finds random question from the past.
   */
 
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.