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.3.tar.gz
(3.6 kB
view details)
File details
Details for the file catsql-0.1.3.tar.gz
.
File metadata
- Download URL: catsql-0.1.3.tar.gz
- Upload date:
- Size: 3.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | ee4bd86be8b6cf638618c5a1834884395d7e9154c14e90fedda168d0578cc997 |
|
MD5 | d33b70be490e3ab2eabdb8b7e891a96a |
|
BLAKE2b-256 | 4710da8d99f6575ebb5bcaa2ad2734bd7d65b3784451745ef87ee3906b2c0e71 |