Examples of DatabaseResults

com.j256.ormlite.support.DatabaseResults
A reduction of the SQL ResultSet so we can implement it outside of JDBC.
NOTE: In all cases, the columnIndex parameters are 0 based -- not 1 based like JDBC.
@author graywatson

Examples of com.j256.ormlite.support.DatabaseResults

   * Return the first object that matches the {@link PreparedStmt} or null if none.
   */
  public T queryForFirst(DatabaseConnection databaseConnection, PreparedStmt<T> preparedStmt) throws SQLException {
    CompiledStatement stmt = preparedStmt.compile(databaseConnection);
    try {
      DatabaseResults results = stmt.runQuery();
      if (results.next()) {
        logger.debug("query-for-first of '{}' returned at least 1 result", preparedStmt.getStatement());
        return preparedStmt.mapRow(results);
      } else {
        logger.debug("query-for-first of '{}' returned at 0 results", preparedStmt.getStatement());
        return null;

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseResults

    // now execute any test queries which test the newly created table
    for (String query : queriesAfter) {
      CompiledStatement compiledStmt = null;
      try {
        compiledStmt = connection.compileStatement(query, StatementType.EXECUTE, noFieldTypes);
        DatabaseResults results = compiledStmt.runQuery();
        int rowC = 0;
        // count the results
        while (results.next()) {
          rowC++;
        }
        logger.info("executing create table after-query got {} results: {}", rowC, query);
      } catch (SQLException e) {
        // we do this to make sure that the statement is in the exception

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseResults

    Foo foo = new Foo();
    // it can't be null
    foo.name = nameArg + " not that";
    assertEquals(nameArg, fieldType.extractJavaFieldToSqlArgValue(foo));


    DatabaseResults resultMock = createMock(DatabaseResults.class);
    expect(resultMock.findColumn("name")).andReturn(0);
    expect(resultMock.wasNull(0)).andReturn(false);
    replay(resultMock);
    assertEquals(nameResult, fieldType.resultToJava(resultMock, new HashMap<String, Integer>()));
    verify(resultMock);
  }

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseResults

  public void testNullPrimitiveThrow() throws Exception {
    Field field = ThrowIfNullNonPrimitive.class.getDeclaredField("primitive");
    FieldType fieldType =
        FieldType.createFieldType(connectionSource, ThrowIfNullNonPrimitive.class.getSimpleName(), field,
            ThrowIfNullNonPrimitive.class);
    DatabaseResults results = createMock(DatabaseResults.class);
    int fieldNum = 1;
    expect(results.findColumn(field.getName())).andReturn(fieldNum);
    expect(results.getInt(fieldNum)).andReturn(0);
    expect(results.wasNull(fieldNum)).andReturn(true);
    replay(results);
    fieldType.resultToJava(results, new HashMap<String, Integer>());
    verify(results);
  }

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseResults

    assertTrue(fields.length >= 1);
    Field field = fields[0];
    FieldType fieldType =
        FieldType.createFieldType(connectionSource, SerializableField.class.getSimpleName(), field,
            SerializableField.class);
    DatabaseResults results = createMock(DatabaseResults.class);
    int fieldNum = 1;
    expect(results.findColumn(field.getName())).andReturn(fieldNum);
    expect(results.getTimestamp(fieldNum)).andReturn(null);
    expect(results.wasNull(fieldNum)).andReturn(true);
    replay(results);
    assertNull(fieldType.resultToJava(results, new HashMap<String, Integer>()));
    verify(results);
  }

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseResults

    Field[] fields = InvalidType.class.getDeclaredFields();
    assertTrue(fields.length >= 1);
    Field field = fields[0];
    FieldType fieldType =
        FieldType.createFieldType(connectionSource, InvalidType.class.getSimpleName(), field, InvalidType.class);
    DatabaseResults results = createMock(DatabaseResults.class);
    int fieldNum = 1;
    expect(results.findColumn(field.getName())).andReturn(fieldNum);
    expect(results.wasNull(fieldNum)).andReturn(true);
    replay(results);
    assertNull(fieldType.resultToJava(results, new HashMap<String, Integer>()));
    verify(results);
  }

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseResults

    foreignForeign.stuff = stuff;
    expect(
        connection.queryForOne(isA(String.class), isA(Object[].class), isA(FieldType[].class),
            isA(GenericRowMapper.class))).andReturn(foreignForeign);
    connectionSource.releaseConnection(connection);
    DatabaseResults results = createMock(DatabaseResults.class);
    ForeignAutoRefresh foreign = new ForeignAutoRefresh();
    replay(results, connectionSource, connection);
    FieldType fieldType =
        FieldType.createFieldType(connectionSource, ForeignAutoRefresh.class.getSimpleName(), field,
            ForeignAutoRefresh.class);

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseResults

    DatabaseConnection conn = connectionSource.getReadOnlyConnection();
    CompiledStatement stmt = null;
    try {
      stmt = conn.compileStatement("select * from " + TABLE_NAME, StatementType.SELECT, new FieldType[0]);


      DatabaseResults results = stmt.runQuery();
      while (results.next()) {
        LocalFoo foo2 = rowMapper.mapRow(results);
        assertEquals(foo1.id, foo2.id);
      }
    } finally {
      if (stmt != null) {

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseResults

      throws SQLException {
    DatabaseConnection conn = connectionSource.getReadOnlyConnection();
    CompiledStatement stmt = null;
    try {
      stmt = preparedQuery.compile(conn);
      DatabaseResults results = stmt.runQuery();
      int fooC = 0;
      while (results.next()) {
        LocalFoo foo2 = preparedQuery.mapRow(results);
        assertEquals(foos.get(fooC).id, foo2.id);
        fooC++;
      }
      assertEquals(expectedNum, fooC);

View Full Code Here

Examples of com.j256.ormlite.support.DatabaseResults

    assertEquals(1, dao.create(foo));
    DatabaseConnection conn = connectionSource.getReadOnlyConnection();
    CompiledStatement stmt = null;
    try {
      stmt = conn.compileStatement("select * from " + TABLE_NAME, StatementType.SELECT, noFieldTypes);
      DatabaseResults results = stmt.runQuery();
      assertTrue(results.next());
      int colNum = results.findColumn(STRING_COLUMN);
      DataType.DATE_STRING.getDataPersister().resultToJava(null, results, colNum);
    } finally {
      if (stmt != null) {
        stmt.close();
      }

View Full Code Here

0 1 2 3 4 5

TOP

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.