Package com.j256.ormlite.stmt.query

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

420
421
422
423
424
425
426
427
   * Add a raw statement as part of the where that can be anything that the database supports. Using more structured
   * methods is recommended but this gives more control over the query and allows you to utilize database specific
   * features.
   */
  public Where<T, ID> raw(String rawStatement) {
    addClause(new Raw(rawStatement));
    return this;
  }
View Full Code Here
64
65
66
67
68
69
70
71
  public StatementBuilder<T, ID> updateColumnExpression(String columnName, String expression) throws SQLException {
    FieldType fieldType = verifyColumnName(columnName);
    if (fieldType.isForeignCollection()) {
      throw new SQLException("Can't update foreign colletion field: " + columnName);
    }
    addUpdateColumnToList(columnName, new SetExpression(columnName, fieldType, expression));
    return this;
  }
View Full Code Here
45
46
47
48
49
50
51
52
  public StatementBuilder<T, ID> updateColumnValue(String columnName, Object value) throws SQLException {
    FieldType fieldType = verifyColumnName(columnName);
    if (fieldType.isForeignCollection()) {
      throw new SQLException("Can't update foreign colletion field: " + columnName);
    }
    addUpdateColumnToList(columnName, new SetValue(columnName, fieldType, value));
    return this;
  }
View Full Code Here
198
199
200
201
202
203
204
205
206
  /**
   * 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
207
208
209
210
211
212
213
214
215
  /**
   * 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
216
217
218
219
220
221
222
223
224
  /**
   * 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
296
297
298
299
300
301
302
303
304
  /**
   * 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
305
306
307
308
309
310
311
312
313
  /**
   * 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
314
315
316
317
318
319
320
321
322
  /**
   * 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
323
324
325
326
327
328
329
330
331
  /**
   * 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
TOP

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

  • 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
    • 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.