创建新表时房间迁移查询失败

Question

找到：TableInfo{name='news',Columns={alias=Column{name='alias',Type='text',affinity='2',notnull=false,PrimaryKeyPosition=0,DefaultValue='null'},Selected=Column{name='select',Type='integer',affinity='3',notnull=true,PrimaryKeyPosition=0,DefaultValue='null'},Link=Column{name='link',Type='text',affinity='2',notnull=false,PrimaryKeyPosition=0,列{name='guid',type='text',affinity='2',notnull=false,primarykeyposition=0,defaultvalue='null'},site=column{name='site',type='text',affinity='2',notnull=false,primarykeyposition=0,defaultvalue='null'},date=column{name='date',type='integer',affinity='3',notnull=true,primarykeyposition=0,defaultvalue='null'},topic_url=column{,affinity='2',notnull=false,primarykeyposition=0,defaultvalue='null'},section_url=column{name='section_url',type='text',affinity='2',notnull=false,primarykeyposition=0,defaultvalue='null'},num_photo=column{name='num_photo',type='text',affinity='2',notnull=false,primaryKeyPosition=0,defaultValue='null'},section_guid=column{name='section_guid',type='text',affinity='2',notnull=false,primaryKeyPosition=0,default 09-12 19:06:48.734 616 5-6190/com.ngerancang.cacheapipaging e/eglcodecommon：glutilsparamsize：unknow param 0x00008cdf 09-12 19:06:48.735 616 5-6190/com.ngerancang.cacheapipaging e/eglcodece通用：glutilsparamsize：unknow参数0x00008824

我的模型类看起来是这样的

@Entity(tableName = "news")
data class News(
    @PrimaryKey(autoGenerate = true)
    var id : Int = 0,
    val alias: String?=null,
    @ColumnInfo(name = "content_type")
    @SerializedName("content_type")
    val contentType: String?=null,
    @ColumnInfo(name = "data_source")
    @SerializedName("data_source")
    val dataSource: String?=null,
    val date: Long?=null,
    val dateAgo: String?=null,
    val guid: String?=null,
    val link: String?=null,
    val photo: String?=null,
    val pubDate: String?=null,
    @ColumnInfo(name = "section_guid")
    @SerializedName("section_guid")
    val sectionGuid: String?=null,
    @ColumnInfo(name = "section_title")
    @SerializedName("section_title")
    val sectionTitle: String?=null,
    @ColumnInfo(name = "section_url")
    @SerializedName("section_url")
    val sectionUrl: String?=null,
    val site: String?=null,
    val thumb: String?=null,
    val title: String?=null,
    val topic: String?=null,
    @ColumnInfo(name = "topic_guid")
    @SerializedName("topic_guid")
    val topicGuid: String?=null,
    @ColumnInfo(name = "topic_url")
    @SerializedName("topic_url")
    val topicUrl: String?=null,
    val youtube: String?=null,
    @ColumnInfo(name = "num_photo")
    @SerializedName("num_photo")
    val numPhoto: String?=null,
    var selected: Boolean = false
)

我的数据库抽象类

@Database(entities = [Recipe::class, News::class], version = 2, exportSchema = true)
@TypeConverters(Converters::class)
abstract class AppDatabase : RoomDatabase(){

    abstract fun recipeDao() : RecipeDao

    abstract fun newsDao() : NewsDao

    companion object{

        private val MIGRATION_1_2 : Migration = object : Migration(1, 2){
            override fun migrate(database: SupportSQLiteDatabase) {

                val sql = "CREATE TABLE IF NOT EXISTS `news` (`id` INTEGER NOT NULL, `alias` TEXT, `date` INTEGER NOT NULL, " +
                        "`guid` TEXT, `content_type` TEXT, `data_source` TEXT, `dateAgo` TEXT, `link` TEXT, `photo` TEXT, " +
                        "`pubDate` TEXT, `section_guid` TEXT, `section_title` TEXT, `section_url` TEXT, `site` TEXT, " +
                        "`thumb` TEXT, `title` TEXT, `topic` TEXT, `topic_guid` TEXT, `topic_url` TEXT," +
                        " `num_photo` TEXT, `youtube` TEXT, " +
                        " `selected` INTEGER NOT NULL, PRIMARY KEY(`id`));"
                Log.d("SQL", sql)
                database.execSQL(sql)
            }

        }

        @Volatile
        private var instance: AppDatabase? = null

        fun getDatabase(context: Context): AppDatabase{
            val tempInstance = instance
            if(tempInstance != null){
                return tempInstance
            }

            synchronized(AppDatabase::class.java){
                val dbInstance = Room.databaseBuilder(context,
                AppDatabase::class.java, "recipe-db")
                    .addMigrations(MIGRATION_1_2)
                    .build()

                instance = dbInstance
                return dbInstance
            }

        }
    }
}

我花了几个小时还是没有得到解决办法。我的迁移查询有什么问题？

Answer 1

我发现我的问题是因为

预期

date=Column{name='date', type='INTEGER', affinity='3', notNull=false, primaryKeyPosition=0, defaultValue='null'}

我所做的是

date=Column{name='date', type='INTEGER', affinity='3', notNull=true, primaryKeyPosition=0, defaultValue='null'},