@Override public List<UUID> getTokensForPrincipal(ByteBuffer principalKeyBuffer){ Preconditions.checkNotNull(principalKeyBuffer, "principal key bytebuffer cannot be null"); Clause inPrincipal = QueryBuilder.eq("key", principalKeyBuffer); Statement statement = QueryBuilder .select() .column("column1") .from(PRINCIPAL_TOKENS_TABLE) .where(inPrincipal); final List<Row> rows = session.execute(statement).all(); final List<UUID> tokenUUIDs = new ArrayList<>(rows.size()); rows.forEach(row -> tokenUUIDs.add(row.getUUID("column1"))); logger.trace("getTokensForPrincipal, token UUIDs: {}", tokenUUIDs); return tokenUUIDs; }
selectBuilder = QueryBuilder.select(); for (String col : fields) { ((Select.Selection) selectBuilder).column(col);
selectBuilder = QueryBuilder.select(); for (String col : fields) { ((Select.Selection) selectBuilder).column(col);
/** * Generate a SELECT ... <strong>id</strong> ... */ public final EntityWithComplexTuple_Select.Cols id() { selection.column("id"); return this; }
/** * Generate a SELECT ... <strong>"partitionKey"</strong> ... */ public final EntityWithCaseSensitivePK_Select.Cols id() { select.column("\"partitionKey\""); return new EntityWithCaseSensitivePK_Select.Cols(select); }
/** * Generate a SELECT ... <strong>child_value</strong> ... */ public final EntityAsChild_Select.Cols anotherValue() { select.column("child_value"); return new EntityAsChild_Select.Cols(select); }
/** * Generate a SELECT ... <strong>value</strong> ... */ public final EntityWithByteBufferType_Select.Cols value() { selection.column("value"); return this; }
/** * Generate a SELECT ... <strong>value</strong> ... */ public final EntityWithCustomConstructorAndDeclaredFields_Select.ColsTM value() { selection.column("value"); return this; }
/** * Generate a SELECT ... <strong>name</strong> ... */ public final EntityWithCustomConstructorAndDeclaredFields_Select.Cols name() { select.column("name"); return new EntityWithCustomConstructorAndDeclaredFields_Select.Cols(select); }
/** * Generate a SELECT ... <strong>id</strong> ... */ public final EntityWithCounterColumn_Select.ColsTM id() { selection.column("id"); return this; }
/** * Generate a SELECT ... <strong>count</strong> ... */ public final EntityWithCounterColumn_Select.Cols count() { select.column("count"); return new EntityWithCounterColumn_Select.Cols(select); }
/** * Generate a SELECT ... <strong>layer</strong> ... */ public final EntityLayer1_Select.Cols layer() { selection.column("layer"); return this; }
public static Selection select(List<CassandraColumnHandle> columns) { Selection selection = QueryBuilder.select(); for (CassandraColumnHandle column : columns) { selection.column(validColumnName(column.getName())); } return selection; }
/** * Returns a select statement builder for a {@link TableDDL} with the columns ordered in the order set by * {@link #ROW_KEY_RESULT_SET_COLUMN}, {@link #CHANGE_ID_RESULT_SET_COLUMN}, and {@link #VALUE_RESULT_SET_COLUMN}. */ private Select selectFrom(TableDDL tableDDL) { return QueryBuilder.select() .column(tableDDL.getRowKeyColumnName()) // ROW_KEY_RESULT_SET_COLUMN .column(tableDDL.getChangeIdColumnName()) // CHANGE_ID_RESULT_SET_COLUMN .column(tableDDL.getValueColumnName()) // VALUE_RESULT_SET_COLUMN .from(tableDDL.getTableMetadata()); }
select() .distinct() .column("longName") .as("a") .ttl("longName") select() .distinct() .column("longName") .as("a") .ttl("longName") select().column("a").all().from("foo"); fail("Expected an IllegalStateException"); } catch (IllegalStateException e) { select().column("a").countAll().from("foo"); fail("Expected an IllegalStateException"); } catch (IllegalStateException e) {
.cast("f", DataType.cint()) .as("fint") .column("i") .from(TABLE2) .where(eq("k", "cast_t")));
@Test(groups = "unit") public void should_handle_select_json() throws Exception { assertThat(select().json().from("users").toString()).isEqualTo("SELECT JSON * FROM users;"); assertThat(select("id", "age").json().from("users").toString()) .isEqualTo("SELECT JSON id,age FROM users;"); assertThat( select() .json() .column("id") .writeTime("age") .ttl("state") .as("ttl") .from("users") .toString()) .isEqualTo("SELECT JSON id,writetime(age),ttl(state) AS ttl FROM users;"); assertThat(select().distinct().json().column("id").from("users").toString()) .isEqualTo( "SELECT JSON DISTINCT id FROM users;"); // note that the correct syntax is JSON DISTINCT }
/** @jira_ticket JAVA-1312 */ @Test(groups = "unit") public void should_not_append_last_column_twice() throws Exception { Select.SelectionOrAlias select = select().column("a").column("b"); Select fromUsers1 = select.from("users"); Select fromUsers2 = select.from("users"); assertThat(fromUsers1.getQueryString()) .isEqualTo(fromUsers2.getQueryString()) .isEqualTo("SELECT a,b FROM users;"); }
public static Selection select(List<CassandraColumnHandle> columns) { Selection selection = QueryBuilder.select(); for (CassandraColumnHandle column : columns) { selection.column(validColumnName(column.getName())); } return selection; }