Package sqlline
Class Commands
- java.lang.Object
-
- sqlline.Commands
-
public class Commands extends java.lang.Object
Collection of available commands.
-
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description void
all(java.lang.String line, DispatchCallback callback)
void
appconfig(java.lang.String line, DispatchCallback callback)
void
autocommit(java.lang.String line, DispatchCallback callback)
void
batch(java.lang.String line, DispatchCallback callback)
void
brief(java.lang.String line, DispatchCallback callback)
void
call(java.lang.String line, DispatchCallback callback)
void
close(java.lang.String line, DispatchCallback callback)
Closes the current connection.void
closeall(java.lang.String line, DispatchCallback callback)
Closes all connections.void
columns(java.lang.String line, DispatchCallback callback)
void
commandhandler(java.lang.String line, DispatchCallback callback)
void
commit(java.lang.String line, DispatchCallback callback)
void
config(java.lang.String line, DispatchCallback callback)
void
connect(java.lang.String line, DispatchCallback callback)
void
connect(java.util.Properties props, DispatchCallback callback)
void
dbinfo(java.lang.String line, DispatchCallback callback)
void
describe(java.lang.String line, DispatchCallback callback)
void
dropall(java.lang.String line, DispatchCallback callback)
static java.lang.String
expand(java.lang.String filename)
Expands "~" to the home directory.void
exportedkeys(java.lang.String line, DispatchCallback callback)
void
go(java.lang.String line, DispatchCallback callback)
void
help(java.lang.String line, DispatchCallback callback)
void
history(java.lang.String line, DispatchCallback callback)
void
importedkeys(java.lang.String line, DispatchCallback callback)
void
indexes(java.lang.String line, DispatchCallback callback)
void
isolation(java.lang.String line, DispatchCallback callback)
void
list(java.lang.String line, DispatchCallback callback)
Lists the current connections.void
load(java.lang.String line, DispatchCallback callback)
void
manual(java.lang.String line, DispatchCallback callback)
void
metadata(java.lang.String cmd, java.util.List<java.lang.Object> argList, DispatchCallback callback)
void
metadata(java.lang.String line, DispatchCallback callback)
void
nativesql(java.lang.String sql, DispatchCallback callback)
void
nickname(java.lang.String line, DispatchCallback callback)
void
outputformat(java.lang.String line, DispatchCallback callback)
void
primarykeys(java.lang.String line, DispatchCallback callback)
void
procedures(java.lang.String line, DispatchCallback callback)
void
prompthandler(java.lang.String line, DispatchCallback callback)
void
properties(java.lang.String line, DispatchCallback callback)
Connects to the database defined in the specified properties file.void
quit(java.lang.String line, DispatchCallback callback)
void
readonly(java.lang.String line, DispatchCallback callback)
void
reconnect(java.lang.String line, DispatchCallback callback)
void
record(java.lang.String line, DispatchCallback callback)
Starts or stops saving all output to a file.void
rehash(java.lang.String line, DispatchCallback callback)
void
rerun(java.lang.String line, DispatchCallback callback)
void
reset(java.lang.String line, DispatchCallback callback)
void
rollback(java.lang.String line, DispatchCallback callback)
void
run(java.lang.String line, DispatchCallback callback)
Runs a script from the specified file.void
save(java.lang.String line, DispatchCallback callback)
void
scan(java.lang.String line, DispatchCallback callback)
void
schemas(java.lang.String line, DispatchCallback callback)
void
script(java.lang.String line, DispatchCallback callback)
Starts or stops saving a script to a file.void
set(java.lang.String line, DispatchCallback callback)
void
sql(java.lang.String line, DispatchCallback callback)
void
tables(java.lang.String line, DispatchCallback callback)
void
typeinfo(java.lang.String line, DispatchCallback callback)
void
verbose(java.lang.String line, DispatchCallback callback)
-
-
-
Method Detail
-
metadata
public void metadata(java.lang.String line, DispatchCallback callback)
-
metadata
public void metadata(java.lang.String cmd, java.util.List<java.lang.Object> argList, DispatchCallback callback)
-
history
public void history(java.lang.String line, DispatchCallback callback)
-
rerun
public void rerun(java.lang.String line, DispatchCallback callback)
-
indexes
public void indexes(java.lang.String line, DispatchCallback callback) throws java.lang.Exception
- Throws:
java.lang.Exception
-
primarykeys
public void primarykeys(java.lang.String line, DispatchCallback callback) throws java.lang.Exception
- Throws:
java.lang.Exception
-
exportedkeys
public void exportedkeys(java.lang.String line, DispatchCallback callback) throws java.lang.Exception
- Throws:
java.lang.Exception
-
importedkeys
public void importedkeys(java.lang.String line, DispatchCallback callback) throws java.lang.Exception
- Throws:
java.lang.Exception
-
procedures
public void procedures(java.lang.String line, DispatchCallback callback) throws java.lang.Exception
- Throws:
java.lang.Exception
-
tables
public void tables(java.lang.String line, DispatchCallback callback) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
schemas
public void schemas(java.lang.String line, DispatchCallback callback)
-
typeinfo
public void typeinfo(java.lang.String line, DispatchCallback callback)
-
nativesql
public void nativesql(java.lang.String sql, DispatchCallback callback) throws java.lang.Exception
- Throws:
java.lang.Exception
-
columns
public void columns(java.lang.String line, DispatchCallback callback) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
dropall
public void dropall(java.lang.String line, DispatchCallback callback)
-
reconnect
public void reconnect(java.lang.String line, DispatchCallback callback)
-
scan
public void scan(java.lang.String line, DispatchCallback callback)
-
save
public void save(java.lang.String line, DispatchCallback callback) throws java.io.IOException
- Throws:
java.io.IOException
-
load
public void load(java.lang.String line, DispatchCallback callback) throws java.io.IOException
- Throws:
java.io.IOException
-
config
public void config(java.lang.String line, DispatchCallback callback)
-
set
public void set(java.lang.String line, DispatchCallback callback)
-
reset
public void reset(java.lang.String line, DispatchCallback callback)
-
commit
public void commit(java.lang.String line, DispatchCallback callback)
-
rollback
public void rollback(java.lang.String line, DispatchCallback callback)
-
autocommit
public void autocommit(java.lang.String line, DispatchCallback callback) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
readonly
public void readonly(java.lang.String line, DispatchCallback callback) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
dbinfo
public void dbinfo(java.lang.String line, DispatchCallback callback)
-
verbose
public void verbose(java.lang.String line, DispatchCallback callback)
-
outputformat
public void outputformat(java.lang.String line, DispatchCallback callback)
-
brief
public void brief(java.lang.String line, DispatchCallback callback)
-
isolation
public void isolation(java.lang.String line, DispatchCallback callback) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
batch
public void batch(java.lang.String line, DispatchCallback callback)
-
sql
public void sql(java.lang.String line, DispatchCallback callback)
-
call
public void call(java.lang.String line, DispatchCallback callback)
-
quit
public void quit(java.lang.String line, DispatchCallback callback)
-
closeall
public void closeall(java.lang.String line, DispatchCallback callback)
Closes all connections.- Parameters:
line
- Command linecallback
- Callback for command status
-
close
public void close(java.lang.String line, DispatchCallback callback)
Closes the current connection. Closes the current file writer.- Parameters:
line
- Command linecallback
- Callback for command status
-
properties
public void properties(java.lang.String line, DispatchCallback callback) throws java.lang.Exception
Connects to the database defined in the specified properties file.- Parameters:
line
- Command linecallback
- Callback for command status- Throws:
java.lang.Exception
- on error
-
connect
public void connect(java.lang.String line, DispatchCallback callback)
-
nickname
public void nickname(java.lang.String line, DispatchCallback callback)
-
connect
public void connect(java.util.Properties props, DispatchCallback callback)
-
rehash
public void rehash(java.lang.String line, DispatchCallback callback)
-
list
public void list(java.lang.String line, DispatchCallback callback)
Lists the current connections.- Parameters:
line
- Command linecallback
- Callback for command status
-
all
public void all(java.lang.String line, DispatchCallback callback)
-
go
public void go(java.lang.String line, DispatchCallback callback)
-
script
public void script(java.lang.String line, DispatchCallback callback)
Starts or stops saving a script to a file.- Parameters:
line
- Command linecallback
- Callback for command status
-
run
public void run(java.lang.String line, DispatchCallback callback)
Runs a script from the specified file.- Parameters:
line
- Command linecallback
- Callback for command status
-
expand
public static java.lang.String expand(java.lang.String filename)
Expands "~" to the home directory.- Parameters:
filename
- File name- Returns:
- Expanded file name
-
record
public void record(java.lang.String line, DispatchCallback callback)
Starts or stops saving all output to a file.- Parameters:
line
- Command linecallback
- Callback for command status
-
commandhandler
public void commandhandler(java.lang.String line, DispatchCallback callback)
-
describe
public void describe(java.lang.String line, DispatchCallback callback) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
help
public void help(java.lang.String line, DispatchCallback callback)
-
manual
public void manual(java.lang.String line, DispatchCallback callback) throws java.io.IOException
- Throws:
java.io.IOException
-
appconfig
public void appconfig(java.lang.String line, DispatchCallback callback)
-
prompthandler
public void prompthandler(java.lang.String line, DispatchCallback callback)
-
-