@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 }
/** * Generate ... * FROM ... */ public final EntityWithSASIIndices_SelectIndex.F_J allColumnsAsJSON_FromBaseTable() { final Select.Where where = select.json().all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where(); return new EntityWithSASIIndices_SelectIndex.F_J(where, new CassandraOptions()); }
/** * Generate ... * FROM ... */ public final EntityForJSONCall_Select.F_J allColumnsAsJSON_FromBaseTable() { final Select.Where where = select.json().all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where(); return new EntityForJSONCall_Select.F_J(where, new CassandraOptions()); }
@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 }
/** * Generate ... * FROM ... using the given SchemaNameProvider */ public final EntityForJSONCall_Select.F_J allColumnsAsJSON_From(final SchemaNameProvider schemaNameProvider) { final String currentKeyspace = lookupKeyspace(schemaNameProvider, meta.entityClass); final String currentTable = lookupTable(schemaNameProvider, meta.entityClass); final Select.Where where = select.json().all().from(currentKeyspace, currentTable).where(); return new EntityForJSONCall_Select.F_J(where, CassandraOptions.withSchemaNameProvider(schemaNameProvider)); }
/** * Generate ... * FROM ... using the given SchemaNameProvider */ public final MultiClusteringEntity_Select.F_J allColumnsAsJSON_From(final SchemaNameProvider schemaNameProvider) { final String currentKeyspace = lookupKeyspace(schemaNameProvider, meta.entityClass); final String currentTable = lookupTable(schemaNameProvider, meta.entityClass); final Select.Where where = select.json().all().from(currentKeyspace, currentTable).where(); return new MultiClusteringEntity_Select.F_J(where, CassandraOptions.withSchemaNameProvider(schemaNameProvider)); }
/** * Generate ... * FROM ... using the given SchemaNameProvider */ public final EntityWithSASIIndices_SelectIndex.F_J allColumnsAsJSON_From(final SchemaNameProvider schemaNameProvider) { final String currentKeyspace = lookupKeyspace(schemaNameProvider, meta.entityClass); final String currentTable = lookupTable(schemaNameProvider, meta.entityClass); final Select.Where where = select.json().all().from(currentKeyspace, currentTable).where(); return new EntityWithSASIIndices_SelectIndex.F_J(where, CassandraOptions.withSchemaNameProvider(schemaNameProvider)); }
/** * Generate ... * FROM ... using the given SchemaNameProvider */ public final EntityForCastFunctionCall_Select.F_J allColumnsAsJSON_From(final SchemaNameProvider schemaNameProvider) { final String currentKeyspace = lookupKeyspace(schemaNameProvider, meta.entityClass); final String currentTable = lookupTable(schemaNameProvider, meta.entityClass); final Select.Where where = select.json().all().from(currentKeyspace, currentTable).where(); return new EntityForCastFunctionCall_Select.F_J(where, CassandraOptions.withSchemaNameProvider(schemaNameProvider)); }
/** * Generate ... * FROM ... */ public final MultiClusteringEntity_Select.F_J allColumnsAsJSON_FromBaseTable() { final Select.Where where = select.json().all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where(); return new MultiClusteringEntity_Select.F_J(where, new CassandraOptions()); }
/** * Generate ... * FROM ... */ public final EntityForCastFunctionCall_Select.F_J allColumnsAsJSON_FromBaseTable() { final Select.Where where = select.json().all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where(); return new EntityForCastFunctionCall_Select.F_J(where, new CassandraOptions()); }
/** * Generate ... * FROM ... */ public final EntityWithNoKeyspaceUDT_Select.F_J allColumnsAsJSON_FromBaseTable() { final Select.Where where = select.json().all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where(); return new EntityWithNoKeyspaceUDT_Select.F_J(where, new CassandraOptions()); }
/** * Generate ... * FROM ... */ public final EntityWithSASIIndices_Select.F_J allColumnsAsJSON_FromBaseTable() { final Select.Where where = select.json().all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where(); return new EntityWithSASIIndices_Select.F_J(where, new CassandraOptions()); }
/** * Generate ... * FROM ... using the given SchemaNameProvider */ public final EntityWithNoKeyspaceUDT_Select.F_J allColumnsAsJSON_From(final SchemaNameProvider schemaNameProvider) { final String currentKeyspace = lookupKeyspace(schemaNameProvider, meta.entityClass); final String currentTable = lookupTable(schemaNameProvider, meta.entityClass); final Select.Where where = select.json().all().from(currentKeyspace, currentTable).where(); return new EntityWithNoKeyspaceUDT_Select.F_J(where, CassandraOptions.withSchemaNameProvider(schemaNameProvider)); }
/** * Generate ... * FROM ... using the given SchemaNameProvider */ public final EntityWithSASIIndices_Select.F_J allColumnsAsJSON_From(final SchemaNameProvider schemaNameProvider) { final String currentKeyspace = lookupKeyspace(schemaNameProvider, meta.entityClass); final String currentTable = lookupTable(schemaNameProvider, meta.entityClass); final Select.Where where = select.json().all().from(currentKeyspace, currentTable).where(); return new EntityWithSASIIndices_Select.F_J(where, CassandraOptions.withSchemaNameProvider(schemaNameProvider)); }