Skip to content

Releases: portfoliome/pgawedge

Add Support for Views

26 Oct 18:09
eac03b5
Compare
Choose a tag to compare

Initial support to incorporate view creation and use alongside Sqlalchemy.

  • Support for View classes that emit creation/drop DDL.
  • Automatically recognize View dependencies from the selectable query that generates the view.
  • Add helper to create schemas before creating a MetaData's table objects.

Server side updated_at, created_at

02 Nov 18:00
c9b246d
Compare
Choose a tag to compare
  • Trigger statement compilers for "before row update" and "drop trigger."
  • Declarative base audit mixin for appending a created_at and updated_at in UTC on the server side.

Primary Key Upsert

23 Oct 07:51
Compare
Choose a tag to compare

Add function to generate insert when the primary key doesn't exist, otherwise, update for a sqlalchemy table.

Delete records when not in refresh statement

15 Sep 00:33
Compare
Choose a tag to compare

Helper query builder to delete records in a table when a refresh statement or table does not have rows existing via the source table's primary key columns.

Expression compilation

29 May 14:31
Compare
Choose a tag to compare
  • Helpers to compile Sqlalchemy expressions to strings.

Minor additions

23 Feb 20:47
Compare
Choose a tag to compare
  • Helper for quickly querying a table's row count with an optional conditional argument. Can be used to verify if third-party data refreshed properly.

0.0.7

10 Feb 01:13
Compare
Choose a tag to compare
  • Added helpers for filtering columns with Python or database side defaults.

UUID Server Functions

01 Feb 07:42
Compare
Choose a tag to compare
  • Implement UUID type without as_type configuration option
  • Postgres server side UUID generation for random and sequenced UUID's
  • small cleanups and test fixes.

Integrate postpy

27 Dec 17:55
Compare
Choose a tag to compare
  • Integrate functionality for schema ddl statements and testing fixtures from postpy
  • Add alchemy.schema utility specification
  • incorporate code coverage with travis

Test Fixture

27 Dec 05:21
Compare
Choose a tag to compare
  • Test fixture now only configurable through env variables.