<div id="readability-page-1" class="page"><article id="mainContent">
                <div>
                  <p><a href="/m/category/Dev/Android"><span>Dev/Android</span></a></p><h3>Room DB 마이그레이션</h3>
                </div>
                <p><cite>healthyryu</cite>
                  <span> 2022. 7. 14. 15:42</span>
                </p>
                                <div>
                                <p data-ke-size="size16">안드로이드 공식 페이지 - <a href="https://developer.android.com/training/data-storage/room/migrating-db-versions" target="_blank" rel="noopener">Room 데이터베이스 이전</a></p>

<figure data-ke-mobilestyle="widthOrigin" data-filename="room_architecture.png" data-origin-width="600" data-origin-height="542">
    <span data-url="https://k.kakaocdn.net/dn/bdY0W6/btrHiEVIkMB/LFnCp9UopOM8Red5S7ZBQ0/img.png" data-lightbox="lightbox">
        <img src="https://k.kakaocdn.net/dn/bdY0W6/btrHiEVIkMB/LFnCp9UopOM8Red5S7ZBQ0/img.png" onerror="this.onerror=null; this.src='//t1.daumcdn.net/tistory_admin/static/images/no-image-v1.png'; this.srcset='//t1.daumcdn.net/tistory_admin/static/images/no-image-v1.png';" data-filename="room_architecture.png" data-origin-width="600" data-origin-height="542">
    </span>
    
</figure>
<p data-ke-size="size18"><b>기존 Room DB 구성</b></p>
<div data-ke-type="moreLess" data-text-more="더보기" data-text-less="닫기"><p><a>더보기</a></p><div>
<pre data-ke-language="kotlin"><code>@Database(
    entities = [Alarm::class, MedicationHistory::class],
    version = 1
)
abstract class AppDatabase : RoomDatabase() {

    abstract fun alarmDao(): AlarmDao
    abstract fun medicationHistoryDoa(): MedicationHistoryDao

    companion object {
        @Volatile
        private var instance: AppDatabase? = null

        fun getDatabase(context: Context): AppDatabase =
            instance ?: synchronized(this) {
                instance ?: buildDatabase(context).also {
                    instance = it
                }
            }

        private fun buildDatabase(appContext: Context) =
            Room.databaseBuilder(appContext, AppDatabase::class.java, "app_db")
                .build()
    }

}</code></pre>
</div>
</div>

<p data-ke-size="size18"><b>기존 Room 마이그레이션 방법</b></p>
<pre id="code_1657780326289" data-ke-language="kotlin" data-ke-type="codeblock"><code>@Database(
    version = AppDatabase.LATEST_VERSION,
    entities = [Alarm::class]
)
abstract class AppDatabase : RoomDatabase() {
    abstract fun alarmDao(): AlarmDao

    companion object {
        @Volatile
        private var instance: AppDatabase? = null

        fun getDatabase(context: Context): AppDatabase =
            instance ?: synchronized(this) {
                instance ?: buildDatabase(context).also {
                    instance = it
                }
            }

        private fun buildDatabase(appContext: Context) =
			Room.databaseBuilder(appContext, AppDatabase::class.java, "app_db")
                .addMigrations(MIGRATION_1_2)
                .build()

        private val MIGRATION_1_2 = object : Migration(1, 2) {
            override fun migrate(database: SupportSQLiteDatabase) {
                database.execSQL("DROP TABLE 테이블이름")
            }
        }

        const val LATEST_VERSION = 2
    }
}</code></pre>

<p data-ke-size="size18"><b>AutoMigration 사용하는 마이그레이션 방법</b></p>
<pre id="code_1657780409539" data-ke-language="kotlin" data-ke-type="codeblock"><code>@Database(
    version = AppDatabase.LATEST_VERSION,
    entities = [Alarm::class],
    autoMigrations = [
        AutoMigration(
            from = 1,
            to = 2,
            spec = AppDatabase.IhpMigration::class
        )
    ],
    exportSchema = true
)
abstract class AppDatabase : RoomDatabase() {
    abstract fun alarmDao(): AlarmDao

    @DeleteTable(tableName = "테이블이름")
    class IhpMigration : AutoMigrationSpec {}

    companion object {
        @Volatile
        private var instance: AppDatabase? = null

        fun getDatabase(context: Context): AppDatabase =
            instance ?: synchronized(this) {
                instance ?: buildDatabase(context).also {
                    instance = it
                }
            }

        private fun buildDatabase(appContext: Context) =
            Room.databaseBuilder(appContext, AppDatabase::class.java, "inhandplus")
                .build()

        const val LATEST_VERSION = 2
    }
}</code></pre>
            
            
                </div>
                            
            
              </article></div>

대부류 - [Dev u Ryu]

류지훈

안드로이드 공식 페이지 - Room 데이터베이스 이전
 
기존 Room DB 구성
더보기
@Database(
    entities = [Alarm::class, MedicationHistory::class],
    version = 1
)
abstract class AppDatabase : RoomDatabase() {
    abstract fun alarmDao(): AlarmDao
    abstract fun medicationHistoryDoa(): MedicationHistoryDao
    companion object {
        @Volatile
        private var instance: AppDatabase? = null
        fun getDatabase(context: Context): AppDatabase =
            instance ?: synchronized(this) {
                instance ?: buildDatabase(context).also {
                    instance = it
                }
            }
        private fun buildDatabase(appContext: Context) =
            Room.databaseBuilder(appContext, AppDatabase::class.java, "app_db")
                .build()
    }
}
 
기존 Room 마이그레이션 방법
@Database(
    version = AppDatabase.LATEST_VERSION,
    entities = [Alarm::class]
)
abstract class AppDatabase : RoomDatabase() {
    abstract fun alarmDao(): AlarmDao
    companion object {
        @Volatile
        private var instance: AppDatabase? = null
        fun getDatabase(context: Context): AppDatabase =
            instance ?: synchronized(this) {
                instance ?: buildDatabase(context).also {
                    instance = it
                }
            }
        private fun buildDatabase(appContext: Context) =
			Room.databaseBuilder(appContext, AppDatabase::class.java, "app_db")
                .addMigrations(MIGRATION_1_2)
                .build()
        private val MIGRATION_1_2 = object : Migration(1, 2) {
            override fun migrate(database: SupportSQLiteDatabase) {
                database.execSQL("DROP TABLE 테이블이름")
            }
        }
        const val LATEST_VERSION = 2
    }
}
 
AutoMigration 사용하는 마이그레이션 방법
@Database(
    version = AppDatabase.LATEST_VERSION,
    entities = [Alarm::class],
    autoMigrations = [
        AutoMigration(
            from = 1,
            to = 2,
            spec = AppDatabase.IhpMigration::class
        )
    ],
    exportSchema = true
)
abstract class AppDatabase : RoomDatabase() {
    abstract fun alarmDao(): AlarmDao
    @DeleteTable(tableName = "테이블이름")
    class IhpMigration : AutoMigrationSpec {}
    companion object {
        @Volatile
        private var instance: AppDatabase? = null
        fun getDatabase(context: Context): AppDatabase =
            instance ?: synchronized(this) {
                instance ?: buildDatabase(context).also {
                    instance = it
                }
            }
        private fun buildDatabase(appContext: Context) =
            Room.databaseBuilder(appContext, AppDatabase::class.java, "inhandplus")
                .build()
        const val LATEST_VERSION = 2
    }
}

Room DB 마이그레이션

댓글