jsqlite

Class Shell

java.lang.Object

jsqlite.Shell

All Implemented Interfaces:

Callback

public class Shell
extends Object
implements Callback

SQLite command line shell. This is a partial reimplementaion of sqlite/src/shell.c and can be invoked by:

java SQLite.Shell [OPTIONS] database [SHELLCMD] or java -jar sqlite.jar [OPTIONS] database [SHELLCMD]

Constructor Summary

Constructors

Constructor and Description
Shell(PrintStream ps, PrintStream errs)
Shell(PrintWriter pw, PrintWriter err)

Method Summary

Methods

Modifier and Type	Method and Description
protected Object	clone()
void	columns(String[] args) Reports column names of the query result.
static void	main(String[] args)
boolean	newrow(String[] args) Reports row data of the query result.
static String	sql_quote_dbl(String str)
static String	sql_quote(String str)
void	types(String[] args) Reports type names of the columns of the query result.

Methods inherited from class java.lang.Object

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

Constructor Detail

Shell

public Shell(PrintWriter pw,
     PrintWriter err)

Shell

public Shell(PrintStream ps,
     PrintStream errs)

Method Detail

clone

protected Object clone()

Overrides:

clone in class Object

sql_quote_dbl

public static String sql_quote_dbl(String str)

sql_quote

public static String sql_quote(String str)

columns

public void columns(String[] args)

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:

args - 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

main

public static void main(String[] args)