phryk
/
ooze
1
0
Fork 0
Code Issues 12 Pull Requests Packages Projects Releases Wiki Activity

Database introspection #13

New Issue
Closed
opened 2023-04-11 12:02:10 +00:00 by phryk · 2 comments
phryk commented 2023-04-11 12:02:10 +00:00
Owner
Copy Link

Support for information_schema was added to squeal in 04e5daf8d0.
Extend the database subsystem doing the actual interactions with the db.

The implementation should offer a high-level API that returns well-structured
metadata that easily allows the following:

  • Find differences between the loaded data model (i.e. python classes) and the existing database
  • Generate a data model from an existing database

Structure something like

  • database/
    • __init__.py
    • introspection/
      • __init__.py
        • high-level API
      • base.py
        • autogenerated Model classes for all children of InformationSchemaTable
Support for `information_schema` was added to `squeal` in 04e5daf8d0. Extend the database subsystem doing the actual interactions with the db. The implementation should offer a high-level API that returns well-structured metadata that easily allows the following: * Find differences between the loaded data model (i.e. python classes) and the existing database * Generate a data model from an existing database Structure something like * `database/` * `__init__.py` * `introspection/` * `__init__.py` * high-level API * `base.py` * autogenerated `Model` classes for all children of `InformationSchemaTable`
phryk added a new dependency 2023-04-11 12:02:55 +00:00
#14 Database migrations
phryk commented 2023-11-07 02:01:16 +00:00
Author
Owner
Copy Link

Implemented through magic in c458da3310. Test suite still incomplete.

Implemented through magic in c458da33108e9631c3b49d6554e5893492bcf524. Test suite still incomplete.
phryk commented 2023-12-04 14:18:24 +00:00
Author
Owner
Copy Link

Test suite extended in ff46610abe, closing

Test suite extended in ff46610abe, closing
phryk closed this issue 2023-12-04 14:18:24 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Blocks
#14 Database migrations
phryk/ooze
Reference: phryk/ooze#13
No description provided.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?