RoomDB Version up migration

Eungi KimΒ·2020λ…„ 10μ›” 22일
1
INSTANCE = Room.databaseBuilder(context, AppDatabase.class, DATABASE_NAME)
        .addMigrations(MIGRATION_1_2, MIGRATION_2_3, MIGRATION_3_4)
        .build();
static final Migration MIGRATION_1_2 = new Migration(1, 2) {
    @Override
    public void migrate(SupportSQLiteDatabase database) {
	database.execSQL("ALTER TABLE sensor ADD COLUMN device_name TEXT NOT NULL DEFAULT ''");

        database.execSQL("CREATE TABLE IF NOT EXISTS srs_radar_data ("
                + "id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL"
                + ", built_in INTEGER NOT NULL DEFAULT 1"
                + ", sensor_status INTEGER NOT NULL"
                + ", activity_detect INTEGER NOT NULL DEFAULT 0"
                + ", data_id_count INTEGER NOT NULL DEFAULT 0"
                + ", data_id_1 INTEGER NOT NULL"
                + ", created_at_view TEXT"
                + ", created_at INTEGER NOT NULL"
                + ")");
    }
};

https://www.notion.so/2020-07-27-85c5e2b993b3494a8b56a9a7a83557c9#cf0e0da7f71a40a7984f913e7531a326

profile
Run and gun and debugun

0개의 λŒ“κΈ€