schemainspect
schemainspect copied to clipboard
djrobstep
Schema inspection for PostgreSQL (and potentially others).
The default status for a trigger is "origin" and the create_statement will create this type of trigger just fine. For the other three types "disabled", "replica", and "always" the create...
As part of introducing multiple schema inclusion/exclusion in migra, I think this could be an addition: The get_inspector call can now receive schema/exclude_schema as a list, keeping the backward compatibility...
This should fix djrobstep/migra#147 Unfortunately this required some special casing of exclusion constraints in the SQL generation functions. Exclusion constraints don't show up in `information_schema.table_constraints`, so remove that table from...
The auto-generated `__repr__` for inspected objects currently does not work because a lot of objects contain circular references (for example index constraint) which leads to infinite recursion. This PR adds...
Following test seem to fail, when using the newest packages available, whilst still meeting the requirements from the `pyproject.toml`: ``` "test_can_replace" "test_collations" "test_constraints" "test_dep_order" "test_enum_deps" "test_exclusion_constraint" "test_fk_col_order" "test_fk_info" "test_generated_columns" "test_identity_columns"...
The repository uses poetry as build system, which in effect breaks the sdist because poetry, by default, will not include the `.sql` files. Fixing that is done by explicitly specifying...
1. Define a view with security_invoker=on 2. Run migra schema diff 3. security_invoker clause is not included in output More reproducible example here https://github.com/supabase/cli/issues/792
We're using migra to distribute DB updates. Now we went to Pg15. So, we have to count for new attributes, like `…SET COMPRESSION lz4`. Plus, we still have to mantain...
Column options: `ALTER TABLE test ALTER COLUMN test SET STATISTICS 0;` `ALTER TABLE test ALTER COLUMN test SET (n_distinct=-1);` Makes no difference with migra. Custom column options can be found...
