Back to Examples

Merging data

Merge (upsert) query examples using DTO mode, SQL mode, and native SQL.

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)));