Examples of com.j256.ormlite.stmt.query.SimpleComparison

com.j256.ormlite.stmt.query.SimpleComparison
Internal class handling a simple comparison query part where the operation is passed in. @author graywatson


  /**
   * Add a '=' clause so the column must be equal to the value.
   */
  public Where<T, ID> eq(String columnName, Object value) throws SQLException {
    addClause(new SimpleComparison(columnName, findColumnFieldType(columnName), value,
        SimpleComparison.EQUAL_TO_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Add a '&gt;=' clause so the column must be greater-than or equals-to the value.
   */
  public Where<T, ID> ge(String columnName, Object value) throws SQLException {
    addClause(new SimpleComparison(columnName, findColumnFieldType(columnName), value,
        SimpleComparison.GREATER_THAN_EQUAL_TO_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Add a '&gt;' clause so the column must be greater-than the value.
   */
  public Where<T, ID> gt(String columnName, Object value) throws SQLException {
    addClause(new SimpleComparison(columnName, findColumnFieldType(columnName), value,
        SimpleComparison.GREATER_THAN_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Add a '&lt;=' clause so the column must be less-than or equals-to the value.
   */
  public Where<T, ID> le(String columnName, Object value) throws SQLException {
    addClause(new SimpleComparison(columnName, findColumnFieldType(columnName), value,
        SimpleComparison.LESS_THAN_EQUAL_TO_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Add a '&lt;' clause so the column must be less-than the value.
   */
  public Where<T, ID> lt(String columnName, Object value) throws SQLException {
    addClause(new SimpleComparison(columnName, findColumnFieldType(columnName), value,
        SimpleComparison.LESS_THAN_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Add a LIKE clause so the column must mach the value using '%' patterns.
   */
  public Where<T, ID> like(String columnName, Object value) throws SQLException {
    addClause(new SimpleComparison(columnName, findColumnFieldType(columnName), value,
        SimpleComparison.LIKE_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Add a '&lt;&gt;' clause so the column must be not-equal-to the value.
   */
  public Where<T, ID> ne(String columnName, Object value) throws SQLException {
    addClause(new SimpleComparison(columnName, findColumnFieldType(columnName), value,
        SimpleComparison.NOT_EQUAL_TO_OPERATION));
    return this;
  }

View Full Code Here

   */
  public Where<T, ID> idEq(ID id) throws SQLException {
    if (idColumnName == null) {
      throw new SQLException("Object has no id column specified");
    }
    addClause(new SimpleComparison(idColumnName, idFieldType, id, SimpleComparison.EQUAL_TO_OPERATION));
    return this;
  }

View Full Code Here

   */
  public <OD> Where<T, ID> idEq(Dao<OD, ?> dataDao, OD data) throws SQLException {
    if (idColumnName == null) {
      throw new SQLException("Object has no id column specified");
    }
    addClause(new SimpleComparison(idColumnName, idFieldType, dataDao.extractId(data),
        SimpleComparison.EQUAL_TO_OPERATION));
    return this;
  }

View Full Code Here

    assertTrue(where.toString().contains("empty where clause"));
    String value = "bar";
    FieldType numberFieldType =
        FieldType.createFieldType(connectionSource, "foo", Foo.class.getDeclaredField(Foo.VAL_COLUMN_NAME),
            Foo.class);
    SimpleComparison eq =
        new SimpleComparison(Foo.VAL_COLUMN_NAME, numberFieldType, value, SimpleComparison.EQUAL_TO_OPERATION);
    where.eq(Foo.VAL_COLUMN_NAME, value);
    assertTrue(where.toString().contains(eq.toString()));
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.j256.ormlite.stmt.query.SimpleComparison

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.