Package sqlline

Class Commands

java.lang.Object
sqlline.Commands

public class Commands
extends java.lang.Object
Collection of available commands.
  • Method Details

    • 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 line
      callback - 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 line
      callback - 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 line
      callback - 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)
    • showconfconnections

      public void showconfconnections​(java.lang.String line, DispatchCallback callback)
    • rereadconfconnections

      public void rereadconfconnections​(java.lang.String line, DispatchCallback callback)
    • resize

      public void resize​(java.lang.String line, DispatchCallback callback)
    • list

      public void list​(java.lang.String line, DispatchCallback callback)
      Lists the current connections.
      Parameters:
      line - Command line
      callback - 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 line
      callback - Callback for command status
    • run

      public void run​(java.lang.String line, DispatchCallback callback)
      Runs a script from the specified file.
      Parameters:
      line - Command line
      callback - 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 line
      callback - 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)