@Test public void queryTypeTimestampWithTimezoneTest(TestContext context) throws Exception { Async async = context.async(); client.getConnection(connAr -> { ensureSuccess(context, connAr); conn = connAr.result(); conn.execute("DROP TABLE IF EXISTS test_table", onSuccess(context, dropped -> { conn.execute("CREATE TABLE IF NOT EXISTS test_table (ts timestamp with time zone)", onSuccess(context, created -> { conn.execute("INSERT INTO test_table (ts) VALUES (now())", onSuccess(context, inserted -> { conn.query("SELECT * FROM test_table;", onSuccess(context, timestampSelect -> { context.assertNotNull(timestampSelect); context.assertNotNull(timestampSelect.getResults()); context.assertTrue(timestampSelect.getResults().get(0).getString(0).matches("\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}\\.\\d{3}(Z|[+-]\\d{2}:\\d{2})")); async.complete(); })); })); })); })); }); }
@Test public void queryTypeTimestampWithoutTimezoneTest(TestContext context) throws Exception { Async async = context.async(); client.getConnection(connAr -> { ensureSuccess(context, connAr); conn = connAr.result(); conn.execute("DROP TABLE IF EXISTS test_table", onSuccess(context, dropped -> { conn.execute("CREATE TABLE IF NOT EXISTS test_table (ts timestamp without time zone)", onSuccess(context, created -> { conn.execute("INSERT INTO test_table (ts) VALUES (now())", onSuccess(context, inserted -> { conn.query("SELECT * FROM test_table;", onSuccess(context, timestampSelect -> { context.assertNotNull(timestampSelect); context.assertNotNull(timestampSelect.getResults()); context.assertTrue(timestampSelect.getResults().get(0).getString(0).matches("\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}\\.\\d{3}")); async.complete(); })); })); })); })); }); }
@Test public void queryTypeTimestampWithTimezoneTest(TestContext context) throws Exception { Async async = context.async(); client.getConnection(connAr -> { ensureSuccess(context, connAr); conn = connAr.result(); conn.execute("DROP TABLE IF EXISTS test_table", onSuccess(context, dropped -> { conn.execute("CREATE TABLE IF NOT EXISTS test_table (ts timestamp with time zone)", onSuccess(context, created -> { conn.execute("INSERT INTO test_table (ts) VALUES (now())", onSuccess(context, inserted -> { conn.query("SELECT * FROM test_table;", onSuccess(context, timestampSelect -> { context.assertNotNull(timestampSelect); context.assertNotNull(timestampSelect.getResults()); context.assertTrue(timestampSelect.getResults().get(0).getString(0).matches("\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}\\.\\d{3}(Z|[+-]\\d{2}:\\d{2})")); async.complete(); })); })); })); })); }); }
@Test public void queryTypeTimestampWithoutTimezoneTest(TestContext context) throws Exception { Async async = context.async(); client.getConnection(connAr -> { ensureSuccess(context, connAr); conn = connAr.result(); conn.execute("DROP TABLE IF EXISTS test_table", onSuccess(context, dropped -> { conn.execute("CREATE TABLE IF NOT EXISTS test_table (ts timestamp without time zone)", onSuccess(context, created -> { conn.execute("INSERT INTO test_table (ts) VALUES (now())", onSuccess(context, inserted -> { conn.query("SELECT * FROM test_table;", onSuccess(context, timestampSelect -> { context.assertNotNull(timestampSelect); context.assertNotNull(timestampSelect.getResults()); context.assertTrue(timestampSelect.getResults().get(0).getString(0).matches("\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}\\.\\d{3}")); async.complete(); })); })); })); })); }); }
@Test public void queryTypeTimestampWithTimezoneTest(TestContext context) throws Exception { Async async = context.async(); client.getConnection(connAr -> { ensureSuccess(context, connAr); conn = connAr.result(); conn.execute("DROP TABLE IF EXISTS test_table", onSuccess(context, dropped -> { conn.execute("CREATE TABLE IF NOT EXISTS test_table (ts timestamp with time zone)", onSuccess(context, created -> { conn.execute("INSERT INTO test_table (ts) VALUES (now())", onSuccess(context, inserted -> { conn.query("SELECT * FROM test_table;", onSuccess(context, timestampSelect -> { context.assertNotNull(timestampSelect); context.assertNotNull(timestampSelect.getResults()); context.assertTrue(timestampSelect.getResults().get(0).getString(0).matches("\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}\\.\\d{3}(Z|[+-]\\d{2}:\\d{2})")); async.complete(); })); })); })); })); }); }
@Test public void queryTypeTimestampWithoutTimezoneTest(TestContext context) throws Exception { Async async = context.async(); client.getConnection(connAr -> { ensureSuccess(context, connAr); conn = connAr.result(); conn.execute("DROP TABLE IF EXISTS test_table", onSuccess(context, dropped -> { conn.execute("CREATE TABLE IF NOT EXISTS test_table (ts timestamp without time zone)", onSuccess(context, created -> { conn.execute("INSERT INTO test_table (ts) VALUES (now())", onSuccess(context, inserted -> { conn.query("SELECT * FROM test_table;", onSuccess(context, timestampSelect -> { context.assertNotNull(timestampSelect); context.assertNotNull(timestampSelect.getResults()); context.assertTrue(timestampSelect.getResults().get(0).getString(0).matches("\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}\\.\\d{3}")); async.complete(); })); })); })); })); }); }
@Test public void queryArrayTypeTest(TestContext context) throws Exception { Async async = context.async(); client.getConnection(connAr -> { ensureSuccess(context, connAr); conn = connAr.result(); conn.execute("DROP TABLE IF EXISTS test_table", onSuccess(context, dropped -> { conn.execute("CREATE TABLE IF NOT EXISTS test_table (arr_int integer[], arr_str text[][])", onSuccess(context, created -> { conn.execute("INSERT INTO test_table (arr_int,arr_str) VALUES ('{10000, 10000, 10000, 10000}', '{{\"meeting\", \"lunch\"}, {\"training\", \"presentation\"}}')", onSuccess(context, inserted -> { conn.query("SELECT * FROM test_table;", onSuccess(context, arraySelect -> { context.assertNotNull(arraySelect); context.assertNotNull(arraySelect.getResults()); List<JsonArray> results = arraySelect.getResults(); JsonArray resultRow = results.get(0); context.assertEquals(resultRow.getJsonArray(0), new JsonArray("[10000,10000,10000,10000]")); context.assertEquals(resultRow.getJsonArray(1), new JsonArray("[[\"meeting\",\"lunch\"],[\"training\",\"presentation\"]]")); async.complete(); })); })); })); })); }); }
@Test public void queryArrayTypeTest(TestContext context) throws Exception { Async async = context.async(); client.getConnection(connAr -> { ensureSuccess(context, connAr); conn = connAr.result(); conn.execute("DROP TABLE IF EXISTS test_table", onSuccess(context, dropped -> { conn.execute("CREATE TABLE IF NOT EXISTS test_table (arr_int integer[], arr_str text[][])", onSuccess(context, created -> { conn.execute("INSERT INTO test_table (arr_int,arr_str) VALUES ('{10000, 10000, 10000, 10000}', '{{\"meeting\", \"lunch\"}, {\"training\", \"presentation\"}}')", onSuccess(context, inserted -> { conn.query("SELECT * FROM test_table;", onSuccess(context, arraySelect -> { context.assertNotNull(arraySelect); context.assertNotNull(arraySelect.getResults()); List<JsonArray> results = arraySelect.getResults(); JsonArray resultRow = results.get(0); context.assertEquals(resultRow.getJsonArray(0), new JsonArray("[10000,10000,10000,10000]")); context.assertEquals(resultRow.getJsonArray(1), new JsonArray("[[\"meeting\",\"lunch\"],[\"training\",\"presentation\"]]")); async.complete(); })); })); })); })); }); }
@Test public void queryArrayTypeTest(TestContext context) throws Exception { Async async = context.async(); client.getConnection(connAr -> { ensureSuccess(context, connAr); conn = connAr.result(); conn.execute("DROP TABLE IF EXISTS test_table", onSuccess(context, dropped -> { conn.execute("CREATE TABLE IF NOT EXISTS test_table (arr_int integer[], arr_str text[][])", onSuccess(context, created -> { conn.execute("INSERT INTO test_table (arr_int,arr_str) VALUES ('{10000, 10000, 10000, 10000}', '{{\"meeting\", \"lunch\"}, {\"training\", \"presentation\"}}')", onSuccess(context, inserted -> { conn.query("SELECT * FROM test_table;", onSuccess(context, arraySelect -> { context.assertNotNull(arraySelect); context.assertNotNull(arraySelect.getResults()); List<JsonArray> results = arraySelect.getResults(); JsonArray resultRow = results.get(0); context.assertEquals(resultRow.getJsonArray(0), new JsonArray("[10000,10000,10000,10000]")); context.assertEquals(resultRow.getJsonArray(1), new JsonArray("[[\"meeting\",\"lunch\"],[\"training\",\"presentation\"]]")); async.complete(); })); })); })); })); }); }