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.2.tar.gz (3.6 kB view details)

Uploaded Source

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

Hashes for catsql-0.1.2.tar.gz
Algorithm Hash digest
SHA256 7f3096a4ec1257a3689c8405deba2647abb177ba189f4075b6a6a5719bcde063
MD5 dc6b3698339059f359f6346263550246
BLAKE2b-256 ddf0f8bc02fccd117f679c6fe2eb7df32f9de6d08e1af420c36d5b67e12ec373

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