Skip to main content

CLI for Uptycs platform with auto-completion and syntax highlighting.

Project description

usql

Build Status

A command-line client for Uptycs that has auto-completion and syntax highlighting. This tool is based on dbcli frame work. We have used Uptycs restcall in the tool

Installation

If you already know how to install python packages, then you can install it via pip:

You might need sudo on linux.

if you want to install usql, using pip, you can use following command:

$ sudo pip install usql

if you want to install from source you can use following command:

$ git pull usql
$ cd usql
$ python setup.py install

Usage

$ usql --help

Usage: usql -k <uptycs key file> [DATABASE]

Examples:
  - usql -k mykeyfile [global|realtime|timemachine]

A config file is automatically created at ~/.config/usql/config at first launch. See the file itself for a description of all available options.

Following are the options available through the tool

+-------------+----------------------------+------------------------------------------------------------+
| Command     | Shortcut                   | Description                                                |
+-------------+----------------------------+------------------------------------------------------------+
| .databases  | .databases                 | List databases.                                            |
| .open       | .open                      | Change to a new database.                                  |
| .schema     | .schema[+] [table]         | The complete schema for the database or a single table     |
| .status     | \s                         | Show current settings.                                     |
| .tables     | \dt[+] [table]             | List or describe tables.                                   |
| \G          | \G                         | Display current query results vertically.                  |
| \e          | \e                         | Edit command with editor (uses $EDITOR).                   |
| \f          | \f [name [args..]]         | List or execute favorite queries.                          |
| \fd         | \fd [name]                 | Delete a favorite query.                                   |
| \fs         | \fs name query             | Save a favorite query.                                     |
| \once       | \o [-o] filename           | Append next result to an output file (overwrite using -o). |
| exit        | \q                         | Exit.                                                      |
| help        | \?                         | Show this help.                                            |
| nopager     | \n                         | Disable pager, print to stdout.                            |
| notee       | notee                      | Stop writing results to an output file.                    |
| pager       | \P [command]               | Set PAGER. Print the query results via PAGER.              |
| prompt      | \R                         | Change prompt format.                                      |
| quit        | \q                         | Quit.                                                      |
| rehash      | \#                         | Refresh auto-completions.                                  |
| source      | \. filename                | Execute commands from file.                                |
| system      | system [command]           | Execute a system shell commmand.                           |
| tableformat | \T                         | Change the table format used to output results.            |
| tee         | tee [-o] filename          | Append all results to an output file (overwrite using -o). |
| watch       | watch [seconds] [-c] query | Executes the query every [seconds] seconds (by default 5). |
+-------------+----------------------------+------------------------------------------------------------+

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

usql-2.1.0-py2.py3-none-any.whl (95.8 kB view hashes)

Uploaded Python 2 Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page