v0.0.7 (2024-08-21)

What's Changed

• add ability to create Domains
• properly handle composite primary keys and foreign keys in Tables during column extraction

Full Changelog: v0.0.6...v0.0.7

v0.0.6 (2024-08-16)

What's Changed

• Enhanced the Database class to allow accessing schema objects via dot notation (e.g., db.schema_name.table_name)
• Added the .columns attribute to the Table class to extract column names, supporting both simple and complex table definitions, including those with constraints
• .columns properly handles inherited columns for tables using the INHERITS clause
• Updated the Database class to enforce loading schemas before any dependent items, raising errors when schemas are not loaded in the correct order
• Updated GitHub Actions workflows to support Python 3.12

Full Changelog: v0.0.5...v0.0.6

v0.0.5 (2023-06-12)

• add ability to create View and Trigger
• changed Database.get_items_by_type to return DatabaseItems instead of name strings
• added _item_type and itype property to DatabaseItem and set itypes for tables, views, etc
• modified functions to handle Exists mode with OR REPLACE
• renamed GitHub tests action to Tests, increased number of tests and enhanced organization of tests

v0.0.4 (2023-06-11)

• add ability to create Schema
• cleaning up more naming and references related to the SchemaItem -> DatabaseItem change in v0.0.2
• use _name_pattern attribute to avoid defining a post_init on all DatabaseItems
• add additional tests
• add GitHub action to run tests
• add GitHub action to release to PyPI

v0.0.3 (2023-05-26)

v0.0.3 (2023-05-26)

• Migrations: specify a migrations_folder and write SQL migrations that are loaded in Database.create

v0.0.2 (2023-05-19)

v0.0.2 (2023-05-19)

• SchemaItem -> DatabaseItem: the term schema has some meaning in a PostgreSQL database. Starting to change SchemaItems into DatabaseItems in order to create a way to manage real PostgreSQL schemas
• DatabaseItem dataclass allows Tables and Functions to extract the table name from the CREATE and makes it accessible via the name property
• Adding the Database dataclass: Database is a class for managing a PostgreSQL database such as the load_order of DatabaseItems and the extensions to install
• There's now an 'exists' option on Tables that allows them to load with IF NOT EXISTS inserted into the CREATEs. The exists option is a boolean parameter on the Database create method