Upsert
Upsert an entity.
MergeExample.java
import org.example.dto.Person;Person person = new Person();
person.setId(1);
person.setName("Alice");
person.setSurname("Smith");
// Executes MERGE INTO LB.PERSON USING ...
litebridge.merge(person);Merge data using a table
Merge records into a table using entity mapping metadata.
MergeExample.java
import org.example.dto.Person;
import org.example.dto.Account;
import org.example.entity.meta.PersonMeta;
import org.example.entity.meta.AccountMeta;litebridge.mergeInto(Account.class, m -> m
.using(Person.class)
.on(AccountMeta.id).eq(PersonMeta.id)
.whenMatched(u -> u
.update(account -> account
.set(AccountMeta.balance).to(500)
.where(AccountMeta.id).lt(5)))
.whenMatched(account -> account
.delete()
.where(AccountMeta.id).gte(5)))
.whenNotMatched(i -> i
.insert(AccountMeta.id, AccountMeta.name, AccountMeta.balance, AccountMeta.owner)
.values(123L, "Default Account", 0, 1L)));