private void runQuery(final SqlQuery query) { myTransaction.query(query).run(); }
@Override public void run(@NotNull final DBSession session) { DBQueryRunner<List<Number>> qr = session.query(query).packBy(10); qr.run(); ResultSetMetaData md = qr.getSpecificService(ResultSetMetaData.class, ImplementationAccessibleService.Names.JDBC_METADATA); assertThat(md).isNotNull(); String columnName = null; try { columnName = md.getColumnName(1); } catch (SQLException e) { throw new RuntimeException(e.getMessage(), e); } assertThat(columnName).isEqualToIgnoringCase("X"); } });
@Override public void run(@NotNull final DBSession session) { for (int i = 0; i < retries; ++i) { List<String> commands = session.query(metaQuery).withParams(params).run(); try { for (String command : commands) { if (command != null && command.length() > 0) { session.command(command).run(); } } i = retries + 1; } catch (DBException e) { if (i + 1 >= retries) throw e; } } } });
@Override public void run(@NotNull final DBSession session) { session.command("create table Turbo2000 (x smallint)").run(); DBCommandRunner cr = session.command("insert into Turbo2000 values (?)"); for (short i = 1; i <= 2000; i++) cr.withParams(i).run(); DBQueryRunner<Short[]> qr = session.query("select * from Turbo2000 order by 1", columnOf(Short.class)) .packBy(100); Short[] pack = qr.run(); assertThat(pack).isNotNull() .startsWith((short) 1) .endsWith((short) 100); int packs = 0; while (pack != null) { packs++; pack = qr.nextPack(); } assertThat(packs).isEqualTo(20); // 2000 / 100 = 20 } });
@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).withParams(params).run(); } });
@Override public T run(@NotNull final DBTransaction tran) { return tran.query(query).run(); } });
@Override public void run(@NotNull final DBSession session) { List<String> commands = session.query(metaQuery).withParams(params).run(); SqlScriptBuilder sb = new SqlScriptBuilder(); for (String command : commands) if (command != null && command.length() > 0) sb.add(command); SqlScript script = sb.build(); session.script(script).run(); } });
@Override public X run(@NotNull final DBTransaction tran) { return tran.query(query).run(); } });
@Override public void run(@NotNull final DBSession session) { List<Tetra> result = session.query(query).run(); assertThat(result).isEmpty(); } });
@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); } });
@Override public void run(@NotNull final DBSession session) { final Integer v = session.query("select 1 " + TH.fromSingleRowTable(), Layouts.singleOf(Integer.class)) .run(); assertThat(v).isNotNull() .isEqualTo(1); } });