SSH Browser (Revision #2)

Command Line SQL Shell – FluidShell

Aqua Data Studio 11.0 features FluidShell, an interactive database shell for all major database vendors. This Universal SQL Shell allows you to execute SQL statements as well as Shell commands. The local Shell commands includes a list of heavily used operations such as import, export, copy, archive, encrypt and email data. The execution of SQL commands provides flexible presentation such as formatted text output and exporting to CSV and Excel files.  

• Shell Commands: FluidShell provides an interactive shell to execute local Operating System commands such as cd, ls, pwd, cp, mv, mkdir, touch, ren, syncdir, rm and rmdir.
• Database Access Commands: FluidShell can establish a connection to a Database Server using the connect command. The reconnect command forces a reconnection to the database and you can close the connection using the disconnect command.
• SQL Commands: FluidShell can execute SQL commands such as select, insert, update, list databases, list tables, list views, commit, rollback and more.
• SQL Scripts and AquaScripts: FluidShell can also execute SQL scripts, shell scripts and AquaScripts (executed in the AquaScript Editor in Data Studio and scheduled to run in the Application Server - Aqua Data Server.)
• Archive Commands: zip, tar and gzip are the supported FluidShell commands to compress files. Other archive commands supported are unzip and gunzip to decompress.
• Network Commands: FluidShell features commands to open an SSH terminal connection and scp copies files between local host and remote host.
• Email: sendmail command sends a message to one or more recipients.
• Console Commands: Other utility commands include help, clear, echo, edit, ask, alias, open, set, source, sql-history and unalias.

What's new?

Shell Commands	Database Access	SQL Commands	SQL Scripts	Archive Commands	Network Commands	Email	Console

Database Access Commands

 Connect to a Database Server, Reconnect and Disconnect: 

In the FluidShell prompt, use the \connect command to establish connection to a RDBMS server. You can reconnect to the database server using \reconnect command and end the current transaction using the \disconnect command

 Execute command:

\exec Executes an OS command. The command takes the form \exec COMMAND [args]

 List Databases, List Schemas, List Tables, List Views:

\list displays the list of databases, schemas, tables or views defined in the connected RDBMS server. The connection to the RDBMS server needs to be established before the \list command is executed. 

 Commit a Transaction, Rollback and AutoCommit Options:

Use the FluidShell prompt to connect to a database server, execute SQL commands and commit transactions. \commit ends the current transaction and makes permanent all changes performed in the transaction. Use \rollback command to rollback the current transaction to the beginning and use \autocommit to control the current database connection's autocommit mode.  The options for this command are autocommit [on, off]. When autocommit is invoked with no arguments, it prints the current auto-commit status.

 Go command and sql-history:

\go command sends the contents of the work buffer to the database. The command \sql-history displays the SQL statement history table with the time the sql commands were executed in the FluidShell prompt. 

SQL Commands

 Select, Insert, Update and more: 

You can use the FluidShell prompt to connect to any database server and execute SQL commands such as select, insert, update and more. You can combine the SQL commands with pipeline commands and also use redirect command to output SQL commands to a file, or send a file to a command as input.

Import/Export Data

 Import data into a table and Export table data into CSV, Excel: 

The Import Data Command in the FluidShell allows data of different formats to be imported and inserted into tables. The Export Command allows data from tables to be exported in a variety of formats.

File and Directory management Commands in FluidShell

 Create a new Directory, Change Directory, List Present Working Directory and Delete Directory: 

Use the FluidShell prompt in Aqua Data Studio to execute Operating System commands -  \mkdir  [directory] command to create a new directory. \cd   [directory] changes to the directory, \pwd tells your present working directory and \rmdir  [directory] deletes a directory.

 Create a file, List your Files, Move, Copy, Rename and Remove: 

Use \touch  [filename] command in the FluidShell prompt to create a new file.The \ls command lists your files, \mv command moves your files from one directory to another, \cp copies a file, \rm deletes the file, \ren renames the file.

 Sync target and source Directories: 

You can syncronize a local target directory with files and subdirectories of source directory using \syncdir command.

Archive Commands

 Compress using zip, tar and gzip algorithms: 

FluidShell contains a collection of different algorithms to compress files.\zip command compresses and packs files into a single ZIP archive that is compatible with PKZIP. By default, packing a directory to a zipfile always implies that the subdirectories below should be included in the archive. \tar command stores/extracts files and/or directories to/from an archive file known as a tarfile. \gzip command reduces the size of named files using the GZIP algorithm. Each file is replaced by one with the extension .gz

 Uncompress archived file using unzip and gunzip: 

\unzip command extracts files from a ZIP archive to the named directory, or current directory if no directory specified. \gunzip takes a list of files and replaces each file whose name ends with .gz with an uncompressed file without the original extension

Network Commands

 Open an SSH Terminal: 

Use \ssh command in the FluidShell prompt to open an SSH terminal tab in Aqua Data Studio 11.0.

 Secure Copy Files over the Network: 

You can secure copy files over the network using the \scp command. This command copies files between the local host and a remote host. File names may contain a user and host specification to indicate that the file is to be copied to/from that host; current user is assumed if the user portion is omitted. Directory copy is done recursively by default. Copying files between remote hosts is not allowed, and, copying files on the local host is not supported.

Email Command

 Send messages to one or more recipients in FluidShell: 

Use the FluidShell prompt in Aqua Data Studio to send a message to one or more recipients -  \sendmail command has options to add attachments, bcc, cc, set message in HTML content as well as text content, set message subject, set host address and port of the SMTP server. \sendmail also has options to instruct SMTP to use SSL connection or authenctication.

Console Commands

 Help for FluidShell Commands, print, open, edit, more, clear and ask Commands: 

Use \help command in the FluidShell prompt to see a brief list of all available commands. \echo prints a line of text, \open [filename]opens the specified file, \edit opens the current work buffer for editing, \clear clears the screen and \ask allows the user to type a value directly into a variable. \more is a filter for paging through one screen at a time.

 Alias, History, Set, Source and Unalias Commands: 

You can create a new alias with the name of ALIAS_NAME and a body if ALIAS_BODY using \alias [ALIAS_NAME=ALIAS_BODY]. The command \history displays the command history. You can set the variable name to a value using the \set command. \source executes a script from a file and takes the form \source FILENAME. The \unalias command removes the alias name. 

Redirection and Pipelines

 Redirect to file and Pipelines: 

Option to use pipelines in the FluidShell prompt is another important feature of Aqua Data Studio 11.0.  A simple example of the command is select * from orders / | \more which combines the database command with the more command and displays 1 screen of rows at a time and you need to hit Enter to see the next set of rows.

It also supports the redirect command to output to a file, or send a file to a command as input.

Fonts, Copy and Paste to Clipboard, Find text in Buffer

 Options available with FluidShell Environment: 

Customize the fonts available with the FluidShell environment under Shell Options --> General -- Font. Other options available are Text Buffer Size, Statement History Size , Foreground Color, Results Color, Error Color, Background Color and Selection Background Color. Aqua Data Studio v11.0 has options in the FluidShell for the user to copy commands and paste them by selecting and then right-clicking or by selecting and clicking the copy and paste icons in the toolbar. Find in Buffer allows searching and highlighting text in the current FluidShell prompt.