CLI for Uptycs platform with auto-completion and syntax highlighting.
Project description
# iusql
[![Build Status](https://travis-ci.org/dbcli/iusql.svg?branch=master)](https://travis-ci.org/dbcli/iusql)
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 iusql, using pip, you can use following command: ` $ sudo pip install iusql `
if you want to install from source you can use following command: ` $ git pull iusql $ cd iusql $ python setup.py install `
## Usage
$ iusql –help
Usage: iusql -k <uptycs key file> [DATABASE]
- Examples:
iusql -k mykeyfile [global|realtime|audit]
A config file is automatically created at ~/.config/iusql/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
Built Distribution
Hashes for iusql-2.0.4-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8351c3aafa8573f7d13ea85589a6ec1a33b93b2ba9a983b2a3dfe566f773a2d2 |
|
MD5 | c195872684ed5d40587d0051c4062fd6 |
|
BLAKE2b-256 | 76136398f8e19604f3d8e57cc30d2971553c71c4cac6ce8d9bf0fa81e11991ef |