public boolean isNull(final int columnPosition) { return column(columnPosition).isNull(); }
public UUID getUUID(final int columnPosition) { return column(columnPosition).getUUID(); }
public Float getFloat(final String columnName) { return column(columnName).getFloat(); }
public BigDecimal getBigDecimal(final int columnPosition) { return column(columnPosition).getBigDecimal(); }
public LocalDateTime getLocalDateTime(final int columnPosition) { return column(columnPosition).getLocalDateTime(); }
public byte[] getByteArray(final int columnPosition) { return column(columnPosition).getByteArray(); }
public LocalTime getLocalTime(final int columnPosition) { return column(columnPosition).getLocalTime(); }
public Short getShort(final String columnName) { return column(columnName).getShort(); }
public OffsetTime getOffsetTime(final String columnName) { return column(columnName).getOffsetTime(); }
public Short getShort(final int columnPosition) { return column(columnPosition).getShort(); }
public StartupExchange(final SimpleQueryExchange simpleQueryExchange, final Marshallers marshallers, final Unmarshallers unmarshallers, final Exchange<Void> okPacketVoid) { this.marshallers = marshallers; this.unmarshallers = unmarshallers; this.okPacketVoid = okPacketVoid; this.getConnectionIdExchange = simpleQueryExchange.apply("SELECT CONNECTION_ID()") .map(rows -> rows.get(0).column(0).getLong()); }
@Test public void simpleQuery() throws CheckedFutureException { final Iterator<Row> rows = ds.query("SELECT * FROM " + table).get(timeout).iterator(); assertEquals(rows.next().column(0).getString(), "s"); assertFalse(rows.hasNext()); }
@Test public void simpleExecuteInsert() throws CheckedFutureException { ds.execute("INSERT INTO " + table + " VALUES ('u')").get(timeout); final Iterator<Row> rows = ds.query("SELECT * FROM " + table).get(timeout).iterator(); assertEquals(rows.next().column(0).getString(), "s"); assertEquals(rows.next().column(0).getString(), "u"); assertFalse(rows.hasNext()); }
@Test public void extendedExecuteInsertNoParam() throws CheckedFutureException { final PreparedStatement ps = PreparedStatement.create("INSERT INTO " + table + " VALUES ('u')"); assertEquals(ds.execute(ps).get(timeout).longValue(), 1L); final Iterator<Row> rows = ds.query("SELECT * FROM " + table).get(timeout).iterator(); assertEquals(rows.next().column(0).getString(), "s"); assertEquals(rows.next().column(0).getString(), "u"); assertFalse(rows.hasNext()); }
@Test public void extendedExecuteInsertWithParam() throws CheckedFutureException { final PreparedStatement ps = PreparedStatement.create("INSERT INTO " + table + " VALUES (?)").setString("u"); assertEquals(ds.execute(ps).get(timeout).longValue(), 1L); final Iterator<Row> rows = ds.query("SELECT * FROM " + table).get(timeout).iterator(); assertEquals(rows.next().column(0).getString(), "s"); assertEquals(rows.next().column(0).getString(), "u"); assertFalse(rows.hasNext()); }
@Test public void extendedQueryNoParams() throws CheckedFutureException { final PreparedStatement ps = PreparedStatement.create("SELECT * FROM " + table); final Iterator<Row> rows = ds.query(ps).get(timeout).iterator(); assertEquals(rows.next().column(0).getString(), "s"); assertFalse(rows.hasNext()); }
@Test public void simpleExecuteUpdate() throws CheckedFutureException { ds.execute("UPDATE " + table + " SET s = 'u'").get(timeout); final Iterator<Row> rows = ds.query("SELECT * FROM " + table).get(timeout).iterator(); assertEquals(rows.next().column(0).getString(), "u"); assertFalse(rows.hasNext()); }
@Test public void extendedQueryWithParams() throws CheckedFutureException { final PreparedStatement ps = PreparedStatement.create("SELECT * FROM " + table + " WHERE s = ?").setString("s"); final Iterator<Row> rows = ds.query(ps).get(timeout).iterator(); assertEquals(rows.next().column(0).getString(), "s"); assertFalse(rows.hasNext()); }
@Test public void extendedExecuteUpdateNoParam() throws CheckedFutureException { final PreparedStatement ps = PreparedStatement.create("UPDATE " + table + " SET s = 'u'"); assertEquals(ds.execute(ps).get(timeout).longValue(), 1L); final Iterator<Row> rows = ds.query("SELECT * FROM " + table).get(timeout).iterator(); assertEquals(rows.next().column(0).getString(), "u"); assertFalse(rows.hasNext()); }
@Test public void extendedExecuteUpdateWithParam() throws CheckedFutureException { final PreparedStatement ps = PreparedStatement.create("UPDATE " + table + " SET s = ?").setString("u"); assertEquals(ds.execute(ps).get(timeout).longValue(), 1L); final Iterator<Row> rows = ds.query("SELECT * FROM " + table).get(timeout).iterator(); assertEquals(rows.next().column(0).getString(), "u"); assertFalse(rows.hasNext()); }