v8.0.3

What's Changed

Full changelog: v8.0.2...8.0.3

Changed

• Force the creation of a new swoop-db image, from latest postgres:15 image containing postgres-15.4 (#28)
• .snyk changes to snooze postgres15 vulnerability SNYK-DEBIAN12-POSTGRESQL15-5838227, since the vulnerability has been remediated the new base postgres:15 image that comes with postgres-15.4. See more details at CVE-2023-39417 (#28)

v8.0.2

What's Changed

Full changelog: v8.0.1...8.0.2

Changed

• bin/db-initialization.py changes to create swoop_readwrite group role and assign all swoop application roles to be part of the swoop_readwrite group role (#27)
• bin/run-migration-job.py changes to revoke connection privileges to the swoop_readwrite group role before migration starts and to grant connection privileges to the swoop_readwrite once migration is completed (#27)

v8.0.1

What's Changed

Full changelog: v8.0.0...8.0.1

Added

• bin/run-migration-job.py script to automate applying migrations to a swoop database as created by the /bin/db-initialization.py script (#26)

Changed

• Replacement of the MIGRATION_ROLE by OWNER_ROLE in the /bin/db-initialization.py script (#25)

v8.0.0

What's Changed

Full changelog: v7.0.3...8.0.0

Added

• Migration 00008_new_base consolidates all prior migrations in a single non-backward-compatible file. This fixes a problem applying LEAKPROOF functions as a non-superuser. (#25)

Changed

• /bin/db-initialization.py script makes database owner a login role for use running migration to fix ownership issues. (#25)
• Update dbami dependency to v0.3.0 (#25)

v7.0.3

What's changed

Full changelog: v7.0.2...7.0.3

Added

• Added db-initialization.py script to initialize swoop db with a new database and roles (#23 , #24)

v7.0.2

What's changed

Full changelog: v7.0.1...7.0.2

Changed

• Properly set required env vars in Dockerfile (#22)

v7.0.1

What's new

Full changelog: [v7.0.1]: v7.0.0...7.0.1

Changed

Use the same image version for all build stages in the Dockerfile (fixes an issue with libc not found) (#21)

v7.0.0

What's new?

Full changelog: v2.0.0...7.0.0

⚠️ Breaking Changes

The schema migration from version 6 to 7 requires truncating ALL data records in the database. There is no forward migration for existing data, just the schema.

Added

• started_at field to swoop.thread set from RUNNING events via update_thread trigger (#19)
• handler_type field to swoop.action table (#19)
• public.gen_uuid_v7 to generate v7 uuids for actions (#20)
• public.uuid_version to extract the version from a uuid (#20)
• timestamp_from_uuid_v7 to extract the timestamp from a v7 uuid (#20)

Changed

• workflow type actions cannot have parent_uuid set (#19)
• swoop.action field action_uuid to be constrained to v7 uuids, such that sorting on the field would also sort based on the created_at timestamp (#20)
• dropped swoop.payload_cache field payload_hash and switched to enforcing v5 uuids for the payload_uuid identifier (#20)

Removed

• input_item and item_payload tables (#19)

v2.0.0

What's changed

Full changelog: v0.1.0...2.0.0

Added

• find_cached_action_for_payload function (used for checking if a payload should be processed or if we should simply reference an existing action) (#12, #14)

Changed

• workflow_versions moved from payload_cache table to action table (#14)
• Update (dbami)[https://github.com/element84/dbami] dependency to v0.2.0 (#15)
• Disable CLI command new unless editable install to prevent creating migration files in non-editable installs (#15)
• Schema no longer needs to manage schema version table or updates (#15)

v0.1.3

Updates to swoop.check_cache function.