Exemplo n.º 1
0
  @Test
  public void testFetchTable() {
    sql2o
        .createQuery(
            "create table tabletest(id integer identity primary key, value varchar(20), value2 decimal(5,1))")
        .executeUpdate();
    sql2o
        .createQuery("insert into tabletest(value,value2) values (:value, :value2)")
        .addParameter("value", "something")
        .addParameter("value2", new BigDecimal("3.4"))
        .addToBatch()
        .addParameter("value", "bla")
        .addParameter("value2", new BigDecimal("5.5"))
        .addToBatch()
        .executeBatch();

    Table table = sql2o.createQuery("select * from tabletest order by id").executeAndFetchTable();

    assertEquals(3, table.columns().size());
    assertEquals("ID", table.columns().get(0).getName());
    assertEquals("VALUE", table.columns().get(1).getName());
    assertEquals("VALUE2", table.columns().get(2).getName());

    assertEquals(2, table.rows().size());

    Row row0 = table.rows().get(0);
    Row row1 = table.rows().get(1);

    assertTrue(0 <= row0.getInteger("ID"));
    assertEquals("something", row0.getString(1));
    assertEquals(new BigDecimal("3.4"), row0.getBigDecimal("VALUE2"));

    assertTrue(1 <= row1.getInteger(0));
    assertEquals("bla", row1.getString("VALUE"));
    assertEquals(5.5D, row1.getDouble(2), 0.00001);
  }
Exemplo n.º 2
0
  @Test
  public void testRowGetObjectWithConverters() {
    String sql = "select 1 col1, '23' col2 from (values(0))";
    Table t = sql2o.createQuery(sql).executeAndFetchTable();
    Row r = t.rows().get(0);

    String col1AsString = r.getObject("col1", String.class);
    Integer col1AsInteger = r.getObject("col1", Integer.class);
    Long col1AsLong = r.getObject("col1", Long.class);

    assertThat(col1AsString, is(equalTo("1")));
    assertThat(col1AsInteger, is(equalTo(1)));
    assertThat(col1AsLong, is(equalTo(1L)));

    String col2AsString = r.getObject("col2", String.class);
    Integer col2AsInteger = r.getObject("col2", Integer.class);
    Long col2AsLong = r.getObject("col2", Long.class);

    assertThat(col2AsString, is(equalTo("23")));
    assertThat(col2AsInteger, is(equalTo(23)));
    assertThat(col2AsLong, is(equalTo(23L)));
  }