greptable 1.1.0

Description

greptable generates a plain-text list of your servers, databases and tables, so that you can easily find where the fuck that table is, with your favorite search tools, like grep.

This is especially useful if you are dealing with many servers and databases.

Requirements

greptable works on both Python 2 and Python 3.

The only dependency is SQLAlchemy, and it should support the same databases.

Usage

For global options run greptable -h.

All commands need a configuration file; see the Configuration section below.

Configuration

The configuration is a standard INI file. Section headers are SQLAlchemy URLs.

For example:

[mysql://user:password@server1]
[sqlite:///db.sqlite]

greptable will try to prettify server URLs, but you can also force a name.

For example:

[mysql://user:password@server1]
[sqlite:///db.sqlite]
name = db

For the open subcommand, you can provide both a openschema and opentable option. If the openschema option is not provided, opentable will be used, with the table parameter being an empty string.

The variable substitution uses the Python format() syntax.

For example:

[mysql://user:password@server1]
opentable = https://penguincorp.com/pma/index.php?server=0&db={schema}&table={table}

[mysql://user:password@server2]
opentable = https://penguincorp.com/pma/index.php?server=1&db={schema}&table={table}

[otherdb://user:password@server]
name = srv0
openschema = https://penguincorp.com/otherdb/{server}/tables/{schema}
opentable = https://penguincorp.com/otherdb/{server}/showtable/{schema}/{table}

Development

Contributions can be sent in the form of git patches, to laurent@bachelier.name.