Examples of com.j256.ormlite.stmt.SelectArg

com.j256.ormlite.stmt.query.IsNotNull
An argument to a select SQL statement. After the query is constructed, the caller can set the value on this argument and run the query. Then the argument can be set again and the query re-executed. This is equivalent in SQL to a ? argument.
NOTE: If the argument has not been set by the time the query is executed, an exception will be thrown.

NOTE: For protections sake, the object cannot be reused with different column names.
@author graywatson

   */
  private PreparedQuery<User> makeUsersForPostQuery() throws SQLException {
    QueryBuilder<UserPost, Integer> userPostQb = userPostDao.queryBuilder();
    // this time selecting for the user-id field
    userPostQb.selectColumns(UserPost.USER_ID_FIELD_NAME);
    SelectArg postSelectArg = new SelectArg();
    userPostQb.where().eq(UserPost.POST_ID_FIELD_NAME, postSelectArg);


    // build our outer query
    QueryBuilder<User, Integer> userQb = userDao.queryBuilder();
    // where the user-id matches the inner query's user-id field

View Full Code Here

   * <b>NOTE:</b> I couldn't remove the code warning associated with this method when used with more than 2 arguments.
   * </p>
   */
  public Where<T, ID> and(Where<T, ID> first, Where<T, ID> second, Where<T, ID>... others) {
    Clause[] clauses = buildClauseArray(others, "AND");
    Clause secondClause = pop("AND");
    Clause firstClause = pop("AND");
    addClause(new ManyClause(firstClause, secondClause, clauses, ManyClause.AND_OPERATION));
    return this;
  }

View Full Code Here

   * <b>NOTE:</b> I can't remove the code warning associated with this method. Use the iterator method below.
   * </p>
   */
  public Where<T, ID> or(Where<T, ID> left, Where<T, ID> right, Where<T, ID>... others) {
    Clause[] clauses = buildClauseArray(others, "OR");
    Clause secondClause = pop("OR");
    Clause firstClause = pop("OR");
    addClause(new ManyClause(firstClause, secondClause, clauses, ManyClause.OR_OPERATION));
    return this;
  }

View Full Code Here

  @Override
  public String toString() {
    if (clauseStackLevel == 0) {
      return "empty where clause";
    } else {
      Clause clause = peek();
      return "where clause: " + clause;
    }
  }

View Full Code Here

  private Clause pop(String label) {
    if (clauseStackLevel == 0) {
      throw new IllegalStateException("Expecting there to be a clause already defined for '" + label
          + "' operation");
    }
    Clause clause = clauseStack[--clauseStackLevel];
    // to help gc
    clauseStack[clauseStackLevel] = null;
    return clause;
  }

View Full Code Here

   * </p>
   */
  public Where<T, ID> exists(QueryBuilder<?, ?> subQueryBuilder) throws SQLException {
    // we do this to turn off the automatic addition of the ID column in the select column list
    subQueryBuilder.enableInnerQuery();
    addClause(new Exists(new InternalQueryBuilderWrapper(subQueryBuilder)));
    return this;
  }

View Full Code Here


  /**
   * Add a IN clause so the column must be equal-to one of the objects from the list passed in.
   */
  public Where<T, ID> in(String columnName, Iterable<?> objects) throws SQLException {
    addClause(new In(columnName, findColumnFieldType(columnName), objects));
    return this;
  }

View Full Code Here

   */
  public Where<T, ID> in(String columnName, Object... objects) throws SQLException {
    if (objects.length == 1 && objects[0].getClass().isArray()) {
      throw new IllegalArgumentException("in(Object... objects) seems to be an array within an array");
    }
    addClause(new In(columnName, findColumnFieldType(columnName), objects));
    return this;
  }

View Full Code Here

      throw new SQLException("Inner query must have only 1 select column specified instead of "
          + subQueryBuilder.getSelectColumnCount());
    }
    // we do this to turn off the automatic addition of the ID column in the select column list
    subQueryBuilder.enableInnerQuery();
    addClause(new InSubQuery(columnName, findColumnFieldType(columnName), new InternalQueryBuilderWrapper(
        subQueryBuilder)));
    return this;
  }

View Full Code Here


  /**
   * Add a 'IS NOT NULL' clause so the column must not be null. '<>' NULL does not work.
   */
  public Where<T, ID> isNotNull(String columnName) throws SQLException {
    addClause(new IsNotNull(columnName, findColumnFieldType(columnName)));
    return this;
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.j256.ormlite.stmt.SelectArg

android.database.sqlite.SQLiteStatement

com.j256.ormlite.android.AndroidDatabaseConnection

com.j256.ormlite.android.apptools.OrmLiteSqliteOpenHelper

com.j256.ormlite.dao.BaseDaoImpl

com.j256.ormlite.dao.BaseDaoImplTest

com.j256.ormlite.dao.BaseForeignCollection

com.j256.ormlite.dao.Dao.CreateOrUpdateStatus

com.j256.ormlite.dao.DaoManager

com.j256.ormlite.dao.DaoManagerTest

com.j256.ormlite.dao.DoubleDbOpenTest

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.