schemainspect: SQL Schema Inspection
Schema inspection for PostgreSQL (and potentially others in the future).
Inspects tables, views, materialized views, constraints, indexes, sequences, enums, functions, and extensions. Handles table partitioning and inheritance.
Limitations: Function inspection only confirmed to work with SQL/PLPGSQL languages so far.
Basic Usage
Get an inspection object from an already opened SQLAlchemy session or connection as follows:
from schemainspect import get_inspector
from sqlbag import S
with S('postgresql:///example') as s:
i = get_inspector(s)
The inspection object has attributes for tables, views, and all the other things it tracks. At each of these attributes you'll find a dictionary (OrderedDict) mapping from fully-qualified-and-quoted-name-of-thing-in-database to information object.
For instance, the information about a table books would be accessed as follows:
>>> books_table = i.tables['"public"."books"']
>>> books_table.name
'books'
>>> books_table.schema
'public'
>>> [each.name for each in books_table.columns]
['id', 'title', 'isbn']
Documentation
Documentation is a bit patchy at the moment. Watch this space!
Author Credits
Initial development, maintenance:
Contributions:
Install
Install with pip:
$ pip install schemainspect
To install psycopg2 (the PostgreSQL driver) at the same time as well:
$ pip install schemainspect[pg]
1 maintainer
Metadata
1 maintainer
Release files for schemainspect 3.1.1648463413
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| schemainspect-3.1.1648463413.tar.gz | 27.6 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| schemainspect-3.1.1648463413-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 63.9 kB
Release files / schemainspect-3.1.1648463413.tar.gz
| Download URL | schemainspect-3.1.1648463413.tar.gz |
|---|---|
| Size | 27.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
16925e48a67cb97cc9b73072c7488413ce68f3b4982eda7291aeb94efc6edb98
|
|
BLAKE2b-256 checksum How to use checksums |
3ff443375d5d4f14413a90cb261c98100b306f74bd2a6d0376f8975d6de1223b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.1.13 CPython/3.10.3 Linux/5.13.0-1017-aws
|
Release files / schemainspect-3.1.1648463413-py3-none-any.whl
| Download URL | schemainspect-3.1.1648463413-py3-none-any.whl |
|---|---|
| Size | 36.3 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
17afd645a0c848c1706b03b2d7372c8dbf330052bd8a7e42228f76675f671eef
|
|
BLAKE2b-256 checksum How to use checksums |
2e8c3f4bf3db8e7c7a5a50584d24c05100512621efb3f3016d05a80fff857e50
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.1.13 CPython/3.10.3 Linux/5.13.0-1017-aws
|
