Proyectos de Subversion Android Microlearning - Inconcert

package com.cesams.twogetskills.inconcert.dao;

import android.content.Context;

import androidx.room.Room;

import androidx.room.migration.Migration;

import androidx.sqlite.db.SupportSQLiteDatabase;

import com.cesams.twogetskills.inconcert.Constants;

public class DatabaseHelper {

    private static DatabaseHelper _INSTANCE = null;

    private AppDatabase appDatabase;

    // other instance variables can be here

    private DatabaseHelper(Context context) {

        appDatabase = Room.databaseBuilder(

                context.getApplicationContext(),

                AppDatabase.class, Constants.DATABASE_FILENAME

        ).allowMainThreadQueries().addMigrations(MIGRATION_1_2).fallbackToDestructiveMigration()

                .build();

    };

    static final Migration MIGRATION_1_2 = new Migration(1, 2) {

        @Override

        public void migrate(SupportSQLiteDatabase database) {

            database.execSQL("CREATE TABLE `tb_notification` (`id` INTEGER NOT NULL, "

                    + "`title` TEXT,`date` TEXT,`description` TEXT, viewed TEXT, url TEXT, PRIMARY KEY(`id`))");

            database.execSQL("ALTER TABLE `tb_capsules`"

                    + "ADD COLUMN added_on TEXT");

            database.execSQL("ALTER TABLE `tb_capsules`"

                    + "ADD COLUMN updated_on TEXT");

            database.execSQL("ALTER TABLE `tb_topics`"

                    + "ADD COLUMN added_on TEXT");

            database.execSQL("ALTER TABLE `tb_topics`"

                    + "ADD COLUMN updated_on TEXT");

        }

    };

    public static DatabaseHelper getInstance(Context context) {

        if (_INSTANCE == null) {

            _INSTANCE = new DatabaseHelper(context);

        }

        return(_INSTANCE);

    }

    public AppDatabase getAppDatabase() {

        return appDatabase;

    }

}