如何将现有的sqlite表迁移到具有VCHAR、TIMESTAMP等数据类型的ROOM Db中？

Question

在我的旧html" target="_blank">sqlite表中，我有这些列(id INTEGER主键AUTOINCREMENT、api_response_json TEXT、api_req TEXT、post_params TEXT、req_type VARCHAR、timestamp timestamp）

    @Override
    public void migrate(SupportSQLiteDatabase database) {
    // Create the new table
        database.execSQL(
                "CREATE TABLE users_new (id INTEGER PRIMARY KEY AUTOINCREMENT,api_response_json TEXT, api_req TEXT,post_params TEXT,req_type VARCHAR,timestamp TIMESTAMP)");
    // Copy the data
        database.execSQL("INSERT INTO users_new (id,api_response_json, api_req,post_params,req_type,timestamp) "
                + "SELECT id,api_response_json, api_req,post_params, req_type,timestamp "
                + "FROM old_Table_name");
    // Remove the old table
        database.execSQL("DROP TABLE old_Table_name");
    // Change the table name to the correct one
        database.execSQL("ALTER TABLE users_new RENAME TO old_Table_name");}
};

我收到一个错误迁移没有正确处理

应为：TableInfo{name='api_data',columns={timestamp=column{name='timestam',type='text',notnull=false,primarykeyposition=0},req_type=column{name='req_type',type='text',notnull=false,primarykeyposition=0},post_params=column{name='post_params',type='text',notnull=false,primarykeyposition=0},id=column{name='id',type='integer',notnull=false,'api_response_json',type='text',notnull=false,primarykeyposition=0},api_req=column{name='api_req',type='text',notnull=false,primarykeyposition=0}},foreignkeys=[],indices=[]}

找到：TableInfo{name='api_data',columns={timestamp=column{name='timestamp',type='timestamp',notnull=false,primarykeyposition=0},req_type=column{name='req_type',type='varchar',notnull=false,primarykeyposition=0},post_params=column{name='post_params',type='text',notnull=false,primarykeyposition=0},id=column{name='id',type='integer',notnull=false,{name='api_response_json',type='text',notnull=false,primarykeyposition=0},api_req=column{name='api_req',type='text',notnull=false,primarykeyposition=0}},foreignkeys=[],indices=[]}

时间戳和VARCHAR有问题。

Answer 1

是的，TIMESTAMP和VARCHAR中有问题，您应该将其更改为：

    static final Migration MIGRATION_1_2 = new Migration(1, 2) {
    @Override
    public void migrate(SupportSQLiteDatabase database) {
        // Create the new table
        database.execSQL(
                "CREATE TABLE users_new (id INTEGER PRIMARY KEY AUTOINCREMENT,api_response_json TEXT, api_req TEXT,post_params TEXT,req_type TEXT,timestamp TEXT)");
        // Copy the data
        database.execSQL("INSERT INTO users_new (id,api_response_json, api_req,post_params,req_type,timestamp) "
                + "SELECT id,api_response_json, api_req,post_params, req_type,timestamp "
                + "FROM old_Table_name");
        // Remove the old table
        database.execSQL("DROP TABLE old_Table_name");
        // Change the table name to the correct one
        database.execSQL("ALTER TABLE users_new RENAME TO old_Table_name");}
    };

答案就在您的迁移错误中