Bump sqlite-utils from 3.34 to 3.35

[dependabot[bot]]

Bumps sqlite-utils from 3.34 to 3.35.

Release notes

Sourced from sqlite-utils's releases.

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 mechanism instead. (#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.

A new plugin, sqlite-utils-fast-fks, is now available for developers who still want to use that faster but riskier implementation.

Other changes:

• The table.transform() method 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)
• The sqlite-utils transform 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)
• sqlite-utils convert now has a --pdb option for opening a debugger on the first encountered error in your conversion script. (#581)
• Fixed a bug where sqlite-utils install -e '.[test]' option did not work correctly.

Changelog

Sourced from sqlite-utils's changelog.

3.35 (2023-08-17)

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 :ref:table transformation <python_api_transform> mechanism instead. (:issue: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.

A new plugin, sqlite-utils-fast-fks <https://github.com/simonw/sqlite-utils-fast-fks>__, is now available for developers who still want to use that faster but riskier implementation.

Other changes:

• The :ref:table.transform() method <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. (:issue:577)
• The :ref:sqlite-utils transform <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. (:issue:585)
• :ref:sqlite-utils convert <cli_convert> now has a --pdb option for opening a debugger on the first encountered error in your conversion script. (:issue:581)
• Fixed a bug where sqlite-utils install -e '.[test]' option did not work correctly.

.. _v3_34:

Commits

• ba2681e Fixed two typos in the release notes
• 87c6ceb Release 3.35
• 56093de sqlite-utils transform --add-foreign-key option, closes #585
• 70717dc Remove unneccessary warning, refs #577, #585
• d2bcdc0 Swapped the order of a bunch of pytest comparisons
• b4735f7 Remove test.utils.collapse_whitespace, closes #583
• 509857e .add_foreign_keys() uses .transform() instead of PRAGMA writable_schema
• 993029f flake8 fixes
• 1dc6b5a Note about execute_plugins=False, refs #575
• 619cea8 sqlite-utils convert --pdb option, closes #581
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

[codecov-commenter]

Codecov Report

Patch has no changes to coverable lines.

:exclamation: Your organization is not using the GitHub App Integration. As a result you may experience degraded service beginning May 15th. Please install the GitHub App Integration for your organization. Read more.

:loudspeaker: Thoughts on this report? Let us know!.

[dependabot[bot]]

Looks like sqlite-utils is up-to-date now, so this is no longer needed.