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 interface	SQLiteUpdateTaskHelper.OnResultListener
static class	SQLiteUpdateTaskHelper.QueryType

Constructor Summary

Constructors

Constructor and Description
SQLiteUpdateTaskHelper()

Method Summary

Modifier and Type	Method and Description
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, android.content.Context context, int rawResourceId)
static void	executeSQL(android.database.sqlite.SQLiteDatabase database, InputStream fileInputStream)
static void	executeSQL(android.database.sqlite.SQLiteDatabase database, List<String> commands)
static void	executeSQL(android.database.sqlite.SQLiteDatabase database, String command)
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

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:

executeSQL

public static void executeSQL(android.database.sqlite.SQLiteDatabase database,
                              android.content.Context context,
                              int rawResourceId)

readSQLFromFile

public static List<String> readSQLFromFile(String fileName)

readSQLFromFile

public static List<String> readSQLFromFile(InputStream fileInputStream)

executeSQL

public static void executeSQL(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)