I need help with SQL migration in Room

# android

[Joao Rubens Belluzzo Neto]

I need help with SQL migration in Room

[Joao Rubens Belluzzo Neto]

message has been deleted

[Joao Rubens Belluzzo Neto]

I'm trying to migrate an existing database with Jetpack Compose Room, but I have this problem

[Joao Rubens Belluzzo Neto]

image.png

[Joao Rubens Belluzzo Neto]

package dev.bellu.flight_search.data.database

import android.content.Context
import androidx.room.Database
import androidx.room.Room
import androidx.room.RoomDatabase
import androidx.room.migration.Migration
import androidx.sqlite.db.SupportSQLiteDatabase
import dev.bellu.flight_search.data.contracts.FlightDao
import dev.bellu.flight_search.data.entity.AirportEntity
import dev.bellu.flight_search.data.entity.FavoriteEntity
import java.io.*

@Database(entities = [AirportEntity::class, FavoriteEntity::class], version = 1, exportSchema = true)
abstract class FlightDatabase : RoomDatabase() {
    abstract fun FlightDao(): FlightDao

    companion object {
        private const val DATABASE_NAME = "new_flight_search.db"
        fun getDatabase(context: Context): FlightDatabase {
            return Room.databaseBuilder(
                name = DATABASE_NAME,
                klass = FlightDatabase::class.java,
                context = context
            )
                .createFromFile(databaseFile = File("flight_search.db"))
                .build()
        }
    }
}

[marlonlom]

📖 https://medium.com/androiddevelopers/understanding-migrations-with-room-f01e04b07929

[Daniel B Duval]

Another good read on this topic:
https://medium.com/androiddevelopers/incrementally-migrate-from-sqlite-to-room-66c2f655b377

[Joao Rubens Belluzzo Neto]

Thanks guys!