private void runQuery(final SqlQuery query) { myTransaction.query(query).run(); }
@Override public int countTableRows(@NotNull final DBTransaction transaction, @NotNull final String tableName) { final String queryText = "select count(*) from " + tableName; try { return transaction.query(queryText, singleOf(Integer.class)).run(); } catch (NoTableOrViewException ntv) { return Integer.MIN_VALUE; } }
@Override public T run(@NotNull final DBTransaction tran) { return tran.query(query).run(); } });
@Override public X run(@NotNull final DBTransaction tran) { return tran.query(query).run(); } });
@Override public T run(@NotNull final DBTransaction tran) { return tran.query(query).withParams(params).run(); } });
@Override public void run(@NotNull final DBTransaction tran) { IntAndString bs = tran.query(query).run(); assertThat(bs).isNotNull(); assertThat(bs.the_int_value).isEqualTo(44); assertThat(bs.the_string_value).isEqualTo("million"); } });
@Override public void run(@NotNull final DBTransaction tran) { tran.query("select * from unexistent_table", Layouts.existence()).run(); } });
@Override public void run(@NotNull final DBTransaction tran) { List<IntAndString> bs = tran.query(query).run(); assertThat(bs).isNotNull() .hasSize(2); assertThat(bs.get(0).the_int_value).isEqualTo(11); assertThat(bs.get(0).the_string_value).isEqualTo("one"); assertThat(bs.get(1).the_int_value).isEqualTo(22); assertThat(bs.get(1).the_string_value).isEqualTo("two"); } });
@Override public void run(@NotNull final DBTransaction tran) { char c = tran.query("select 'M'", singleOf(Character.class)).run(); assertThat(c).isEqualTo('M'); } });
@Override public void run(@NotNull final DBTransaction tran) { Character c = tran.query("select 'MN'", singleOf(Character.class)).run(); assertThat(c).isEqualTo('M'); } });
@Override public List<Integer> run(@NotNull final DBTransaction tran) { return tran.query("select X from X1000 order by 1", listOf(oneOf(Integer.class))).run(); } });
@Override public List<Integer> run(@NotNull final DBTransaction tran) { return tran.query("select X from X1000000 order by 1", listOf(oneOf(Integer.class))).run(); } });
@Override public void run(@NotNull final DBTransaction tran) { IntAndString[] bs = tran.query(query).run(); assertThat(bs).isNotNull() .hasSize(2); assertThat(bs[0].the_int_value).isEqualTo(11); assertThat(bs[0].the_string_value).isEqualTo("one"); assertThat(bs[1].the_int_value).isEqualTo(22); assertThat(bs[1].the_string_value).isEqualTo("two"); } });
@Override public void run(@NotNull final DBTransaction tran) { final Integer v = tran.query("select 1 " + TH.fromSingleRowTable(), Layouts.singleOf(Integer.class)) .run(); assertThat(v).isNotNull() .isEqualTo(1); } });