@Override public void delete(final TableReference tableRef, final Multimap<Cell, Long> keys) { if (keys.isEmpty()) { return; } for (List<Entry<Cell, Long>> partition : Iterables.partition(keys.entries(), batchSizeForMutations)) { run((Function<DSLContext, Void>) ctx -> { Collection<Row3<byte[], byte[], Long>> rows = Lists.newArrayListWithCapacity(partition.size()); for (Entry<Cell, Long> entry : partition) { rows.add(row(entry.getKey().getRowName(), entry.getKey().getColumnName(), entry.getValue())); } ctx.deleteFrom(atlasTable(tableRef).as(ATLAS_TABLE)) .where(row(A_ROW_NAME, A_COL_NAME, A_TIMESTAMP).in(rows)) .execute(); return null; }); } }
@Override public void dropTables(final Set<TableReference> tableRefs) throws InsufficientConsistencyException { if (tableRefs.isEmpty()) { return; } run((Function<DSLContext, Void>) ctx -> { for (TableReference tableRef : tableRefs) { ctx.dropTableIfExists(tableName(tableRef)).execute(); } ctx.deleteFrom(METADATA_TABLE) .where(TABLE_NAME.in(tableRefs)) .execute(); return null; }); }
public void purgeOld() { int deleted = create() .delete(TASK_INSTANCE) .where( TASK_INSTANCE.START_TIME.lt(new Date(System.currentTimeMillis() - AFTER_SECONDS.get() * 1000))) .execute(); if ( deleted > 0 ) { log.info("Deleted [{}] task instance records", deleted); } }
public void delete(DSLContext tx, String alias) { tx.deleteFrom(TEMPLATE_ALIASES) .where(TEMPLATE_ALIASES.TEMPLATE_ALIAS.eq(alias)) .execute(); }
public void delete(DSLContext tx, UUID id) { tx.deleteFrom(TEAMS) .where(TEAMS.TEAM_ID.eq(id)) .execute(); }
private void delete(DSLContext tx, UUID queryId) { tx.deleteFrom(INVENTORY_QUERIES) .where(INVENTORY_QUERIES.QUERY_ID.eq(queryId)) .execute(); }
public void delete(DSLContext tx, UUID repoId) { tx.deleteFrom(REPOSITORIES) .where(REPOSITORIES.REPO_ID.eq(repoId)) .execute(); }
public void deleteAll(DSLContext tx, UUID projectId) { tx.deleteFrom(REPOSITORIES) .where(REPOSITORIES.PROJECT_ID.eq(projectId)) .execute(); }
@Override public boolean removeItem(String i) { return dsl .delete(ITEMS) .where(ITEM_ID.eq(i)) .execute() == 1; }
public void delete(UUID id) { tx(tx -> tx.deleteFrom(API_KEYS) .where(API_KEYS.KEY_ID.eq(id)) .execute()); }
public void delete(UUID id) { tx(tx -> tx.delete(LANDING_PAGE) .where(LANDING_PAGE.LANDING_PAGE_ID.eq(id)) .execute()); }
@Override public void removeRoles(DynamicSchema dynamicSchema) { create().delete(DYNAMIC_SCHEMA_ROLE) .where(DYNAMIC_SCHEMA_ROLE.DYNAMIC_SCHEMA_ID.eq(dynamicSchema.getId())) .execute(); }
@Override public /* non-final */ void deleteById(Collection<T> ids) { Field<?>[] pk = pk(); if (pk != null) { using(configuration).delete(table).where(equal(pk, ids)).execute(); } }
@Override public void delete(ClusterMembership member) { create().delete(CLUSTER_MEMBERSHIP) .where(CLUSTER_MEMBERSHIP.ID.eq(member.getId())) .execute(); }
public void delete(DSLContext tx, UUID projectId, UUID repositoryId) { tx.delete(TRIGGERS) .where(TRIGGERS.PROJECT_ID.eq(projectId).and(TRIGGERS.REPO_ID.eq(repositoryId))) .execute(); }
public void delete(DSLContext tx, UUID projectId, UUID repositoryId) { tx.delete(LANDING_PAGE) .where(LANDING_PAGE.PROJECT_ID.eq(projectId) .and(LANDING_PAGE.REPO_ID.eq(repositoryId))) .execute(); }
@Override protected Object removeFromStore(String type, String id, Object obj, ApiRequest request) { Table<?> table = JooqUtils.getTableFromRecordClass(JooqUtils.getRecordClass(request.getSchemaFactory(), obj.getClass())); TableField<?, Object> idField = JooqUtils.getTableField(getMetaDataManager(), type, ObjectMetaDataManager.ID_FIELD); int result = create().delete(table).where(idField.eq(id)).execute(); if (result != 1) { log.error("While deleting type [{}] and id [{}] got a result of [{}]", type, id, result); throw new ClientVisibleException(ResponseCodes.CONFLICT); } return obj; }
@Override public void deletePreviousTokens(long authenticatedAsAccountId, long tokenAccountId) { create().delete(AUTH_TOKEN) .where(AUTH_TOKEN.AUTHENTICATED_AS_ACCOUNT_ID.eq(authenticatedAsAccountId)) .and(AUTH_TOKEN.ACCOUNT_ID.eq(tokenAccountId)) .and(AUTH_TOKEN.EXPIRES.greaterThan(new Date())) .execute(); } }
@Override public boolean removePref(String u, String i) { return dsl .delete(DATA) .where(UIDX.eq(user2uidx(u)).and(IIDX.eq(item2iidx(i)))) .execute() == 1; }
public void cleanUpMarkers(String processorName) { tx(tx -> { tx.deleteFrom(EVENT_PROCESSOR_MARKER) .where(EVENT_PROCESSOR_MARKER.PROCESSOR_NAME.eq(processorName) .and(EVENT_PROCESSOR_MARKER.STATUS.eq(MarkerStatus.DONE.name()))) .execute(); }); }