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 voidall(java.lang.String line, DispatchCallback callback)voidappconfig(java.lang.String line, DispatchCallback callback)voidautocommit(java.lang.String line, DispatchCallback callback)voidbatch(java.lang.String line, DispatchCallback callback)voidbrief(java.lang.String line, DispatchCallback callback)voidcall(java.lang.String line, DispatchCallback callback)voidclose(java.lang.String line, DispatchCallback callback)Closes the current connection.voidcloseall(java.lang.String line, DispatchCallback callback)Closes all connections.voidcolumns(java.lang.String line, DispatchCallback callback)voidcommandhandler(java.lang.String line, DispatchCallback callback)voidcommit(java.lang.String line, DispatchCallback callback)voidconfig(java.lang.String line, DispatchCallback callback)voidconnect(java.lang.String line, DispatchCallback callback)voidconnect(java.util.Properties props, DispatchCallback callback)voiddbinfo(java.lang.String line, DispatchCallback callback)voiddescribe(java.lang.String line, DispatchCallback callback)voiddropall(java.lang.String line, DispatchCallback callback)static java.lang.Stringexpand(java.lang.String filename)Expands "~" to the home directory.voidexportedkeys(java.lang.String line, DispatchCallback callback)voidgo(java.lang.String line, DispatchCallback callback)voidhelp(java.lang.String line, DispatchCallback callback)voidhistory(java.lang.String line, DispatchCallback callback)voidimportedkeys(java.lang.String line, DispatchCallback callback)voidindexes(java.lang.String line, DispatchCallback callback)voidisolation(java.lang.String line, DispatchCallback callback)voidlist(java.lang.String line, DispatchCallback callback)Lists the current connections.voidload(java.lang.String line, DispatchCallback callback)voidmanual(java.lang.String line, DispatchCallback callback)voidmetadata(java.lang.String cmd, java.util.List<java.lang.Object> argList, DispatchCallback callback)voidmetadata(java.lang.String line, DispatchCallback callback)voidnativesql(java.lang.String sql, DispatchCallback callback)voidnickname(java.lang.String line, DispatchCallback callback)voidoutputformat(java.lang.String line, DispatchCallback callback)voidprimarykeys(java.lang.String line, DispatchCallback callback)voidprocedures(java.lang.String line, DispatchCallback callback)voidprompthandler(java.lang.String line, DispatchCallback callback)voidproperties(java.lang.String line, DispatchCallback callback)Connects to the database defined in the specified properties file.voidquit(java.lang.String line, DispatchCallback callback)voidreadonly(java.lang.String line, DispatchCallback callback)voidreconnect(java.lang.String line, DispatchCallback callback)voidrecord(java.lang.String line, DispatchCallback callback)Starts or stops saving all output to a file.voidrehash(java.lang.String line, DispatchCallback callback)voidrereadconfconnections(java.lang.String line, DispatchCallback callback)voidrerun(java.lang.String line, DispatchCallback callback)voidreset(java.lang.String line, DispatchCallback callback)voidresize(java.lang.String line, DispatchCallback callback)voidrollback(java.lang.String line, DispatchCallback callback)voidrun(java.lang.String line, DispatchCallback callback)Runs a script from the specified file.voidsave(java.lang.String line, DispatchCallback callback)voidscan(java.lang.String line, DispatchCallback callback)voidschemas(java.lang.String line, DispatchCallback callback)voidscript(java.lang.String line, DispatchCallback callback)Starts or stops saving a script to a file.voidset(java.lang.String line, DispatchCallback callback)voidshowconfconnections(java.lang.String line, DispatchCallback callback)voidsql(java.lang.String line, DispatchCallback callback)voidtables(java.lang.String line, DispatchCallback callback)voidtypeinfo(java.lang.String line, DispatchCallback callback)voidverbose(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
-