Closed renovate[bot] closed 1 year ago
Merging #31 (83e2c34) into main (91de872) will not change coverage. The diff coverage is
n/a
.
@@ Coverage Diff @@
## main #31 +/- ##
=========================================
Coverage 100.00% 100.00%
=========================================
Files 3 3
Lines 479 479
Branches 41 41
=========================================
Hits 479 479
:mega: We’re building smart automated test selection to slash your CI/CD build times. Learn more
This PR contains the following updates:
==3.34
->==3.35
Release Notes
simonw/sqlite-utils (sqlite-utils)
### [`v3.35`](https://togithub.com/simonw/sqlite-utils/releases/tag/3.35) [Compare Source](https://togithub.com/simonw/sqlite-utils/compare/3.34...3.35) Adding foreign keys to a table no longer uses `PRAGMA writable_schema = 1` to directly manipulate the `sqlite_master` table. This was resulting in errors in some Python installations where the SQLite library was compiled in a way that prevented this from working, in particular on macOS. Foreign keys are now added using the [table transformation](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-transform) mechanism instead. ([#577](https://togithub.com/simonw/sqlite-utils/issues/577)) This new mechanism creates a full copy of the table, so it is likely to be significantly slower for large tables, but will no longer trigger table `sqlite_master may not be modified` errors on platforms that do not support `PRAGMA writable_schema = 1`. Other changes: - The [table.transform() method](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-transform) has two new parameters: `foreign_keys=` allows you to replace the foreign key constraints defined on a table, and `add_foreign_keys=` lets you specify new foreign keys to add. These complement the existing `drop_foreign_keys=` parameter. ([#577](https://togithub.com/simonw/sqlite-utils/issues/577)) - The [sqlite-utils transform](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-transform-table) command has a new `--add-foreign-key` option which can be called multiple times to add foreign keys to a table that is being transformed. ([#585](https://togithub.com/simonw/sqlite-utils/issues/585)) - [sqlite-utils convert](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-convert) now has a `--pdb` option for opening a debugger on the first encountered error in your conversion script. ([#581](https://togithub.com/simonw/sqlite-utils/issues/581)) - Fixed a bug where `sqlite-utils install -e '.[test]'` option did not work correctly.Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR has been generated by Mend Renovate. View repository job log here.