au.com.cybersearch2.classydb

Interface DatabaseAdmin

All Known Implementing Classes:

DatabaseAdminImpl

public interface DatabaseAdmin

DatabaseAdmin

Author:

Andrew Bowley 05/07/2014

Field Summary

Fields

Modifier and Type	Field and Description
static String	DATA_FILENAME Property key for populate database
static String	DATABASE_NAME Property key for database name
static String	DATABASE_VERSION Property key for database version
static String	DROP_SCHEMA_FILENAME Property key for drop database
static String	SCHEMA_FILENAME Property key for create database
static String	UPGRADE_FILENAME_FORMAT Property key for update database.

Method Summary

Methods

Modifier and Type	Method and Description
OpenHelperCallbacks	getCustomOpenHelperCallbacks()
void	onCreate(com.j256.ormlite.support.ConnectionSource connectionSource) To support android.database.sqlite.SQLiteOpenHelper Called when the database is created for the first time.
void	onUpgrade(com.j256.ormlite.support.ConnectionSource connectionSource, int oldVersion, int newVersion) See android.database.sqlite.SQLiteOpenHelper Called when the database needs to be upgraded.

Field Detail

SCHEMA_FILENAME

static final String SCHEMA_FILENAME

Property key for create database

See Also:

Constant Field Values

DROP_SCHEMA_FILENAME

static final String DROP_SCHEMA_FILENAME

Property key for drop database

See Also:

Constant Field Values

DATA_FILENAME

static final String DATA_FILENAME

Property key for populate database

See Also:

Constant Field Values

UPGRADE_FILENAME_FORMAT

static final String UPGRADE_FILENAME_FORMAT

Property key for update database. Use Java MessageFormat with %1 = old version and %2 = new version - see java.text.MessageFormat

See Also:

Constant Field Values

DATABASE_VERSION

static final String DATABASE_VERSION

Property key for database version

See Also:

Constant Field Values

DATABASE_NAME

static final String DATABASE_NAME

Property key for database name

See Also:

Constant Field Values

Method Detail

onCreate

void onCreate(com.j256.ormlite.support.ConnectionSource connectionSource)

To support android.database.sqlite.SQLiteOpenHelper Called when the database is created for the first time. This is where the creation of tables and the initial population of the tables should happen.

Parameters:

connectionSource - Open Connection Source

onUpgrade

void onUpgrade(com.j256.ormlite.support.ConnectionSource connectionSource,
             int oldVersion,
             int newVersion)

See android.database.sqlite.SQLiteOpenHelper Called when the database needs to be upgraded. The implementation should use this method to drop tables, add tables, or do anything else it needs to upgrade to the new schema version.

The SQLite ALTER TABLE documentation can be found here. If you add new columns you can use ALTER TABLE to insert them into a live table. If you rename or remove columns you can use ALTER TABLE to rename the old table, then create the new table and then populate the new table with the contents of the old table.

This method executes within a transaction. If an exception is thrown, all changes will automatically be rolled back.

Parameters:

connectionSource - Open Connection Source

oldVersion - The old database version.

newVersion - The new database version.

getCustomOpenHelperCallbacks

OpenHelperCallbacks getCustomOpenHelperCallbacks()