Examples of com.j256.ormlite.h2.H2DatabaseConnection

com.j256.ormlite.stmt.query.In
H2 connection. Unfortunately, a good bit of this is copied from the JdbcDatabaseConnection. @author graywatson

  protected final DatabaseType databaseType = new H2DatabaseType();
  protected WrappedConnectionSource connectionSource;


  @Before
  public void before() throws Exception {
    connectionSource = new WrappedConnectionSource(new H2ConnectionSource());
  }

View Full Code Here

  protected DatabaseType databaseType;
  protected WrappedConnectionSource connectionSource;


  @Before
  public void before() throws Exception {
    connectionSource = new WrappedConnectionSource(new H2ConnectionSource());
    databaseType = connectionSource.getDatabaseType();
    DaoManager.clearCache();
  }

View Full Code Here

  }


  @Test
  public void testCreateTableQueriesAfter() throws Exception {
    final String queryAfter = "SELECT * from foo";
    DatabaseType databaseType = new H2DatabaseType() {
      @Override
      public void appendColumnArg(StringBuilder sb, FieldType fieldType, List<String> additionalArgs,
          List<String> statementsBefore, List<String> statementsAfter, List<String> queriesAfter)
          throws SQLException {
        super.appendColumnArg(sb, fieldType, additionalArgs, statementsBefore, statementsAfter, queriesAfter);

View Full Code Here

  }


  @Test
  public void testCreateTableQueriesAfter() throws Exception {
    final String queryAfter = "SELECT * from foo";
    DatabaseType databaseType = new H2DatabaseType() {
      @Override
      public void appendColumnArg(String tableName, StringBuilder sb, FieldType fieldType,
          List<String> additionalArgs, List<String> statementsBefore, List<String> statementsAfter,
          List<String> queriesAfter) throws SQLException {
        super.appendColumnArg(tableName, sb, fieldType, additionalArgs, statementsBefore, statementsAfter,

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

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.j256.ormlite.h2.H2DatabaseConnection

android.database.sqlite.SQLiteStatement

com.j256.ormlite.android.AndroidDatabaseConnection

com.j256.ormlite.android.apptools.OrmLiteSqliteOpenHelper

com.j256.ormlite.BaseCoreTest

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