public boolean updateStatus(List<ProcessKey> processKeys, ProcessStatus status, List<ProcessStatus> expected) { return txResult(tx -> { List<UUID> instanceIds = processKeys.stream() .map(PartialProcessKey::getInstanceId) .collect(Collectors.toList()); UpdateConditionStep q = tx.update(PROCESS_QUEUE) .set(PROCESS_QUEUE.CURRENT_STATUS, status.toString()) .set(PROCESS_QUEUE.LAST_UPDATED_AT, currentTimestamp()) .set(PROCESS_QUEUE.LAST_RUN_AT, createRunningAtValue(status)) .where(PROCESS_QUEUE.INSTANCE_ID.in(instanceIds)); if (expected != null) { List<String> l = expected.stream() .map(Enum::toString) .collect(Collectors.toList()); q.and(PROCESS_QUEUE.CURRENT_STATUS.in(l)); } int i = q.execute(); insertHistoryStatus(tx, processKeys, status); return i == processKeys.size(); }); }
@Override public Void withConnection(final Connection conn) throws SQLException { DSL.using(conn, dialect, settings) .update(paymentMethodsTable) .set(DSL.field(IS_DELETED), TRUE) .set(DSL.field(UPDATED_DATE), toTimestamp(utcNow)) .where(DSL.field(KB_PAYMENT_METHOD_ID).equal(kbPaymentMethodId.toString())) .and(DSL.field(KB_TENANT_ID).equal(kbTenantId.toString())) .execute(); return null; } });
.set(Tables.META_INFO.LAST_UPDATED, new Timestamp(info.getLastUpdated().getTime())) .where(Tables.META_INFO.COMPONENT.eq(info.getComponent().getSimpleName())) .and(langCondition) .execute(); if (n == 0) {