net.akaish.kitty.orm.util

Class KittySimpleMigrationScriptGenerator

java.lang.Object

net.akaish.kitty.orm.util.KittySimpleMigrationScriptGenerator

public class KittySimpleMigrationScriptGenerator
extends java.lang.Object

Simple utility for generating migration script sequence.
It is capable only to delete and create new indexes and table as well as adding or deleting columns in existing tables, so use it only when you're sure that there are no constraints defined that can be violated with script created by this utility class.
KSMSG v.1 Created by akaish on 13.10.18.

Author:

akaish (Denis Bogomolov)

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	KittySimpleMigrationScriptGenerator.DIFF_STATES
class	KittySimpleMigrationScriptGenerator.DiffElement Diff model
(package private) class	KittySimpleMigrationScriptGenerator.GeneratedDiffResult GenerateDiffResults class designed to be used as result of generateDiffs(KittyDatabaseConfiguration, ArrayList, ArrayList, HashMap)
static class	KittySimpleMigrationScriptGenerator.TYPE

Field Summary

Fields

Modifier and Type	Field and Description
(package private) android.content.Context	ctx
(package private) android.database.sqlite.SQLiteDatabase	database
(package private) KittyDatabaseConfiguration	databaseConfiguration
KittySimpleMigrationScriptGenerator.GeneratedDiffResult	diffs
(package private) java.util.HashMap<java.lang.String,java.util.LinkedList<java.lang.String>>	existingColumnNames
(package private) java.util.ArrayList<java.lang.String>	existingIndexNames
(package private) java.util.ArrayList<java.lang.String>	existingTableNames
(package private) static java.lang.String	I_FETCHED_EXISTING_COLUMN
(package private) static java.lang.String	I_FETCHED_EXISTING_COLUMN_AMOUNT
(package private) static java.lang.String	I_FETCHING_EXISTING_COLUMNS
(package private) static java.lang.String	I_FETCHING_INDEXES_NAMES
(package private) static java.lang.String	I_FETCHING_TABLE_NAMES
(package private) static java.lang.String	I_FOUND_INDEX
(package private) static java.lang.String	I_FOUND_INDEX_AMOUNT
(package private) static java.lang.String	I_FOUND_TABLE
(package private) static java.lang.String	I_FOUND_TABLE_AMOUNT
(package private) static java.lang.String	I_GENERATED_DIFFS
(package private) static java.lang.String	I_GENERATING_DIFFS
(package private) static java.lang.String	I_PRINTING_GENERATED_DIFFS
(package private) static java.lang.String	I_STARTED
(package private) static java.lang.String	IA_TYPE_MISMATCH

Constructor Summary

Constructors

Constructor and Description
KittySimpleMigrationScriptGenerator(android.content.Context ctx, KittyDatabaseConfiguration databaseConfiguration, android.database.sqlite.SQLiteDatabase database) At this constructor would be generated diff collection.

Method Summary

Modifier and Type	Method and Description
java.util.LinkedList<KittySQLiteQuery>	generateAlterTableWithNewColumns(KittySimpleMigrationScriptGenerator.DiffElement element, java.util.HashMap<java.lang.String,KittyTableConfiguration> newTables, java.lang.String schemaName) Returns alter table add columns query sequence
java.util.LinkedList<KittySQLiteQuery>	generateAlterTableWithRedundantColumns(KittyTableConfiguration conf, KittySimpleMigrationScriptGenerator.DiffElement element) Generates query sequence that doing following things: Renames current existing table to new name Creates new table without redundant columns Copies fields same fields from old table to new one Wipes old table
java.util.LinkedList<KittySQLiteQuery>	generateMigrationScript() Generates migration script sequence

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

ctx

final android.content.Context ctx

databaseConfiguration

final KittyDatabaseConfiguration databaseConfiguration

database

final android.database.sqlite.SQLiteDatabase database

existingTableNames

final java.util.ArrayList<java.lang.String> existingTableNames

existingIndexNames

final java.util.ArrayList<java.lang.String> existingIndexNames

existingColumnNames

final java.util.HashMap<java.lang.String,java.util.LinkedList<java.lang.String>> existingColumnNames

I_STARTED

static final java.lang.String I_STARTED

See Also:

Constant Field Values

I_FETCHING_TABLE_NAMES

static final java.lang.String I_FETCHING_TABLE_NAMES

See Also:

Constant Field Values

I_FOUND_TABLE

static final java.lang.String I_FOUND_TABLE

See Also:

Constant Field Values

I_FOUND_TABLE_AMOUNT

static final java.lang.String I_FOUND_TABLE_AMOUNT

See Also:

Constant Field Values

I_FETCHING_INDEXES_NAMES

static final java.lang.String I_FETCHING_INDEXES_NAMES

See Also:

Constant Field Values

I_FOUND_INDEX

static final java.lang.String I_FOUND_INDEX

See Also:

Constant Field Values

I_FOUND_INDEX_AMOUNT

static final java.lang.String I_FOUND_INDEX_AMOUNT

See Also:

Constant Field Values

I_FETCHING_EXISTING_COLUMNS

static final java.lang.String I_FETCHING_EXISTING_COLUMNS

See Also:

Constant Field Values

I_FETCHED_EXISTING_COLUMN

static final java.lang.String I_FETCHED_EXISTING_COLUMN

See Also:

Constant Field Values

I_FETCHED_EXISTING_COLUMN_AMOUNT

static final java.lang.String I_FETCHED_EXISTING_COLUMN_AMOUNT

See Also:

Constant Field Values

I_GENERATING_DIFFS

static final java.lang.String I_GENERATING_DIFFS

See Also:

Constant Field Values

I_GENERATED_DIFFS

static final java.lang.String I_GENERATED_DIFFS

See Also:

Constant Field Values

I_PRINTING_GENERATED_DIFFS

static final java.lang.String I_PRINTING_GENERATED_DIFFS

See Also:

Constant Field Values

IA_TYPE_MISMATCH

static final java.lang.String IA_TYPE_MISMATCH

See Also:

Constant Field Values

diffs

public final KittySimpleMigrationScriptGenerator.GeneratedDiffResult diffs

Constructor Detail

KittySimpleMigrationScriptGenerator

public KittySimpleMigrationScriptGenerator(android.content.Context ctx,
                                           KittyDatabaseConfiguration databaseConfiguration,
                                           android.database.sqlite.SQLiteDatabase database)

At this constructor would be generated diff collection. Also in this constructor would be some database calls, so it is quite slow. Good idea to start transaction for provided database before initializing it.

Parameters:

ctx -

databaseConfiguration -

database -

Method Detail

generateMigrationScript

public final java.util.LinkedList<KittySQLiteQuery> generateMigrationScript()

Generates migration script sequence

Returns:

generateAlterTableWithNewColumns

public java.util.LinkedList<KittySQLiteQuery> generateAlterTableWithNewColumns(KittySimpleMigrationScriptGenerator.DiffElement element,
                                                                               java.util.HashMap<java.lang.String,KittyTableConfiguration> newTables,
                                                                               java.lang.String schemaName)

Returns alter table add columns query sequence

Parameters:

element -

newTables -

schemaName -

Returns:

generateAlterTableWithRedundantColumns

public java.util.LinkedList<KittySQLiteQuery> generateAlterTableWithRedundantColumns(KittyTableConfiguration conf,
                                                                                     KittySimpleMigrationScriptGenerator.DiffElement element)

Generates query sequence that doing following things:
Renames current existing table to new name
Creates new table without redundant columns
Copies fields same fields from old table to new one
Wipes old table

Parameters:

conf -

element -

Returns: