Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database introspection: fdb schema api #49

Open
maxirobaina opened this issue Dec 28, 2015 · 0 comments
Open

Database introspection: fdb schema api #49

maxirobaina opened this issue Dec 28, 2015 · 0 comments
Labels
enhancement firebird3 Firebird 3 support

Comments

@maxirobaina
Copy link
Owner

Evaluante replace plain sql schema introspection by fdb schema api.

http://pythonhosted.org//fdb/usage-guide.html#working-with-database-schema

Working with database schema
Description of database objects like tables, views, stored procedures, triggers or UDF functions that represent database schema is stored in set of system tables present in every database. Firebird users can query these tables to get information about these objects and their relations. But querying system tables is inconvenient, as it requires good knowledge how this information is structured and requires significant amount of Python code. Changes in system tables between Firebird versions further add to this complexity. Hence FDB provides set of classes (isolated in separate module fdb.schema) that transform information stored in system tables into set of Python objects that surface the vital information in meaningful way, and additionaly provide set of methods for most commonly used operations or checks.

@maxirobaina maxirobaina added this to the 1.8.0 milestone Mar 28, 2016
@maxirobaina maxirobaina removed this from the 1.8.0 milestone Apr 24, 2017
@maxirobaina maxirobaina added the firebird3 Firebird 3 support label Apr 25, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement firebird3 Firebird 3 support
Projects
None yet
Development

No branches or pull requests

1 participant