jsqlite

Class SQLDump

java.lang.Object

jsqlite.SQLDump

All Implemented Interfaces:

Callback

public class SQLDump
extends Object
implements Callback

SQLite SQL dump utility.

Constructor Summary

Constructors

Constructor and Description
SQLDump(PrintStream ps, Database db)
SQLDump(PrintWriter pw, Database db)

Method Summary

Methods

Modifier and Type	Method and Description
void	columns(String[] col) Reports column names of the query result.
void	dump()
boolean	newrow(String[] args) Reports row data of the query result.
void	types(String[] args) Reports type names of the columns of the query result.

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLDump

public SQLDump(PrintWriter pw,
       Database db)

SQLDump

public SQLDump(PrintStream ps,
       Database db)

Method Detail

dump

public void dump()
          throws Exception

Throws:

Exception

columns

public void columns(String[] col)

Description copied from interface: Callback

Reports column names of the query result. This method is invoked first (and once) when the SQLite engine returns the result set.

Specified by:

columns in interface Callback

Parameters:

col - string array holding the column names

types

public void types(String[] args)

Description copied from interface: Callback

Reports type names of the columns of the query result. This is available from SQLite 2.6.0 on and needs the PRAGMA show_datatypes to be turned on.

Specified by:

types in interface Callback

Parameters:

args - string array holding column types

newrow

public boolean newrow(String[] args)

Description copied from interface: Callback

Reports row data of the query result. This method is invoked for each row of the result set. If true is returned the running SQLite query is aborted.

Specified by:

newrow in interface Callback

Parameters:

args - string array holding the column values of the row