Package sqlline

Class Commands


  • public class Commands
    extends java.lang.Object
    Collection of available commands.
    • 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)
      • 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)
      • 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)
      • list

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