Skip to content

v0.1.4

Latest

Choose a tag to compare

@tbson tbson released this 17 Nov 16:57

Added

  • Views in the migration history are read. CREATE VIEW, CREATE OR REPLACE VIEW and CREATE MATERIALIZED VIEW used to be listed as not read. They now become part of the schema the change runs against, with the tables and columns each view's query reads (* reads every column), and they follow DROP VIEW and table and column renames. A change a view stands in the way of is reported under Dependent objects:

    Dependent objects
      0002.sql:1  1 object depends on customers.email, and the database refuses the change
          view customer_emails depends on customers.email. The database refuses the change while it exists.
    

    Views are read from --before and from a --schema dump. A view created by hand outside the migrations is not in the files, so it is not known here.

  • A DELETE reports what it cascades to. A DELETE from a table that foreign keys reference ON DELETE CASCADE now lists every table it also deletes from, at any depth, under Spreads:

      0002.sql:2  Deleting from customers also deletes from 2 entities through ON DELETE CASCADE
          orders (via fk_orders_customer_id, 1 hop)
          order_items (via fk_order_items_order_id, 2 hops)
    

    fail-on: spreads fails the job on it. SET NULL and SET DEFAULT children are not listed yet.

Fixed

  • A type change no longer warns about a MySQL, MariaDB or SQL Server view. A view held by name reads the retyped column and keeps working (measured on MySQL 8.4, MariaDB 11.4 and SQL Server 2022), so it is no longer reported as failing the next time it runs. PostgreSQL still refuses the change, and that is still reported.

Upgrade

Nothing to change in a workflow that uses schemity/ci@v1 with the default version: latest. A workflow pinned to an earlier version needs version: v0.1.4.

Downloads

File For
schemity-x86_64-unknown-linux-musl.tar.gz Linux x64
schemity-aarch64-unknown-linux-musl.tar.gz Linux ARM64
schemity-aarch64-apple-darwin.tar.gz macOS on Apple silicon

Each archive holds the schemity binary, its license and the licenses of the open source software in it. SHA-256 sums are in checksums.txt.