Proyectos de Subversion Android Microlearning - Nuevo Interface

package com.cesams.twogetskills.dao;

import android.content.Context;

import androidx.room.Room;
import androidx.room.migration.Migration;
import androidx.sqlite.db.SupportSQLiteDatabase;

import com.cesams.twogetskills.Constants;
import com.cesams.twogetskills.entity.NotificationCenter;

public class DatabaseHelper {

    //Control de cambio de capsula
    //public static String CambioSlide = "NO"; // SI o NO
    //public static String ResumenVisores ="NO";
    //public static String imagenviewerontrol= "NO";

    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, 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_capsules`"
                    + "ADD COLUMN startedOn TEXT");

            database.execSQL("ALTER TABLE `tb_capsules`"
                    + "ADD COLUMN finalizedOn TEXT");

            database.execSQL("ALTER TABLE `tb_topics`"
                    + "ADD COLUMN updated_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;
    }
}