Package sqlline
Class Commands
java.lang.Object
sqlline.Commands
public class Commands
extends java.lang.Object
Collection of available commands.
-
Method Summary
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
rereadconfconnections(java.lang.String line, DispatchCallback callback)
void
rerun(java.lang.String line, DispatchCallback callback)
void
reset(java.lang.String line, DispatchCallback callback)
void
resize(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
showconfconnections(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 Details
-
metadata
-
metadata
public void metadata(java.lang.String cmd, java.util.List<java.lang.Object> argList, DispatchCallback callback) -
history
-
rerun
-
indexes
- 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
- Throws:
java.sql.SQLException
-
schemas
-
typeinfo
-
nativesql
- Throws:
java.lang.Exception
-
columns
- Throws:
java.sql.SQLException
-
dropall
-
reconnect
-
scan
-
save
- Throws:
java.io.IOException
-
load
- Throws:
java.io.IOException
-
config
-
set
-
reset
-
commit
-
rollback
-
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
-
verbose
-
outputformat
-
brief
-
isolation
public void isolation(java.lang.String line, DispatchCallback callback) throws java.sql.SQLException- Throws:
java.sql.SQLException
-
batch
-
sql
-
call
-
quit
-
closeall
Closes all connections.- Parameters:
line
- Command linecallback
- Callback for command status
-
close
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.ExceptionConnects to the database defined in the specified properties file.- Parameters:
line
- Command linecallback
- Callback for command status- Throws:
java.lang.Exception
- on error
-
connect
-
nickname
-
connect
-
rehash
-
showconfconnections
-
rereadconfconnections
-
resize
-
list
Lists the current connections.- Parameters:
line
- Command linecallback
- Callback for command status
-
all
-
go
-
script
Starts or stops saving a script to a file.- Parameters:
line
- Command linecallback
- Callback for command status
-
run
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
Starts or stops saving all output to a file.- Parameters:
line
- Command linecallback
- Callback for command status
-
commandhandler
-
describe
public void describe(java.lang.String line, DispatchCallback callback) throws java.sql.SQLException- Throws:
java.sql.SQLException
-
help
-
manual
- Throws:
java.io.IOException
-
appconfig
-
prompthandler
-