Skip to main content

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.
```

Project details


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)

Uploaded Source

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

Hashes for catsql-0.1.3.tar.gz
Algorithm Hash digest
SHA256 ee4bd86be8b6cf638618c5a1834884395d7e9154c14e90fedda168d0578cc997
MD5 d33b70be490e3ab2eabdb8b7e891a96a
BLAKE2b-256 4710da8d99f6575ebb5bcaa2ad2734bd7d65b3784451745ef87ee3906b2c0e71

See more details on using hashes here.

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