de.greenrobot.dao

Class DbUtils

java.lang.Object

de.greenrobot.dao.DbUtils

public class DbUtils
extends java.lang.Object

Database utils, for example to execute SQL scripts

Constructor Summary

Constructors

Constructor and Description
DbUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static int	copyAllBytes(java.io.InputStream in, java.io.OutputStream out) Copies all available data from in to out without closing any stream.
static int	executeSqlScript(android.content.Context context, android.database.sqlite.SQLiteDatabase db, java.lang.String assetFilename) Calls executeSqlScript(Context, SQLiteDatabase, String, boolean) with transactional set to true.
static int	executeSqlScript(android.content.Context context, android.database.sqlite.SQLiteDatabase db, java.lang.String assetFilename, boolean transactional) Executes the given SQL asset in the given database (SQL file should be UTF-8).
static int	executeSqlStatements(android.database.sqlite.SQLiteDatabase db, java.lang.String[] statements)
static int	executeSqlStatementsInTx(android.database.sqlite.SQLiteDatabase db, java.lang.String[] statements)
static void	logTableDump(android.database.sqlite.SQLiteDatabase db, java.lang.String tablename)
static byte[]	readAllBytes(java.io.InputStream in)
static byte[]	readAsset(android.content.Context context, java.lang.String filename)
static void	vacuum(android.database.sqlite.SQLiteDatabase db)

Methods inherited from class java.lang.Object

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

Constructor Detail

DbUtils

public DbUtils()

Method Detail

vacuum

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

executeSqlScript

public static int executeSqlScript(android.content.Context context,
                   android.database.sqlite.SQLiteDatabase db,
                   java.lang.String assetFilename)
                            throws java.io.IOException

Calls executeSqlScript(Context, SQLiteDatabase, String, boolean) with transactional set to true.

Returns:

number of statements executed.

Throws:

java.io.IOException

executeSqlScript

public static int executeSqlScript(android.content.Context context,
                   android.database.sqlite.SQLiteDatabase db,
                   java.lang.String assetFilename,
                   boolean transactional)
                            throws java.io.IOException

Executes the given SQL asset in the given database (SQL file should be UTF-8). The database file may contain multiple SQL statements. Statements are split using a simple regular expression (something like "semicolon before a line break"), not by analyzing the SQL syntax. This will work for many SQL files, but check yours.

Returns:

number of statements executed.

Throws:

java.io.IOException

executeSqlStatementsInTx

public static int executeSqlStatementsInTx(android.database.sqlite.SQLiteDatabase db,
                           java.lang.String[] statements)

executeSqlStatements

public static int executeSqlStatements(android.database.sqlite.SQLiteDatabase db,
                       java.lang.String[] statements)

copyAllBytes

public static int copyAllBytes(java.io.InputStream in,
               java.io.OutputStream out)
                        throws java.io.IOException

Copies all available data from in to out without closing any stream.

Returns:

number of bytes copied

Throws:

java.io.IOException

readAllBytes

public static byte[] readAllBytes(java.io.InputStream in)
                           throws java.io.IOException

Throws:

java.io.IOException

readAsset

public static byte[] readAsset(android.content.Context context,
               java.lang.String filename)
                        throws java.io.IOException

Throws:

java.io.IOException

logTableDump

public static void logTableDump(android.database.sqlite.SQLiteDatabase db,
                java.lang.String tablename)