唯一键约束的房间迁移不起作用

Question

错误：java.lang.IllegalStateException：迁移未正确处理：insta_alerts（org.altruist.bajajexperia.models.ceInstaViewDetailSDTo）。

预期：

database.execSQL("CREATE TABLE IF NOT EXISTS insta_alerts(id INTEGER PRIMARY KEY,campaign TEXT,notificationText TEXT,header TEXT,alertMessage TEXT,priority TEXT,sentDate TEXT,smsText TEXT,customerId TEXT,isSeen INTEGER, CONSTRAINT index_insta_alerts_smsText_customerId UNIQUE(smsText, customerId) ON CONFLICT REPLACE)")

@Entity(
    tableName = "insta_alerts", indices =
    [Index(
        value = ["smsText", "customerId"],
        unique = true
    )]
)
@Parcelize
data class CEInstaViewDetailsDTO(
    @PrimaryKey(/*autoGenerate = true*/)
    @ColumnInfo(name = "id")
    @SerializedName("id")
    var id: Long? = null,
    @ColumnInfo(name = "campaign")
    @SerializedName("campaign")
    var campaign: String? = null,
    @ColumnInfo(name = "notificationText")
    @SerializedName("notificationText")
    var notificationText: String? = null,
    @ColumnInfo(name = "header")
    @SerializedName("header")
    var header: String? = null,
    @ColumnInfo(name = "alertMessage")
    @SerializedName("alertMessage")
    var alertMessage: String? = null,
    @ColumnInfo(name = "priority")
    @SerializedName("priority")
    var priority: String? = null,
    @ColumnInfo(name = "sentDate")
    @SerializedName("sentDate")
    var sentDate: String? = null,
    @ColumnInfo(name = "smsText")
    @SerializedName("smsText")
    var smsText: String? = null,
    @ColumnInfo(name = "customerId")
    @SerializedName("customerId")
    var customerId: String? = null,
    @ColumnInfo(name = "isSeen")
    @SerializedName("isSeen")
    var isSeen: Int? = null
) : Parcelable

Answer 1

您应该将索引创建添加到迁移中，如下所示

database.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS index_insta_alerts_smsText_customerId ON insta_alerts (smsText,customerId)")