Pyrseas icon indicating copy to clipboard operation
Pyrseas copied to clipboard

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

Open rhunwicks opened this issue 12 years ago • 1 comments

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

rhunwicks avatar Oct 23 '13 03:10 rhunwicks

@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.

jmafc avatar Sep 14 '18 01:09 jmafc