8Rns8gpc

1internal class DatabaseHelper(context: Context) : SQLiteOpenHelper(
2    context,
3    DATABASE_NAME, null,
4    DATABASE_VERSION
5) {
6    companion object {
7        private const val DATABASE_NAME = "dbfavoritemovie"
8        private const val DATABASE_VERSION = 3
9        const val SQL_CREATE_TABLE_FAVORITE_MOVIE = "CREATE TABLE $TABLE_NAME" +
10                " (${DatabaseContract.MovieColumns._ID} INTEGER PRIMARY KEY AUTOINCREMENT," +
11                " ${DatabaseContract.MovieColumns.NAME} TEXT NOT NULL," +
12                " ${DatabaseContract.MovieColumns.PHOTO} TEXT NOT NULL," +
13                " ${DatabaseContract.MovieColumns.DESCRIPTION} TEXT NOT NULL," +
14                " ${DatabaseContract.MovieColumns.RATE} TEXT NOT NULL," +
15                " ${DatabaseContract.MovieColumns.DATE} TEXT NOT NULL)"
16    }
17
18    override fun onCreate(db: SQLiteDatabase) {
19        db.execSQL(SQL_CREATE_TABLE_FAVORITE_MOVIE)
20    }
21
22    override fun onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int) {
23        db.execSQL("DROP TABLE IF EXISTS $TABLE_NAME")
24        onCreate(db)
25    }
26}