android - 房间持久性库事务

Question

我有 2 个实体类:

@Entity(tableName = "work_orders")
public class WorkOrderEntity
{
    @PrimaryKey(autoGenerate = true)
    private long id;
    ...
}

@Entity(tableName = "activity_logs", foreignKeys = {
        @ForeignKey(entity = WorkOrderEntity.class, parentColumns = "id", childColumns = "work_order_id") })
public class ActivityLogEntity
{
    @PrimaryKey(autoGenerate = true)
    private long id;

    @ColumnInfo(name = "work_order_id")
    private long workOrderId;
    ...
}

有没有办法在一个事务中在 work_orders 和 activity_log 表中插入记录？像这样:

@Transaction
public void insertBoth(WorkOrderEntity workOrderEntity, ActivityLogEntity activityLogEntity)
{
    insertWorkOrder(workOrderEntity);
    insertActivityLog(activityLogEntity);
}

牢记外键约束。

这里是类似的问题Insert into multiple tables using Room Persistence Library , 但没有详尽的答案

Answer 1

我想出了这个解决方案:

@Transaction
public void insertBoth(WorkOrderEntity workOrderEntity, ActivityLogEntity activityLogEntity)
{
    long workOrderId = insertWorkOrder(workOrderEntity);
    activityLogEntity.setWorkOrderId(workOrderId);
    insertActivityLog(activityLogEntity);
}