v0.0.7 (2024-08-21)

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

v0.0.6 (2024-08-16)

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

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

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

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

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

Initial release