更新批存储区jooq上唯一约束的记录

Question

我正在尝试使用jooq使用batchStore插入记录。我需要知道如何在唯一约束上更新记录，目前它抛出一个异常，该记录已经存在

SQL Error [23505]: ERROR: duplicate key value violates unique constraint

下面是代码

DSLContext create = getDSLContext();
List<UserRecord> userRecordList = new ArrayList<>();
for (Users user : model.getUsers()) {
    User record = create.newRecord(user);
    userRecordList.add(record);
}
create.batchStore(userRecordList).execute();

目前，它可以很好地插入记录，但当根据唯一约束发现重复记录时，它应该更新记录

Answer 1

我必须和JN_新手一样。为了完整起见，下面是我的解决方案。

// OpeningtimeRecord is the JOOG generated record for the Openingtime table.
List<OpeningtimeRecord> openingRecords = new ArrayList<>();

// Openingtime is the POJO generated from the database schema for the table.
for (Openingtime opening : openings)
{
    // Check to see if this record already exists in the database
    OpeningtimeRecord record = dbContext.fetchOne(*TABLE*, *TABLE.ID*.eq(opening.getId()));

    // If it doesn't exist then we need to create a new record
    if (null == record)
    {
        record = dbContext.newRecord(*TABLE*, opening);
    }
    else
    {
        // Update the record with any new data from the POJO.
        record.from(opening);
    }

    openingRecords.add(record);
}

int[] results = this.dbContext.batchStore(openingRecords).execute();

Answer 2

我通过使用公共接口UpdateableRecord解决了这个问题，首先我使用了fetchOne（）查询，根据唯一约束获取记录，该约束将给出UpdateableRecord，然后使用更新后的值设置值，这些值将添加到userRecordlist，并进一步传递到batchStore