Package jodd.db.oom

Examples of jodd.db.oom.DbOomQuery

73
74
75
76
77
78
79
80
81
82
83
  /**
   * Finds previous question of current one.
   * Returns <code>null</code> if there is no previous question.
   */
  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);
  }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
  /**
   * Returns list of previous questions.
   */
  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);
  }
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
  /**
   * Finds random question from the past.
   */
  public Question findRandomPastQuestion(JDateTime untilDate) {
    DbOomQuery dbOom = query(sql("select $C{q.*} from $T{Question q} where $q.date < :date order by rand() limit 1"));
    dbOom.setMaxRows(1);
    dbOom.setFetchSize(1); 
    dbOom.setInteger("date", DateUtil.toIntDate(untilDate));
    return dbOom.autoClose().find(Question.class);
  }
View Full Code Here
105
106
107
108
109
110
111
112
113
  /**
   * Finds question for given answer.
   */
  public Question findAnswersQuestion(Long answerId) {
    DbOomQuery dbOom = query(sql("select $C{q.*} from $T{Question q} join $T{Answer a} on $q.id=$a.questionId where $a.id=:answerId"));
    dbOom.setLong("answerId", answerId);
    return dbOom.find(Question.class);
  }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
  /**
   * Finds user answer for question.
   */
  public Answer findUserAnswerForQuestion(User user, Question question) {
    DbOomQuery dbOom = query(sql("select $C{a.*} from $T{Answer a} join $T{Vote v} on $v.answerId=$a.id where $v.userId=:userId and $a.questionId=:questionId"));
    dbOom.setLong("userId", user.getId());
    dbOom.setLong("questionId", question.getId());
    return dbOom.autoClose().find(Answer.class);
  }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
85
  /**
   * Updates answer votes count.
   */
  public void updateAnswerVoteCount(Answer answer, boolean increment) {
    char operation = increment ? '+' : '-';
    DbOomQuery dbOom = query(sql("update $T{Answer a} set $a.votes = $a.votes " + operation + " 1 where $a.id = :id"));
    dbOom.setLong(1, answer.getId());
    dbOom.autoClose().executeUpdate();
    if (increment) {
      answer.incrementVotes();
    } else {
      answer.decrementVotes();
    }
View Full Code Here
96
97
98
99
100
101
102
103
104
105
  /**
   * Finds user vote for question.
   */
  public Vote findUserVoteForQuestion(User user, Question question) {
    DbOomQuery dbOom = query(sql("select $C{v.*} from $T{Vote v} join $T{Answer a} on $v.answerId=$a.id where $v.userId=:userId and $a.questionId=:questionId"));
    dbOom.setLong("userId", user.getId());
    dbOom.setLong("questionId", question.getId());
    return dbOom.autoClose().find(Vote.class);
  }
View Full Code Here
137
138
139
140
141
142
143
144
145
  /**
   * Counts user votes.
   */
  public long countUserVotes(User user) {
    DbOomQuery dbOom = query(sql("select count(1) from $T{Vote v} where $v.userId = :userId"));
    dbOom.setInteger("userId", user.getId());
    return dbOom.autoClose().executeCount();
  }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
75
    String tsql = "select $C{email.*} from $T{EmailMessage email} where $email.repeatCount < :maxTake order by $email.id";
    if (returnAll == false) {
      tsql += " limit :max";
    }

    DbOomQuery q = query(sql(tsql));

    q.setInteger(1, maxRepeatsOnError);
    if (returnAll == false) {
      q.setInteger(2, maxEmailsPerSession);
    }

    return q.autoClose().list(EmailMessage.class);
  }
View Full Code Here
77
78
79
80
81
82
83
84
  /**
   * Counts all email messages.
   */
  public long countEmails() {
    DbOomQuery q = query(sql("select count(1) from $T{EmailMessage email}"));
    return q.autoClose().executeCount();
  }
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.