select = select().writeTime("a").ttl("a").from("foo").allowFiltering(); assertEquals(select.toString(), query); .distinct() .column("longName") .as("a") .ttl("longName") .as("ttla") .from("foo") .limit(bindMarker("limit")); .distinct() .column("longName") .as("a") .ttl("longName") .as("ttla") .from("foo") .where(in("k")) select = select().fcall("intToBlob", column("b")).from("foo"); assertEquals(select.toString(), query); select() .cast(fcall("writetime", column("country")), DataType.text()) .from("artists") .limit(2); assertEquals(select.toString(), query); select = select().fcall("avg", cast(column("v"), DataType.cfloat())).from("e");
/** @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;"); }
@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 }
select() .column("a") .column("b") .as("clustering1") .max("c") .from(table) .where(eq("a", 1)) .groupBy("a", "clustering1")); select() .column("a") .column("b") .max("c") .from(table) .where(eq("a", 1)) .groupBy("a", "b", "z")); session().execute(select().column("a").column("b").max("d").from(table).groupBy("a")); fail("Expecting IQE"); } catch (InvalidQueryException e) {
select = select().writeTime("a").ttl("a").from("foo").allowFiltering(); assertEquals(select.toString(), query); .distinct() .column("longName") .as("a") .ttl("longName") .as("ttla") .from("foo") .limit(bindMarker("limit")); .distinct() .column("longName") .as("a") .ttl("longName") .as("ttla") .from("foo") .where(in("k")) select = select().fcall("intToBlob", column("b")).from("foo"); assertEquals(select.toString(), query); select() .cast(fcall("writetime", column("country")), DataType.text()) .from("artists") .limit(2); assertEquals(select.toString(), query); select = select().fcall("avg", cast(column("v"), DataType.cfloat())).from("e");
.column(VALUE_COLUMN_NAME) .fcall(WRITETIME_FUNCTION_NAME, column(VALUE_COLUMN_NAME)).as(WRITETIME_COLUMN_NAME) .fcall(TTL_FUNCTION_NAME, column(VALUE_COLUMN_NAME)).as(TTL_COLUMN_NAME) .from(this.storeManager.getKeyspaceName(), this.tableName) .where(eq(KEY_COLUMN_NAME, bindMarker(KEY_BINDING))) .column(COLUMN_COLUMN_NAME) .column(VALUE_COLUMN_NAME) .fcall(WRITETIME_FUNCTION_NAME, column(VALUE_COLUMN_NAME)).as(WRITETIME_COLUMN_NAME) .fcall(TTL_FUNCTION_NAME, column(VALUE_COLUMN_NAME)).as(TTL_COLUMN_NAME) .from(this.storeManager.getKeyspaceName(), this.tableName) .allowFiltering() .column(COLUMN_COLUMN_NAME) .column(VALUE_COLUMN_NAME) .fcall(WRITETIME_FUNCTION_NAME, column(VALUE_COLUMN_NAME)).as(WRITETIME_COLUMN_NAME) .fcall(TTL_FUNCTION_NAME, column(VALUE_COLUMN_NAME)).as(TTL_COLUMN_NAME) .from(this.storeManager.getKeyspaceName(), this.tableName) .allowFiltering()
select() .column("name") .writeTime("name") .as("wname") .column("age") .writeTime("age") .as("wage") .column(quote("~~vertex_exists")) .writeTime(quote("~~vertex_exists")) .as("wv") .from(cluster().getConfiguration().getGraphOptions().getGraphName(), "person_p") .where(eq("community_id", id.get("community_id").asLong()));
select = select().fcall("* FROM bar; --", column("b")).from("foo"); assertEquals(select.toString(), query); select = select().writeTime("a) FROM bar; --").ttl("a").from("foo").allowFiltering(); assertEquals(select.toString(), query); select = select().writeTime("a").ttl("a) FROM bar; --").from("foo").allowFiltering(); assertEquals(select.toString(), query);
Select select = QueryBuilder.select().max(VERSION).from(tableName); select.where(QueryBuilder.eq(ENTITY_ID, entityEvent.getEventKey().getEntityId())); ResultSet execute = cassandraSession.execute(select);
SelectorIdentifier selIdent = (SelectorIdentifier) selectorMeta; if (selSelector.isAliasInc()) { result = result.column(selIdent.getField()).as(selSelector.getAlias()); } else { result = result.column(selIdent.getField());
select() .fcall("avg", cast(column("i"), DataType.cfloat())) .as("iavg") .from(TABLE2) .where(eq("k", "cast_t")));
@Override String makePreparedQueryString(TableMetadata table, EntityMapper<?> mapper, MappingManager manager, Set<AliasedMappedProperty> columns, Collection<Mapper.Option> options) { Select.Selection selection = select(); for (AliasedMappedProperty col : mapper.allColumns) { Select.SelectionOrAlias column = col.mappedProperty.isComputed() ? selection.raw(col.mappedProperty.getMappedName()) : selection.column(col.mappedProperty.getMappedName()); if (col.alias == null) { selection = column; } else { selection = column.as(col.alias); } } Select select; if (table == null) { select = selection.from(mapper.keyspace, mapper.table); } else { select = selection.from(table); } Select.Where where = select.where(); for (int i = 0; i < mapper.primaryKeySize(); i++) where.and(eq(mapper.getPrimaryKeyColumn(i).mappedProperty.getMappedName(), bindMarker())); for (Mapper.Option option : options) { option.validate(QueryType.GET, manager); option.modifyQueryString(select); } return select.toString(); } },
private Long nextValueSelect(IdSourceKeyMetadata metadata, String sequenceName) { Statement select = QueryBuilder.select().column( quote( metadata.getValueColumnName() ) ) .from( quote( metadata.getName() ) ) .where( eq( metadata.getKeyColumnName(), QueryBuilder.bindMarker() ) ); PreparedStatement preparedStatement = provider.getSession().prepare( select.toString() ); BoundStatement boundStatement = preparedStatement.bind( sequenceName ); ResultSet resultSet; try { resultSet = provider.getSession().execute( boundStatement ); } catch (DriverException e) { throw e; } if ( resultSet.isExhausted() ) { return null; } else { return resultSet.one().getLong( 0 ); } }
@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 }
/** * * SOME BASIC UTILITY METHODS USED BY ALL THE ROW SLICE QUERY GENERATORS */ protected Select selectAllColumnsFromKeyspaceAndCF() { Select.Selection select = QueryBuilder.select(); for (int i=0; i<allPrimayKeyCols.length; i++) { select.column(allPrimayKeyCols[i]); } for (ColumnDefinition colDef : regularCols) { String colName = colDef.getName(); select.column(colName).ttl(colName).writeTime(colName); } return select.from(keyspace, cfDef.getName()); }
/** * * SOME BASIC UTILITY METHODS USED BY ALL THE ROW SLICE QUERY GENERATORS */ protected Select selectAllColumnsFromKeyspaceAndCF() { Select.Selection select = QueryBuilder.select(); for (int i=0; i<allPrimayKeyCols.length; i++) { select.column(allPrimayKeyCols[i]); } for (ColumnDefinition colDef : regularCols) { String colName = colDef.getName(); select.column(colName).ttl(colName).writeTime(colName); } return select.from(keyspace, cfDef.getName()); }
private Statement createQueryToGetOrganizationMembers(String organizationId) { UUID orgUuid = UUID.fromString(organizationId); return queryBuilder .select() .column(USER_ID).as(Users.USER_ID) .column(USER_FIRST_NAME).as(Users.FIRST_NAME) .column(USER_MIDDLE_NAME).as(Users.MIDDLE_NAME) .column(USER_LAST_NAME).as(Users.LAST_NAME) .column(USER_ROLES).as(Users.ROLES) .column(USER_EMAIL).as(Users.EMAIL) .from(Organizations.TABLE_NAME_MEMBERS) .where(eq(ORG_ID, orgUuid)); }