rclement / datasette-dashboards

Datasette plugin providing data dashboards from metadata
https://datasette-dashboards-demo.vercel.app
Apache License 2.0
137 stars 7 forks source link

Update dependency sqlite-utils to v3.35 #158

Closed renovate[bot] closed 1 year ago

renovate[bot] commented 1 year ago

Mend Renovate

This PR contains the following updates:

Package Change Age Adoption Passing Confidence
sqlite-utils (changelog) ==3.34 -> ==3.35 age adoption passing confidence

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.

codecov[bot] commented 1 year ago

Codecov Report

Merging #158 (53f7970) into master (ff04d5d) will not change coverage. The diff coverage is n/a.

@@            Coverage Diff            @@
##            master      #158   +/-   ##
=========================================
  Coverage   100.00%   100.00%           
=========================================
  Files            8         8           
  Lines          388       388           
  Branches        73        73           
=========================================
  Hits           388       388           

:mega: We’re building smart automated test selection to slash your CI/CD build times. Learn more