@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")); }
.where(QueryBuilder.gt(token, subrange.getStart().getValue())) .and(QueryBuilder.lte(token, subrange.getEnd().getValue())) .toString();
String query = builder.toString(); LOG.debug("Cassandra generated read query : {}", query); queries.add(query); query = builder.toString(); LOG.debug("Cassandra generated read query : {}", query); queries.add(query); builder = builder.and(QueryBuilder.gte("token(" + partitionKey + ")", range.getStart())); builder = builder.and(QueryBuilder.lt("token(" + partitionKey + ")", range.getEnd())); String query = builder.toString(); LOG.debug("Cassandra generated read query : {}", query); queries.add(query);
whereStmt = sel.where(); LOG.trace("Executing: " + whereStmt.toString());
@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")); }
private static String readQuery(TableMetadata tableMetadata) { Select.Selection select = QueryBuilder.select(); List<ColumnMetadata> columns = tableMetadata.getColumns(); for(ColumnMetadata column : columns) { select.column(column.getName()); } Select.Where where = select.from(tableMetadata).where(); columns = tableMetadata.getPrimaryKey(); for(ColumnMetadata column : columns) { where.and(QueryBuilder.eq(column.getName(), QueryBuilder.bindMarker())); } return where.toString(); }