com.ae.apps.lib.db

Class CopiedDataBaseHelper

java.lang.Object

android.database.sqlite.SQLiteOpenHelper

com.ae.apps.lib.db.CopiedDataBaseHelper

All Implemented Interfaces:

java.lang.AutoCloseable

public abstract class CopiedDataBaseHelper
extends android.database.sqlite.SQLiteOpenHelper

Boiler plate code for a Database file that is copied from the assets folder

Constructor Summary

Constructors

Constructor and Description
CopiedDataBaseHelper(android.content.Context context, java.lang.String databaseName, android.database.sqlite.SQLiteDatabase.CursorFactory factory, int version) Required constructor

Method Summary

Modifier and Type	Method and Description
protected boolean	checkDataBase() Check if the database already exist to avoid re-copying the file each time you open the application.
void	close() close the database
protected void	copyDataBase() Copies your database from your local assets-folder to the just created empty database in the system folder, from where it can be accessed and handled.
void	createDataBase() Creates the database
void	onCreate(android.database.sqlite.SQLiteDatabase arg0) Invoked onCreate
void	onUpgrade(android.database.sqlite.SQLiteDatabase db, int oldVersion, int newVersion) called on database upgrade
void	openDataBase() Opens the database
protected android.database.Cursor	query(java.lang.String table, java.lang.String[] columns, java.lang.String selection, java.lang.String[] selectionArgs, java.lang.String groupBy, java.lang.String having, java.lang.String orderBy) Runs a query on the real database

Methods inherited from class android.database.sqlite.SQLiteOpenHelper

getDatabaseName, getReadableDatabase, getWritableDatabase, onConfigure, onDowngrade, onOpen, setIdleConnectionTimeout, setLookasideConfig, setOpenParams, setWriteAheadLoggingEnabled

Methods inherited from class java.lang.Object

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

Constructor Detail

CopiedDataBaseHelper

public CopiedDataBaseHelper(android.content.Context context,
                            java.lang.String databaseName,
                            android.database.sqlite.SQLiteDatabase.CursorFactory factory,
                            int version)

Required constructor

Parameters:

context - context

databaseName - database name

factory - cursor factory

version - database version

Method Detail

createDataBase

public void createDataBase()

Creates the database

checkDataBase

protected boolean checkDataBase()

Check if the database already exist to avoid re-copying the file each time you open the application.

Returns:

true if it exists, false if it doesn't

copyDataBase

protected void copyDataBase()
                     throws java.io.IOException

Copies your database from your local assets-folder to the just created empty database in the system folder, from where it can be accessed and handled. This is done by transferring byte stream.

Throws:

java.io.IOException

openDataBase

public void openDataBase()
                  throws android.database.SQLException

Opens the database

Throws:

android.database.SQLException - while opening the database

close

public void close()

close the database

Specified by:

close in interface java.lang.AutoCloseable

Overrides:

close in class android.database.sqlite.SQLiteOpenHelper

onCreate

public void onCreate(android.database.sqlite.SQLiteDatabase arg0)

Invoked onCreate

Specified by:

onCreate in class android.database.sqlite.SQLiteOpenHelper

Parameters:

arg0 - database

onUpgrade

public void onUpgrade(android.database.sqlite.SQLiteDatabase db,
                      int oldVersion,
                      int newVersion)

called on database upgrade

Specified by:

onUpgrade in class android.database.sqlite.SQLiteOpenHelper

Parameters:

db - database

oldVersion - oldversion

newVersion - newversion

query

protected android.database.Cursor query(java.lang.String table,
                                        java.lang.String[] columns,
                                        java.lang.String selection,
                                        java.lang.String[] selectionArgs,
                                        java.lang.String groupBy,
                                        java.lang.String having,
                                        java.lang.String orderBy)

Runs a query on the real database

Parameters:

table - table name

columns - columns

selection - selection

selectionArgs - selectionargs

groupBy - groupby

having - having clause

orderBy - orderby

Returns:

cursor