return fcall("fromJson", json);
@Test(groups = "unit") public void should_not_attempt_to_serialize_function_calls_in_collections() { BuiltStatement query = insertInto("foo").value("v", Sets.newHashSet(fcall("func", 1))); assertThat(query.getQueryString()).isEqualTo("INSERT INTO foo (v) VALUES ({func(1)});"); assertThat(query.getValues(ProtocolVersion.NEWEST_SUPPORTED, CodecRegistry.DEFAULT_INSTANCE)) .isNullOrEmpty(); }
@Test(groups = "short") public void dateHandlingTest() throws Exception { Date d = new Date(); session().execute(insertInto("dateTest").value("t", d)); String query = select().from("dateTest").where(eq(token("t"), fcall("token", d))).toString(); List<Row> rows = session().execute(query).all(); assertEquals(1, rows.size()); Row r1 = rows.get(0); assertEquals(d, r1.getTimestamp("t")); }
@Test(groups = "unit") public void rawEscapingTest() throws Exception { String query; Statement select; query = "SELECT * FROM t WHERE c='C''est la vie!';"; select = select().from("t").where(eq("c", "C'est la vie!")); assertEquals(select.toString(), query); query = "SELECT * FROM t WHERE c=C'est la vie!;"; select = select().from("t").where(eq("c", raw("C'est la vie!"))); assertEquals(select.toString(), query); query = "SELECT * FROM t WHERE c=now();"; select = select().from("t").where(eq("c", fcall("now"))); assertEquals(select.toString(), query); query = "SELECT * FROM t WHERE c='now()';"; select = select().from("t").where(eq("c", raw("'now()'"))); assertEquals(select.toString(), query); }
delete = delete().from("foo").where(gt(token("k)>0 OR token(k"), fcall("token", 42))); assertEquals(delete.toString(), query);
return fcall("fromJson", json);
return fcall("fromJson", json);
return fcall("fromJson", json);
select = select().all().from("foo").where(gt(token("k)>0 OR token(k"), fcall("token", 42))); assertEquals(select.toString(), query);
select = select().all().from("foo").where(gt(token("k"), fcall("token", 42))); assertEquals(select.toString(), query); select = select().all().from("foo2").where(gt(token("a", "b"), fcall("token", 42, 101))); assertEquals(select.toString(), query); select = select() .cast(fcall("writetime", column("country")), DataType.text()) .from("artists") .limit(2);
insertInto("foo").value("k", 1).value("v", fcall("token", "k")), insertInto("foo").value("k", 1).value("v", now()), insertInto("foo").value("k", 1).value("v", uuid()), insertInto("foo").value("k", 1).value("v", Sets.newHashSet(fcall("token", "k"))), insertInto("foo").value("k", 1).value("v", Sets.newHashSet(now())), insertInto("foo").value("k", 1).value("v", Sets.newHashSet(uuid())), insertInto("foo").values(new String[] {"k", "v"}, new Object[] {1, fcall("token", "k")}), insertInto("foo").values(new String[] {"k", "v"}, new Object[] {1, now()}), insertInto("foo").values(new String[] {"k", "v"}, new Object[] {1, uuid()}), .values( new String[] {"k", "v"}, new Object[] {1, ImmutableMap.of("foo", fcall("token", "k"))}), insertInto("foo") .values(new String[] {"k", "v"}, new Object[] {1, ImmutableMap.of("foo", now())}), .values( new String[] {"k", "v"}, new Object[] {1, ImmutableMap.of(fcall("token", "k"), "foo")}), insertInto("foo") .values(new String[] {"k", "v"}, new Object[] {1, ImmutableMap.of(now(), "foo")}), insertInto("foo") .values(new String[] {"k", "v"}, new Object[] {1, ImmutableMap.of(uuid(), "foo")}), update("foo").with(set("v", fcall("token", "k"))).where(eq("k", 1)), update("foo").with(set("v", now())).where(eq("k", 1)), update("foo").with(set("v", uuid())).where(eq("k", 1)), update("foo").with(set("v", Lists.newArrayList(fcall("token", "k")))).where(eq("k", 1)), update("foo").with(set("v", Lists.newArrayList(now()))).where(eq("k", 1)), update("foo").with(set("v", Lists.newArrayList(uuid()))).where(eq("k", 1)),
private void selectNext() { if (dates.hasNext()) { String date = dates.next(); Statement statement = QueryBuilder.select(fields).from(TABLE_NAME) .where(eq("analyse_id", UUID.fromString(analyseId))) .and(eq("jvm_id", jvmId)) .and(eq("date", date)) .and(gte("written_at", QueryBuilder.fcall("minTimeuuid", range.from().getMillis()))) .and(lte("written_at", QueryBuilder.fcall("maxTimeuuid", range.to().getMillis()))).setFetchSize(fetchSize); LOG.debug("Query: {}", statement); resultIterator = connector.session().execute(statement).iterator(); } }
protected ResultSet events0(String analyseId, String jvmId, Range range, String[] fields) { return connector.session().execute(QueryBuilder.select(fields).from(TABLE_NAME) .where(eq("analyse_id", UUID.fromString(analyseId))) .and(eq("jvm_id", jvmId)) .and(gte("written_at", QueryBuilder.fcall("minTimeuuid", range.from().getMillis()))) .and(lte("written_at", QueryBuilder.fcall("maxTimeuuid", range.to().getMillis()))).setFetchSize(fetchSize)); }
@Test(groups = "unit") public void should_not_attempt_to_serialize_function_calls_in_collections() { BuiltStatement query = insertInto("foo").value("v", Sets.newHashSet(fcall("func", 1))); assertThat(query.getQueryString()).isEqualTo("INSERT INTO foo (v) VALUES ({func(1)});"); assertThat(query.getValues(ProtocolVersion.NEWEST_SUPPORTED, CodecRegistry.DEFAULT_INSTANCE)) .isNullOrEmpty(); }
@Test(groups = "short") public void dateHandlingTest() throws Exception { Date d = new Date(); session().execute(insertInto("dateTest").value("t", d)); String query = select().from("dateTest").where(eq(token("t"), fcall("token", d))).toString(); List<Row> rows = session().execute(query).all(); assertEquals(1, rows.size()); Row r1 = rows.get(0); assertEquals(d, r1.getTimestamp("t")); }
@Test(groups = "unit") public void rawEscapingTest() throws Exception { String query; Statement select; query = "SELECT * FROM t WHERE c='C''est la vie!';"; select = select().from("t").where(eq("c", "C'est la vie!")); assertEquals(select.toString(), query); query = "SELECT * FROM t WHERE c=C'est la vie!;"; select = select().from("t").where(eq("c", raw("C'est la vie!"))); assertEquals(select.toString(), query); query = "SELECT * FROM t WHERE c=now();"; select = select().from("t").where(eq("c", fcall("now"))); assertEquals(select.toString(), query); query = "SELECT * FROM t WHERE c='now()';"; select = select().from("t").where(eq("c", raw("'now()'"))); assertEquals(select.toString(), query); }
delete = delete().from("foo").where(gt(token("k)>0 OR token(k"), fcall("token", 42))); assertEquals(delete.toString(), query);
select = select().all().from("foo").where(gt(token("k)>0 OR token(k"), fcall("token", 42))); assertEquals(select.toString(), query);
insertInto("foo").value("k", 1).value("v", fcall("token", "k")), insertInto("foo").value("k", 1).value("v", now()), insertInto("foo").value("k", 1).value("v", uuid()), insertInto("foo").value("k", 1).value("v", Sets.newHashSet(fcall("token", "k"))), insertInto("foo").value("k", 1).value("v", Sets.newHashSet(now())), insertInto("foo").value("k", 1).value("v", Sets.newHashSet(uuid())), insertInto("foo").values(new String[] {"k", "v"}, new Object[] {1, fcall("token", "k")}), insertInto("foo").values(new String[] {"k", "v"}, new Object[] {1, now()}), insertInto("foo").values(new String[] {"k", "v"}, new Object[] {1, uuid()}), .values( new String[] {"k", "v"}, new Object[] {1, ImmutableMap.of("foo", fcall("token", "k"))}), insertInto("foo") .values(new String[] {"k", "v"}, new Object[] {1, ImmutableMap.of("foo", now())}), .values( new String[] {"k", "v"}, new Object[] {1, ImmutableMap.of(fcall("token", "k"), "foo")}), insertInto("foo") .values(new String[] {"k", "v"}, new Object[] {1, ImmutableMap.of(now(), "foo")}), insertInto("foo") .values(new String[] {"k", "v"}, new Object[] {1, ImmutableMap.of(uuid(), "foo")}), update("foo").with(set("v", fcall("token", "k"))).where(eq("k", 1)), update("foo").with(set("v", now())).where(eq("k", 1)), update("foo").with(set("v", uuid())).where(eq("k", 1)), update("foo").with(set("v", Lists.newArrayList(fcall("token", "k")))).where(eq("k", 1)), update("foo").with(set("v", Lists.newArrayList(now()))).where(eq("k", 1)), update("foo").with(set("v", Lists.newArrayList(uuid()))).where(eq("k", 1)),