com.abubusoft.kripton.android.sqlite

Class SQLiteUpdateTaskHelper

java.lang.Object

com.abubusoft.kripton.android.sqlite.SQLiteUpdateTaskHelper

public abstract class SQLiteUpdateTaskHelper
extends Object

Author:

Francesco Benincasa (info@abubusoft.com)

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SQLiteUpdateTaskHelper.QueryType

Constructor Summary

Constructors

Constructor and Description
SQLiteUpdateTaskHelper()

Method Summary

Modifier and Type	Method and Description
static <E extends AbstractDataSource> void	clearDatabase(E dataSource)
static void	dropTablesAndIndices(android.database.sqlite.SQLiteDatabase db)
static void	dropTablesWithPrefix(android.database.sqlite.SQLiteDatabase db, String prefix) Drop all table with specific prefix
static void	executeSQL(android.database.sqlite.SQLiteDatabase database, List<String> commands)
static void	executeSQL(android.database.sqlite.SQLiteDatabase database, String command)
static void	executeSQLFromFile(android.database.sqlite.SQLiteDatabase database, InputStream fileInputStream)
static void	executeSQLFromFile(android.database.sqlite.SQLiteDatabase database, String fileName)
static void	executeSQLFromResourceId(android.database.sqlite.SQLiteDatabase database, int resourceId)
static <E extends AbstractDataSource> void	forceSchemaUpdate(E dataSource, int version) Force a schema update for a datasource.
static Map<String,String>	getAllIndexes(android.database.sqlite.SQLiteDatabase db) Retrieve all indexes as a Map of
static Map<String,String>	getAllTables(android.database.sqlite.SQLiteDatabase db) Retrieve all table as a Map of
static List<String>	readSQLFromFile(InputStream fileInputStream)
static List<String>	readSQLFromFile(String fileName)
static void	renameTablesWithPrefix(android.database.sqlite.SQLiteDatabase db, String prefix) Add to all table a specifix prefix
static <H extends AbstractDataSource> void	verifySchema(H dataSource, File fileSchema)
static <H extends AbstractDataSource> void	verifySchema(H dataSource, InputStream fileSchemaInputStream)
static <H extends AbstractDataSource> void	verifySchema(H dataSource, String fileNameSchema)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLiteUpdateTaskHelper

public SQLiteUpdateTaskHelper()

Method Detail

getAllTables

public static Map<String,String> getAllTables(android.database.sqlite.SQLiteDatabase db)

Retrieve all table as a Map of

Parameters:

db -

Returns:

renameTablesWithPrefix

public static void renameTablesWithPrefix(android.database.sqlite.SQLiteDatabase db,
                                          String prefix)

Add to all table a specifix prefix

Parameters:

db -

prefix -

dropTablesWithPrefix

public static void dropTablesWithPrefix(android.database.sqlite.SQLiteDatabase db,
                                        String prefix)

Drop all table with specific prefix

Parameters:

db -

prefix -

dropTablesAndIndices

public static void dropTablesAndIndices(android.database.sqlite.SQLiteDatabase db)

getAllIndexes

public static Map<String,String> getAllIndexes(android.database.sqlite.SQLiteDatabase db)

Retrieve all indexes as a Map of

Parameters:

db -

Returns:

executeSQLFromResourceId

public static void executeSQLFromResourceId(android.database.sqlite.SQLiteDatabase database,
                                            int resourceId)

executeSQLFromFile

public static void executeSQLFromFile(android.database.sqlite.SQLiteDatabase database,
                                      String fileName)

readSQLFromFile

public static List<String> readSQLFromFile(String fileName)

readSQLFromFile

public static List<String> readSQLFromFile(InputStream fileInputStream)

executeSQLFromFile

public static void executeSQLFromFile(android.database.sqlite.SQLiteDatabase database,
                                      InputStream fileInputStream)

executeSQL

public static void executeSQL(android.database.sqlite.SQLiteDatabase database,
                              List<String> commands)

executeSQL

public static void executeSQL(android.database.sqlite.SQLiteDatabase database,
                              String command)

verifySchema

public static <H extends AbstractDataSource> void verifySchema(H dataSource,
                                                               String fileNameSchema)

verifySchema

public static <H extends AbstractDataSource> void verifySchema(H dataSource,
                                                               File fileSchema)

verifySchema

public static <H extends AbstractDataSource> void verifySchema(H dataSource,
                                                               InputStream fileSchemaInputStream)

forceSchemaUpdate

public static <E extends AbstractDataSource> void forceSchemaUpdate(E dataSource,
                                                                    int version)

Force a schema update for a datasource. Note that no DDL was execute untill the database was opened.

Parameters:

dataSource -

version - to upgrade.

clearDatabase

public static <E extends AbstractDataSource> void clearDatabase(E dataSource)