Examples of autoClose()

Examples of jodd.db.DbQuery.autoClose()

111
112
113
114
115
116
117
118
119
120
121
  /**
   * Simply inserts object into the database.
   */
  public void save(Object entity) {
    DbQuery q = query(insert(entity));
    q.autoClose().executeUpdate();
  }

  /**
   * Inserts bunch of objects into the database.
   * @see #save(Object)
View Full Code Here

Examples of jodd.db.DbQuery.autoClose()

62
63
64
65
66
67
68
69
70
71
72
    assertEquals(2, dq.executeCount());

    //dq.reset();
    dq.setInteger("id", 10);
    assertEquals(1, session.getTotalQueries());
    assertEquals(0, dq.autoClose().executeCount());

    assertEquals(0, session.getTotalQueries());


    // ---------------------------------------------------------------- girl
View Full Code Here

Examples of jodd.db.DbQuery.autoClose()

37
38
39
40
41
42
43
44
45
46
47
        "TIME timestamp not null default CURRENT_TIMESTAMP, " +
        "primary key (ID)" +
        ')';

    DbQuery query = new DbQuery(sql);
    query.autoClose().executeUpdate();
    assertTrue(query.isClosed());

    executeUpdate(session, "insert into GIRL(ID, NAME, SPECIALITY) values(1, 'Anna', 'swim')");
    executeUpdate(session, "insert into GIRL(ID, NAME, SPECIALITY) values(2, 'Sandra', 'piano')");
    executeUpdate(session, "insert into GIRL(NAME) values('Monica')");
View Full Code Here

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

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

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

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

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

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

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

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

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

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

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

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

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
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.