Display quick view from sql databases
Project description
Quickly display (part of) a database. Thin wrapper around SQLAlchemy.
Examples:
* `catsql example.sqlite`
* `catsql postgres://foo:bar@thing.rds.amazonaws.com:5432/database`
* `catsql example.sqlite --table users`
* `catsql foo.csv --rows 'total < 1000'`
```
usage: catsql [-h] [--table [TABLE [TABLE ...]]] [--row [ROW [ROW ...]]]
[--bare] [--csv]
url
Quickly display (part of) a database.
positional arguments:
url Database url or filename. Examples: sqlite:///data.db,
mysql://user:pass@host/db,
postgres[ql]://user:pass@host/db, data.sqlite3,
data.csv
optional arguments:
-h, --help show this help message and exit
--table [TABLE [TABLE ...]]
Tables to include (defaults to all tables)
--row [ROW [ROW ...]]
Filters for rows to include. Examples: 'total < 1000',
'name = "american_bison"'. Tables that don't have the
columns mentioned are omitted.
--bare Show table and column names, skip actual data.
--csv Output strictly in CSV format.
```
Examples:
* `catsql example.sqlite`
* `catsql postgres://foo:bar@thing.rds.amazonaws.com:5432/database`
* `catsql example.sqlite --table users`
* `catsql foo.csv --rows 'total < 1000'`
```
usage: catsql [-h] [--table [TABLE [TABLE ...]]] [--row [ROW [ROW ...]]]
[--bare] [--csv]
url
Quickly display (part of) a database.
positional arguments:
url Database url or filename. Examples: sqlite:///data.db,
mysql://user:pass@host/db,
postgres[ql]://user:pass@host/db, data.sqlite3,
data.csv
optional arguments:
-h, --help show this help message and exit
--table [TABLE [TABLE ...]]
Tables to include (defaults to all tables)
--row [ROW [ROW ...]]
Filters for rows to include. Examples: 'total < 1000',
'name = "american_bison"'. Tables that don't have the
columns mentioned are omitted.
--bare Show table and column names, skip actual data.
--csv Output strictly in CSV format.
```
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
catsql-0.1.2.tar.gz
(3.6 kB
view details)
File details
Details for the file catsql-0.1.2.tar.gz
.
File metadata
- Download URL: catsql-0.1.2.tar.gz
- Upload date:
- Size: 3.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7f3096a4ec1257a3689c8405deba2647abb177ba189f4075b6a6a5719bcde063 |
|
MD5 | dc6b3698339059f359f6346263550246 |
|
BLAKE2b-256 | ddf0f8bc02fccd117f679c6fe2eb7df32f9de6d08e1af420c36d5b67e12ec373 |