@Test(groups = "short") public void remainingDeleteTests() throws Exception { Statement query; TableMetadata table = cluster().getMetadata().getKeyspace(keyspace).getTable(TABLE_TEXT); assertNotNull(table); String expected = String.format("DELETE k FROM %s.test_text;", keyspace); query = delete("k").from(table); assertEquals(query.toString(), expected); try { session().execute(query); fail(); } catch (SyntaxError e) { // Missing WHERE clause } }
delete = delete("a", "b", "c").from("foo").using(timestamp(0)).where(eq("k", 1)); assertEquals(delete.toString(), query); delete = delete("a", "b", "c").from("foo"); assertEquals(delete.toString(), query); delete = delete().all().from("foo").using(timestamp(1240003134L)).where(eq("k", "value")); assertEquals(delete.toString(), query); delete = delete().from("foo").using(timestamp(1240003134L)).where(eq("k", "value")); delete = delete("a", "b", "c") .from("foo", "bar") .where() .and(eq("k", 1)) delete().column("a").all().from("foo"); fail("Expected an IllegalStateException"); } catch (IllegalStateException e) {
@Override public void removeData(String sessionId) { Delete.Where delete = QueryBuilder .delete() .all() .from(settings.getKeyspaceName(), settings.getTableName()) .where(QueryBuilder.eq(COLUMN_SESSION_ID, sessionId)); session.execute(delete); LOGGER.debug("Deleted data for session '{}'", sessionId); }
/** * Generate ... * FROM ... using the given SchemaNameProvider */ public final EntityWithSimplePartitionKey_Delete.F allColumns_From(final SchemaNameProvider schemaNameProvider) { final String currentKeyspace = lookupKeyspace(schemaNameProvider, meta.entityClass); final String currentTable = lookupTable(schemaNameProvider, meta.entityClass); final Delete.Where where = delete.all().from(currentKeyspace, currentTable).where(); return new EntityWithSimplePartitionKey_Delete.F(where, CassandraOptions.withSchemaNameProvider(schemaNameProvider)); }
/** * Generate ... * FROM ... using the given SchemaNameProvider */ public final SimpleEntity_Delete.F allColumns_From(final SchemaNameProvider schemaNameProvider) { final String currentKeyspace = lookupKeyspace(schemaNameProvider, meta.entityClass); final String currentTable = lookupTable(schemaNameProvider, meta.entityClass); final Delete.Where where = delete.all().from(currentKeyspace, currentTable).where(); return new SimpleEntity_Delete.F(where, CassandraOptions.withSchemaNameProvider(schemaNameProvider)); }
/** * Generate ... * FROM ... */ public final EntityWithComplexTypes_Delete.F allColumns_FromBaseTable() { final Delete.Where where = delete.all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where(); return new EntityWithComplexTypes_Delete.F(where, new CassandraOptions()); }
/** * Generate ... * FROM ... */ public final EntityWithMissingPartitionKey_Delete.F allColumns_FromBaseTable() { final Delete.Where where = delete.all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where(); return new EntityWithMissingPartitionKey_Delete.F(where, new CassandraOptions()); }
/** * Generate ... * FROM ... */ public final EntityWithComplexTuple_Delete.F allColumns_FromBaseTable() { final Delete.Where where = delete.all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where(); return new EntityWithComplexTuple_Delete.F(where, new CassandraOptions()); }
/** * Adds the table to delete from. * * @param table the name of the table to delete from. * @return a newly built DELETE statement that deletes from {@code table}. */ public Delete from(String table) { return from(null, table); }
/** * Generate ... * FROM ... using the given SchemaNameProvider */ public final EntityWithIndicesForJSON_Delete.F allColumns_From(final SchemaNameProvider schemaNameProvider) { final String currentKeyspace = lookupKeyspace(schemaNameProvider, meta.entityClass); final String currentTable = lookupTable(schemaNameProvider, meta.entityClass); final Delete.Where where = delete.all().from(currentKeyspace, currentTable).where(); return new EntityWithIndicesForJSON_Delete.F(where, CassandraOptions.withSchemaNameProvider(schemaNameProvider)); }
/** * Generate ... * FROM ... */ public final EntityWithIndicesForJSON_Delete.F allColumns_FromBaseTable() { final Delete.Where where = delete.all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where(); return new EntityWithIndicesForJSON_Delete.F(where, new CassandraOptions()); }
/** * Generate ... * FROM ... */ public final EntityWithCustomConstructor_Delete.F allColumns_FromBaseTable() { final Delete.Where where = delete.all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where(); return new EntityWithCustomConstructor_Delete.F(where, new CassandraOptions()); }
/** * Adds the table to delete from. * * @param table the name of the table to delete from. * @return a newly built DELETE statement that deletes from {@code table}. */ public Delete from(String table) { return from(null, table); }
private Statement createDeleteAllStatementFor(String userId) { UUID userUuid = UUID.fromString(userId); return QueryBuilder .delete() .all() .from(Inbox.TABLE_NAME) .where(eq(Inbox.USER_ID, userUuid)); }
private Statement createStatementToDeleteAllEventsFor(User user) { UUID userUuid = UUID.fromString(user.userId); return QueryBuilder .delete() .all() .from(Activity.TABLE_NAME) .where(eq(Activity.USER_ID, userUuid)); }
private Statement createStatementToDeleteMedia(String mediaId) { UUID mediaUuid = UUID.fromString(mediaId); return queryBuilder .delete() .all() .from(Tables.Media.TABLE_NAME) .where(eq(Media.MEDIA_ID, mediaUuid)); }
private Statement createStatementToDeleteAllThumbnailsFor(String mediaId) { UUID mediaUuid = UUID.fromString(mediaId); return QueryBuilder .delete() .all() .from(Tables.Media.TABLE_NAME_THUMBNAILS) .where(eq(Media.MEDIA_ID, mediaUuid)); }
private Statement createStatementToDeleteThubmnail(String mediaId, Dimension dimension) { UUID mediaUuid = UUID.fromString(mediaId); String dimensionString = dimension.toString(); return QueryBuilder .delete() .all() .from(Tables.Media.TABLE_NAME_THUMBNAILS) .where(eq(Media.MEDIA_ID, mediaUuid)) .and(eq(Media.DIMENSION, dimensionString)); }
/** * Adds the table to delete from. * * @param table the name of the table to delete from. * @return a newly built DELETE statement that deletes from {@code table}. */ public Delete from(String table) { return from(null, table); }