Python tools for DBAs with deadlines!
Project description
pydba - a handy Python library for common database admin operations.
API Usage
Basic imports and class constructor usage.
>>> from pydba import PostgresDB >>> db = PostgresDB() >>> db.available() True >>> db.names() ['postgres']
Database creation and deletion.
>>> db.create('foo') >>> db.names() ['postgres', 'foo'] >>> db.rename('foo', 'bar') >>> db.names() ['postgres', 'bar']
Database backup and restore.
>>> db.dump('bar', 'bar.backup') >>> db.drop('bar') >>> db.names() ['postgres'] >>> db.restore('bar', 'bar.backup') >>> db.names() ['postgres', 'bar']
Querying and removing shutting down database connections.
>>> db.connections('postgres') [{'datname': 'postgres', 'state': 'idle', 'pid': 8937, 'psql', 'query': '', 'usename': 'drkjam', ...}] >>> db.kill_connections('postgres') >>> db.connections('postgres') []
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
pydba-1.0.0.zip
(7.6 kB
view hashes)
pydba-1.0.0.tar.gz
(4.4 kB
view hashes)
Built Distribution
Close
Hashes for pydba-1.0.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c472015fbe7dd59e302b85768a77e69d8e906e7b25a2266e22cc986987180197 |
|
MD5 | 60541d3e01fad615da339a7fa1644e87 |
|
BLAKE2b-256 | d512c07ad6e574ff91a88380963336f48aeff7664c7b218496b98a6c43b17ce2 |