schemainspect
schemainspect copied to clipboard
djrobstep
Schema inspection for PostgreSQL (and potentially others).
Using Python3.6+ type annotations would require documenting and refactoring, as requested in #40
``` SQL CREATE OR REPLACE FUNCTION test_case(text) RETURNS text LANGUAGE internal IMMUTABLE AS $function$upper$function$ ``` This causes problem in Migra. It is trivial to avoid (use 'LANGUAGE SQL' function for...
Work done in #58 adds an ability to include or exclude single schema, but recently I've met the need to limit considered schemas to a list of them or symmetrically...
While using `migra`, I got the following error: `AttributeError: 'NoneType' object has no attribute 'name'`. Using `pdb`, I determined that the error arose when a table with an index was...
Hi! Thanks for the great library and the migra tool. I'm not sure this change is entirely fool proof, but I can't think of a case where whitespace has special...
This is the companion to https://github.com/djrobstep/migra/pull/105. I'm not sure whether this is the best approach, I confess I'm not a fan of `is_equal` and the awkward it and `__eq__` call...
Hi! I am using `schemainspect` as the data-collector for a schema comparison tool between a postgres (9.6.9) DB and a Redshift Data Warehouse (which reports as Postgres 8.0.2), so added...
This adds initial support for Postgres comments. At the moment it's only working for comments on functions, but it won't be hard to extend to other objects (just need to...
