Examples of jodd.db.oom.DbOomQuery

jodd.db.oom.DbOomQuery
A simple ORM extension for {@link DbQuery}.
OOM extension may map results to objects in two ways:
- auto mode - when result set is mapped to provided types, and
- mapped mode - requires explicit mapping definitions.


  /**
   * 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();
  }

View Full Code Here


      DbEntityDescriptor ded = dbOomManager.lookupType(entityType);
      String tableName = ded.getTableName();
      String idColumn = ded.getIdColumnName();


      DbOomQuery dbOomQuery = query("select max(" + idColumn + ") from " + tableName);


      long lastLong = dbOomQuery.autoClose().executeCount();


      if (log.isDebugEnabled()) {
        log.debug("Last id for " + entityType.getName() + " is " + lastLong);
      }

View Full Code Here

      dbSqlGenerator = parsedSql;
    }


    // db oom query


    DbOomQuery dbOomQuery = query(dbSqlGenerator);


    // parameter names


    String keyName = proxyTargetInfo.targetClass.getName() + "." + proxyTargetInfo.targetMethodName;


    String[] paramNames = methodParamNames.get(keyName);


    if (paramNames == null) {
      paramNames = resolveMethodParameterNames(proxyTargetInfo);
      methodParamNames.put(keyName, paramNames);
    }


    // set SQL parameters


    for (int i = 0; i < paramNames.length; i++) {
      String paramName = paramNames[i];


      dbOomQuery.setObject(paramName, proxyTargetInfo.arguments[i]);
    }


    return dbOomQuery;
  }

View Full Code Here




  private void insertAnswers() {
    DbSession dbSession = AppCore.ref.createDbSession();


    DbOomQuery dbQuery = new DbOomQuery(dbSession, DbSqlBuilder.sql("select $C{q.*} from $T{Question q} order by $q.id"));
    List<Question> questions =  dbQuery.list();
    dbQuery.close();
    
    for(Question q : questions) {


      dbQuery = new DbOomQuery(dbSession, DbSqlBuilder.sql("select $C{a.*} from $T{Answer a} where $a.questionId=:questionId"));
      dbQuery.setLong("questionId", q.getId());
      List<Answer> answers =  dbQuery.list();
      dbQuery.close();
      
      for (Answer a : answers) {
        dbQuery = new DbOomQuery(dbSession, DbEntitySql.updateColumn(a, "votes", Integer.valueOf(MathUtil.randomInt(10, 50))));
        dbQuery.autoClose().executeUpdate();
      }
    }
  }

View Full Code Here

  /**
   * Returns {@link jodd.db.oom.DbOomQuery} instance for more fluent interface.
   *
   */
  public DbOomQuery query() {
    return new DbOomQuery(this);
  }

View Full Code Here

  public DbOomQuery query() {
    return new DbOomQuery(this);
  }


  public DbOomQuery query(DbSession session) {
    return new DbOomQuery(session, this);
  }

View Full Code Here

0 1 2

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

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.