●Change8

data-table-mysql@0.4.0

Breaking Changes
📦 remixView on GitHub →
⚠ 2 breaking✨ 1 features🔧 5 symbols

Summary

This release removes the DDL operation ADT from `@remix-run/data-table`, breaking the `migrate` and `compileSql` signatures, and introduces `executeScript` for running SQL migrations.

⚠️ Breaking Changes

  • Removed `migrate(request)` and `compileSql(DataMigrationOperation)`. The DDL operation ADT was removed from `@remix-run/data-table`.
  • The `compileSql` function now only accepts `DataManipulationOperation`.

Migration Steps

  1. Replace calls to `migrate(request)` with the new migration mechanism using `executeScript`.
  2. When using mysql2, ensure the connection or pool is created with `multipleStatements: true` if your migration files (`up.sql` / `down.sql`) contain more than one SQL statement.

✨ New Features

  • Introduced `executeScript(sql, transaction?)` for running SQL-file migrations, which forwards to `connection.query(sql)`.

Affected Symbols

`migrate(request)``compileSql(DataManipulationOperation)``executeScript(sql, transaction?)``connection.query(sql)``@remix-run/data-table`