update.with(QueryBuilder.removeAll(name, keySet)); } else { update.with(QueryBuilder.remove(name, value));
@Test(groups = "unit", expectedExceptions = InvalidQueryException.class) public void should_not_allow_bind_marker_for_remove() { update("foo").with(remove("s", bindMarker())).where(eq("k", 1)); }
.with(setIdx("a", 2, "foo")) .and(prependAll("b", Arrays.asList(3, 2, 1))) .and(remove("c", "a")) .where(eq("k", 2)) .and(eq("l", "foo"))
/** * Remove data from label index table */ private static void removeLabelIndex(CassandraSessionPool.Session session, String table, CassandraBackendEntry.Row entry) { Update update = QueryBuilder.update(table); Object label = entry.column(HugeKeys.LABEL); if (label == null) { // Maybe delete edges by edge label(passed by id) assert entry.id().asString().indexOf(':') < 0 : entry; return; } update.with(QueryBuilder.remove(ELEMENT_IDS, IdUtil.writeString(entry.id()))); update.where(CassandraTable.formatEQ(HugeKeys.LABEL, label)); session.add(update); }
update.with(QueryBuilder.removeAll(name, keySet)); } else { update.with(QueryBuilder.remove(name, value));
public void delete(CassandraSessionPool.Session session, CassandraBackendEntry.Row entry, String mainTable) { // Get name from main table by id Select select = QueryBuilder.select().from(mainTable); select.where(CassandraTable.formatEQ(HugeKeys.ID, entry.id().asLong())); ResultSet resultSet = session.execute(select); List<Row> rows = resultSet.all(); if (rows.size() == 0) { return; } String name = rows.get(0).getString(HugeKeys.NAME.string()); Update update = QueryBuilder.update(this.table); update.with(QueryBuilder.remove(ELEMENT_IDS, entry.id().asLong())); update.where(CassandraTable.formatEQ(HugeKeys.NAME, name)); session.add(update); }
private static Assignment getAssignment(RemoveOp updateOp) { if (updateOp.getValue() instanceof Set) { return QueryBuilder.removeAll(updateOp.getColumnName().toCql(), (Set) updateOp.getValue()); } if (updateOp.getValue() instanceof List) { return QueryBuilder.discardAll(updateOp.getColumnName().toCql(), (List) updateOp.getValue()); } return QueryBuilder.remove(updateOp.getColumnName().toCql(), updateOp.getValue()); }
@Override public UpdateBuilder<T> removeSet(String name, Object value) { update.with(QueryBuilder.remove(classBean.toColumn(name), value)); return this; } @Override
public static BoundStatement prepareRemoveItemsFromSetOrList(Object id, Class<?> clazz, String propertyName, Object item, String keyspace, Session session) { EntityTypeMetadata emeta = EntityTypeParser.getEntityMetadata(clazz); EntityFieldMetaData fmeta = emeta.getFieldMetadata(propertyName); Update update = QueryBuilder.update(keyspace, emeta.getTableName()); if (item instanceof Set<?> && fmeta.getType() == Set.class) { Set<?> set = (Set<?>) item; if (set.size() == 0) return null; update.with(QueryBuilder.removeAll(fmeta.getColumnName(), set)); } else if (item instanceof List<?> && fmeta.getType() == List.class) { List<?> list = (List<?>) item; if (list.size() == 0) return null; update.with(QueryBuilder.discardAll(fmeta.getColumnName(), list)); } else if (fmeta.getType() == Set.class) { update.with(QueryBuilder.remove(fmeta.getColumnName(), item)); } else if (fmeta.getType() == List.class) { update.with(QueryBuilder.discard(fmeta.getColumnName(), item)); } return prepareUpdate(id, emeta, update, session); }
.with(setIdx("a", 2, "foo")) .and(prependAll("b", Arrays.asList(3, 2, 1))) .and(remove("c", "a")) .where(eq("k", 2))) .add(
.with(setIdx("a", 2, "foo")) .and(prependAll("b", Arrays.asList(3, 2, 1))) .and(remove("c", "a")) .where(eq("k", 2)) .and(eq("l", "foo"))
@Override public void updateConfigs(GCAnalyse analyse, List<Pair<ConfigProperty, String>> vals) { vals.forEach(p -> { ((GCAnalyseImpl) analyse).getConfigs().put(p.getLeft().getId(), p.getRight()); if (p.getRight() != null) { connector.session().execute(updateTable(analyse.accountId(), UUID.fromString(analyse.id())).with(put("configs", p.getLeft().getId(), p.getRight()))); } else { connector.session().execute(updateTable(analyse.accountId(), UUID.fromString(analyse.id())).with(remove("configs", p.getLeft().getId()))); } }); }
private Statement createStatementToRemoveDevice(String userId, MobileDevice mobileDevice) { UUID userUuid = UUID.fromString(userId); String serializeDevice = serializeMobileDevice(mobileDevice); return QueryBuilder .update(UserPreferences.TABLE_NAME) .with(remove(UserPreferences.SERIALIZED_DEVICES, serializeDevice)) .where(eq(UserPreferences.USER_ID, userUuid)); }
/** * Remove data from label index table */ private static void removeLabelIndex(CassandraSessionPool.Session session, String table, CassandraBackendEntry.Row entry) { Update update = QueryBuilder.update(table); Object label = entry.column(HugeKeys.LABEL); if (label == null) { // Maybe delete edges by edge label(passed by id) assert entry.id().asString().indexOf(':') < 0 : entry; return; } update.with(QueryBuilder.remove(ELEMENT_IDS, IdUtil.writeString(entry.id()))); update.where(CassandraTable.formatEQ(HugeKeys.LABEL, label)); session.add(update); }
@Test(groups = "unit", expectedExceptions = InvalidQueryException.class) public void should_not_allow_bind_marker_for_remove() { update("foo").with(remove("s", bindMarker())).where(eq("k", 1)); }
public void delete(CassandraSessionPool.Session session, CassandraBackendEntry.Row entry, String mainTable) { // Get name from main table by id Select select = QueryBuilder.select().from(mainTable); select.where(CassandraTable.formatEQ(HugeKeys.ID, entry.id().asLong())); ResultSet resultSet = session.execute(select); List<Row> rows = resultSet.all(); if (rows.size() == 0) { return; } String name = rows.get(0).getString(HugeKeys.NAME.string()); Update update = QueryBuilder.update(this.table); update.with(QueryBuilder.remove(ELEMENT_IDS, entry.id().asLong())); update.where(CassandraTable.formatEQ(HugeKeys.NAME, name)); session.add(update); }
.with(setIdx("a", 2, "foo")) .and(prependAll("b", Arrays.asList(3, 2, 1))) .and(remove("c", "a")) .where(eq("k", 2))) .add(