Examples with SQLiteUpdateTask com.abubusoft.kripton.android.sqlite.SQLiteUpdateTask used on opensource projects

Example 46 with SQLiteUpdateTask

use of com.abubusoft.kripton.android.sqlite.SQLiteUpdateTask in project kripton by xcesco.

the class BindSampleDataSource method onUpgrade.

/**
 * onUpgrade
 */
@Override
public void onUpgrade(SQLiteDatabase database, int previousVersion, int currentVersion) {
    // log section BEGIN
    if (this.logEnabled) {
        Logger.info("Update database '%s' from version %s to version %s", this.name, previousVersion, currentVersion);
    }
    // if we have a list of update task, try to execute them
    if (options.updateTasks != null) {
        List<SQLiteUpdateTask> tasks = buildTaskList(previousVersion, currentVersion);
        for (SQLiteUpdateTask task : tasks) {
            // log section BEGIN
            if (this.logEnabled) {
                Logger.info("Begin update database from version %s to %s", previousVersion, previousVersion + 1);
            }
            // log section END
            task.execute(database, previousVersion, previousVersion + 1);
            // log section BEGIN
            if (this.logEnabled) {
                Logger.info("End update database from version %s to %s", previousVersion, previousVersion + 1);
            }
            // log section END
            previousVersion++;
        }
    } else {
        // drop all tables
        SQLiteUpdateTaskHelper.dropTablesAndIndices(database);
        // log section BEGIN
        if (this.logEnabled) {
            Logger.info("DDL: %s", CheeseTable.CREATE_TABLE_SQL);
        }
        // log section END
        database.execSQL(CheeseTable.CREATE_TABLE_SQL);
    }
    if (options.databaseLifecycleHandler != null) {
        options.databaseLifecycleHandler.onUpdate(database, previousVersion, currentVersion, true);
    }
}

Example 47 with SQLiteUpdateTask

use of com.abubusoft.kripton.android.sqlite.SQLiteUpdateTask in project kripton by xcesco.

the class BindPerson2DataSource method onUpgrade.

/**
 * onUpgrade
 */
@Override
public void onUpgrade(SQLiteDatabase database, int previousVersion, int currentVersion) {
    // if we have a list of update task, try to execute them
    if (options.updateTasks != null) {
        List<SQLiteUpdateTask> tasks = buildTaskList(previousVersion, currentVersion);
        for (SQLiteUpdateTask task : tasks) {
            // log section BEGIN
            if (this.logEnabled) {
                Logger.info("Begin update database from version %s to %s", previousVersion, previousVersion + 1);
            }
            // log section END
            task.execute(database, previousVersion, previousVersion + 1);
            // log section BEGIN
            if (this.logEnabled) {
                Logger.info("End update database from version %s to %s", previousVersion, previousVersion + 1);
            }
            // log section END
            previousVersion++;
        }
    } else {
        // drop all tables
        SQLiteUpdateTaskHelper.dropTablesAndIndices(database);
        // generate tables
        database.execSQL(CityTable.CREATE_TABLE_SQL);
        database.execSQL(PersonTable.CREATE_TABLE_SQL);
    }
    if (options.databaseLifecycleHandler != null) {
        options.databaseLifecycleHandler.onUpdate(database, previousVersion, currentVersion, true);
    }
}

Example 48 with SQLiteUpdateTask

use of com.abubusoft.kripton.android.sqlite.SQLiteUpdateTask in project kripton by xcesco.

the class TestKripton234Runtime method testRunSqlite2.

@Test
public void testRunSqlite2() throws IOException, InstantiationException, IllegalAccessException {
    DataSourceOptions.Builder optionsBuilder = DataSourceOptions.builder();
    optionsBuilder.inMemory(false);
    optionsBuilder.databaseLifecycleHandler(new DatabaseLifecycleHandler() {

        @Override
        public void onUpdate(SQLiteDatabase database, int oldVersion, int newVersion, boolean upgrade) {
            log("databaseLifecycleHandler - onUpdate");
        }

        @Override
        public void onCreate(SQLiteDatabase database) {
            log("databaseLifecycleHandler - onCreate " + database.getVersion());
        }

        @Override
        public void onConfigure(SQLiteDatabase database) {
            log("databaseLifecycleHandler - onConfigure");
        }
    });
    optionsBuilder.addUpdateTask(1, new SQLiteUpdateTask() {

        @Override
        public void execute(SQLiteDatabase database, int previousVersion, int currentVersion) {
            log("aaaaaaaaa");
        }
    });
    BindAppWithConfigDataSource ds = BindAppWithConfigDataSource.build(optionsBuilder.build());
}

Example 49 with SQLiteUpdateTask

use of com.abubusoft.kripton.android.sqlite.SQLiteUpdateTask in project kripton by xcesco.

the class BindPersonDataSource method onUpgrade.

/**
 * onUpgrade
 */
@Override
public void onUpgrade(SQLiteDatabase database, int previousVersion, int currentVersion) {
    // log section BEGIN
    if (this.logEnabled) {
        Logger.info("Update database '%s' from version %s to version %s", this.name, previousVersion, currentVersion);
    }
    // if we have a list of update task, try to execute them
    if (options.updateTasks != null) {
        List<SQLiteUpdateTask> tasks = buildTaskList(previousVersion, currentVersion);
        for (SQLiteUpdateTask task : tasks) {
            // log section BEGIN
            if (this.logEnabled) {
                Logger.info("Begin update database from version %s to %s", previousVersion, previousVersion + 1);
            }
            // log section END
            task.execute(database, previousVersion, previousVersion + 1);
            // log section BEGIN
            if (this.logEnabled) {
                Logger.info("End update database from version %s to %s", previousVersion, previousVersion + 1);
            }
            // log section END
            previousVersion++;
        }
    } else {
        // drop all tables
        SQLiteUpdateTaskHelper.dropTablesAndIndices(database);
        // log section BEGIN
        if (this.logEnabled) {
            Logger.info("DDL: %s", PersonTable.CREATE_TABLE_SQL);
        }
        // log section END
        database.execSQL(PersonTable.CREATE_TABLE_SQL);
    }
    if (options.databaseLifecycleHandler != null) {
        options.databaseLifecycleHandler.onUpdate(database, previousVersion, currentVersion, true);
    }
}

Example 50 with SQLiteUpdateTask

use of com.abubusoft.kripton.android.sqlite.SQLiteUpdateTask in project kripton by xcesco.

the class BindDummy01DataSource method onUpgrade.

/**
 * onUpgrade
 */
@Override
public void onUpgrade(SQLiteDatabase database, int previousVersion, int currentVersion) {
    // log section BEGIN
    if (this.logEnabled) {
        Logger.info("Update database '%s' from version %s to version %s", this.name, previousVersion, currentVersion);
    }
    // if we have a list of update task, try to execute them
    if (options.updateTasks != null) {
        List<SQLiteUpdateTask> tasks = buildTaskList(previousVersion, currentVersion);
        for (SQLiteUpdateTask task : tasks) {
            // log section BEGIN
            if (this.logEnabled) {
                Logger.info("Begin update database from version %s to %s", previousVersion, previousVersion + 1);
            }
            // log section END
            task.execute(database, previousVersion, previousVersion + 1);
            // log section BEGIN
            if (this.logEnabled) {
                Logger.info("End update database from version %s to %s", previousVersion, previousVersion + 1);
            }
            // log section END
            previousVersion++;
        }
    } else {
        // drop all tables
        SQLiteUpdateTaskHelper.dropTablesAndIndices(database);
        // log section BEGIN
        if (this.logEnabled) {
            Logger.info("DDL: %s", ChannelTable.CREATE_TABLE_SQL);
        }
        // log section END
        database.execSQL(ChannelTable.CREATE_TABLE_SQL);
    }
    if (options.databaseLifecycleHandler != null) {
        options.databaseLifecycleHandler.onUpdate(database, previousVersion, currentVersion, true);
    }
}