search

perseas / Pyrseas

Provides utilities for Postgres database schema versioning.
https://perseas.github.io/
BSD 3-Clause "New" or "Revised" License
395 stars 67 forks source link

YAML syntax for specifying default auditing for all tables in a schema #65

Open rhunwicks opened 10 years ago

rhunwicks commented 10 years ago

Ideally, I'd like to be able to specify auditing at the schema level, i.e. for all tables in the schema, rather than have to specify it for each table individually - it doesn't seem very DRY to create the table definition in my schema.yaml and then have to immediately add it to my augment.yaml

Something like:

schema app_schema:
  audit_columns: default
schema other_schema:
  table some_random_table:
    audit_columns: created_date_only

It would also be good to allow overrides to the schema-level default auditing:

schema app_schema:
  audit_columns: modified_only
  table some_important_table:
    audit_columns: full
jmafc commented 6 years ago

@rhunwicks Please read https://pyrseas.wordpress.com/2018/09/12/the-future-of-pyrseas-revisited/ . I'm not really sure where you stand nowadays with respect to dbaugment (which was in great part, your baby). Please let me know.