使用JOOQ将POJO中的字段设置为null

Question

// Load the customer record from a POJO
CustomerRecord customer = ctx.newRecord(CUSTOMER, customerPojo);
customer.update();

// Expected behavior: null fields in customerPojo will set db values to null
// Actual behavior: null fields in customerPojo do not change values in db

drop table if exists customers;
create table customers
(
    id         serial not null primary key,
    first_name text,
    last_name  text
);

java prettyprint-override">@Data
@Builder(toBuilder = true)
@NoArgsConstructor
@AllArgsConstructor
public class Customer {

    private Integer id;
    private String firstName;
    private String lastName;

    public static Customers TAB = Customers.CUSTOMERS;
    static DSLContext ctx = PostgresSingleton.getMainCtx();

    public Customer store(){
        CustomersRecord rec = ctx.newRecord(TAB, this);
        if(getId() == null) {
            rec.store();
        }
        else {
            rec.update();
        }
        rec.refresh();
        return rec.into(Customer.class);
    }
}

    def "Customer test"() {
        when: "save a new customer"
        Customer cust = Customer.builder().firstName("Phil").lastName("H").build().store()

        then: "ID populated"
        def custId = cust.getId()
        custId != null

        when: "null out last name"
        cust.toBuilder().lastName(null).build().store()

        then: "last name actually set to null"
        cust.getId() == custId
        cust.getFirstName() == "Phil"
        cust.getLastName() == null //fails, still is "H"
    }

编辑2：

似乎.update()调用实际上是在取消数据库中的字段！但是，.into()调用并没有像预期的那样用空字段刷新POJO。我在.refresh()之后验证了lastName的值为null，但是into()调用没有使该值为null。

Answer 1

嗯，这是一个PEBKAC错误--我没有将更新的结果存储回测试中的同一个对象中：

        when: "null out last name"
        cust.toBuilder().lastName(null).build().store() //not storing the result!

应该是：

        when: "null out last name"
        cust = cust.toBuilder().lastName(null).build().store()

容易错过。