Examples of com.j256.ormlite.field.FieldConverter

com.j256.ormlite.stmt.query.ManyClause
Convert a Java object into the appropriate argument to a SQL statement and then back from the result set to the Java object. This allows databases to configure per-type conversion. This is used by the {@link BaseDatabaseType#getFieldConverter(DataPersister)} method to find the converter for a particular databasetype. Databases can then override the default data conversion mechanisms as necessary. @author graywatson

   * </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


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

View Full Code Here


  /**
   * AND operation which takes the previous clause and the next clause and AND's them together.
   */
  public Where<T, ID> and() {
    addNeedsFuture(new ManyClause(pop("AND"), ManyClause.AND_OPERATION));
    return this;
  }

View Full Code Here

   */
  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

    }
    Clause[] clauses = new Clause[numClauses];
    for (int i = numClauses - 1; i >= 0; i--) {
      clauses[i] = pop("AND");
    }
    addClause(new ManyClause(clauses, ManyClause.AND_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * OR operation which takes the previous clause and the next clause and OR's them together.
   */
  public Where<T, ID> or() {
    addNeedsFuture(new ManyClause(pop("OR"), ManyClause.OR_OPERATION));
    return this;
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.j256.ormlite.field.FieldConverter

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

com.j256.ormlite.dao.DaoManager

com.j256.ormlite.dao.DaoManagerTest

com.j256.ormlite.dao.DoubleDbOpenTest

com.j256.ormlite.dao.RuntimeExceptionDaoTest

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.