Page 1 of 1

Wie schließe ich Nullwerte aus, wenn Sie Update in JOOQ (REST -API -Patch) durchführen?

Posted: 18 Mar 2025, 16:53
by Anonymous
public BankResponse update(BankUpdateRequest request, Integer id) {
UpdateSetFirstStep update = dsl.update(BANK);
UpdateSetMoreStep moreStep = null;

if (request.naziv() != null) moreStep = update.set(BANK.NAME, request.naziv());
if (request.ziroRacun() != null) moreStep = (moreStep != null ? moreStep : update).set(BANK.BANK_ACCOUNT, request.ziroRacun());
if (request.fax() != null) moreStep = (moreStep != null ? moreStep : update).set(BANK.FAX, request.fax());

if (moreStep == null) {
throw new IllegalStateException("No fields to update");
}

return moreStep
.where(BANK.ID.eq(id))
.returning()
.fetchOptional()
.map(r -> r.into(BankResponse.class))
.orElseThrow(() -> new ResourceNotFoundException(EntityType.BANK, id));
}
< /code>
Gibt es eine elegantere Möglichkeit, dies in Java jooq zu tun.>