DSLContext create = DSL.using(configuration); // This intermediate result is only used to extract ID values later on Result<MyTableRecord> result = create.newResult(MY_TABLE); result.add(record1); result.add(record2); create.delete(MY_TABLE) .where(MY_TABLE.ID.in(result.getValues(MY_TABLE.ID)) .execute();
@Override public void delete(Stream<Condition> conditions) { Optional<Condition> o = conditions.reduce((acc, item) -> acc.and(item)); Condition c = o.orElseThrow( () -> new IllegalArgumentException("At least one condition is needed to perform deletion")); getDSLContext().delete(table).where(c).execute(); }
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); } }
@Override public boolean removeUser(String u) { return dsl .delete(USERS) .where(USER_ID.eq(u)) .execute() == 1; }
@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.delete(TRIGGERS) .where(TRIGGERS.TRIGGER_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 int deleteById(ID id) { return getDSLContext().delete(table).where(primaryKey.equal(id)).execute(); }
@Override public void deleteByIds(Collection<ID> ids) { getDSLContext().delete(table).where(primaryKey.in(ids)).execute(); }
@Override public void delete(ClusterMembership member) { create().delete(CLUSTER_MEMBERSHIP) .where(CLUSTER_MEMBERSHIP.ID.eq(member.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 removeRoles(DynamicSchema dynamicSchema) { create().delete(DYNAMIC_SCHEMA_ROLE) .where(DYNAMIC_SCHEMA_ROLE.DYNAMIC_SCHEMA_ID.eq(dynamicSchema.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(); }
@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; }
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 public final void deleteById(Collection<T> ids) { Field<?> pk = pk(); if (pk != null) { using(configuration).delete(table).where(equal(pk, ids)).execute(); } }
@Override public void deleteProjectMemberEntries(Account account) { if (!ProjectConstants.TYPE.equalsIgnoreCase(account.getKind()) && StringUtils.isNotBlank(account.getExternalId()) && StringUtils.isNotBlank(account.getExternalIdType())){ create().delete(PROJECT_MEMBER) .where(PROJECT_MEMBER.EXTERNAL_ID.eq(account.getExternalId()) .and(PROJECT_MEMBER.EXTERNAL_ID_TYPE.eq(account.getExternalIdType()))) .execute(); } create().delete(PROJECT_MEMBER) .where(PROJECT_MEMBER.PROJECT_ID.eq(account.getId())) .execute(); }
@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 void delete(Object obj) { if (obj == null) { return; } Object id = ObjectUtils.getId(obj); String type = getType(obj); Table<?> table = JooqUtils.getTableFromRecordClass(JooqUtils.getRecordClass(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) { throw new IllegalStateException("Failed to delete [" + type + "] id [" + id + "]"); } }
@Override public boolean removePref(String u, String i) { return dsl .delete(DATA) .where(UIDX.eq(user2uidx(u)).and(IIDX.eq(item2iidx(i)))) .execute() == 1; }