mike-works / sql-fundamentals

Mike North's SQL Fundamentals and Professional SQL Courses
https://frontendmasters.com/courses/sql-fundamentals/
BSD 3-Clause "New" or "Revised" License
169 stars 108 forks source link

fix(deps): update dependency sqlite to v4 - autoclosed #298

Closed renovate[bot] closed 1 year ago

renovate[bot] commented 4 years ago

Mend Renovate

This PR contains the following updates:

Package Change Age Adoption Passing Confidence
sqlite 3.0.6 -> 4.2.1 age adoption passing confidence

Release Notes

kriasoft/node-sqlite ### [`v4.2.1`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​421---Tue-May-23-2023-005829) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/ec80dd8b5faea1fb4ab51fd5737bbfd13d0af49e...v4.2.1) **Contributor:** Blake Embrey - Support all SQL template libraries ([#​172](https://togithub.com/kriasoft/node-sqlite/issues/172)) - Support all SQL template libraries - Remove sql-template-strings from lib ### [`v4.2.0`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​420-413---Mon-May-01-2023-105206) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/9461d51425db78d25105d7d9e2648c4921e55d82...ec80dd8b5faea1fb4ab51fd5737bbfd13d0af49e) **Contributor:** Andarist - move types condition to the front ([#​171](https://togithub.com/kriasoft/node-sqlite/issues/171)) Package should have published under `4.2.0` but was also published as `4.1.3`. Downgrade to `4.1.2` if you are having issues and raise an issue. ### [`v4.1.3`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​420-413---Mon-May-01-2023-105206) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.1.2...9461d51425db78d25105d7d9e2648c4921e55d82) **Contributor:** Andarist - move types condition to the front ([#​171](https://togithub.com/kriasoft/node-sqlite/issues/171)) Package should have published under `4.2.0` but was also published as `4.1.3`. Downgrade to `4.1.2` if you are having issues and raise an issue. ### [`v4.1.2`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​412---Tue-Jul-19-2022-165114) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.1.1...v4.1.2) **Contributor:** rinsuki - Support TS 4.7+ node16/next module mode ([#​164](https://togithub.com/kriasoft/node-sqlite/issues/164)) ### [`v4.1.1`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​411---Sun-Apr-24-2022-000052) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.25...v4.1.1) **Contributor:** Theo Gravity - Have native sqlite errors contain stack traces ([#​162](https://togithub.com/kriasoft/node-sqlite/issues/162)) This ensures that errors thrown from the sqlite driver now have stack traces and are of an `Error` type. Thanks to [@​fresheneesz](https://togithub.com/fresheneesz) for initial troubleshooting and initial code to help fix the issue. This is a minor level version update as to not break implementations that may handle errors in their own way prior to this fix. ### [`v4.0.25`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4025---Mon-Mar-07-2022-085006) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.24...v4.0.25) **Contributor:** Theo Gravity - Update packages, fix tests for latest jest ([#​159](https://togithub.com/kriasoft/node-sqlite/issues/159)) - Update packages, fix tests for latest jest - Update node version on ci ### [`v4.0.24`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4024---Sun-Mar-06-2022-201224) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.23...v4.0.24) **Contributor:** fresheneesz - Updating exec to support passed in parameters like the other functions do. ([#​155](https://togithub.com/kriasoft/node-sqlite/issues/155)) ### [`v4.0.23`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4023---Mon-May-24-2021-211744) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.22...v4.0.23) **Contributor:** dependabot\[bot] - Bump browserslist from 4.16.3 to 4.16.6 ([#​145](https://togithub.com/kriasoft/node-sqlite/issues/145)) Bumps [browserslist](https://togithub.com/browserslist/browserslist) from 4.16.3 to 4.16.6. - [Release notes](https://togithub.com/browserslist/browserslist/releases) - [Changelog](https://togithub.com/browserslist/browserslist/blob/main/CHANGELOG.md) - [Commits](https://togithub.com/browserslist/browserslist/compare/4.16.3...4.16.6) Signed-off-by: dependabot\[bot] Co-authored-by: dependabot\[bot] <49699333+dependabot\[bot][@​users](https://togithub.com/users).noreply.github.com> ### [`v4.0.22`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4022---Sun-May-09-2021-195928) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.21...v4.0.22) **Contributor:** dependabot\[bot] - Bump handlebars from 4.7.6 to 4.7.7 ([#​141](https://togithub.com/kriasoft/node-sqlite/issues/141)) Bumps [handlebars](https://togithub.com/wycats/handlebars.js) from 4.7.6 to 4.7.7. - [Release notes](https://togithub.com/wycats/handlebars.js/releases) - [Changelog](https://togithub.com/handlebars-lang/handlebars.js/blob/master/release-notes.md) - [Commits](https://togithub.com/wycats/handlebars.js/compare/v4.7.6...v4.7.7) Signed-off-by: dependabot\[bot] Co-authored-by: dependabot\[bot] <49699333+dependabot\[bot][@​users](https://togithub.com/users).noreply.github.com> ### [`v4.0.21`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4021---Wed-Mar-31-2021-212242) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.19...v4.0.21) **Contributor:** Theo Gravity - Update packages to latest ### [`v4.0.19`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4019---Wed-Dec-30-2020-021107) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.18...v4.0.19) **Contributor:** dependabot\[bot] - Bump ini from 1.3.5 to 1.3.8 ([#​135](https://togithub.com/kriasoft/node-sqlite/issues/135)) Bumps [ini](https://togithub.com/isaacs/ini) from 1.3.5 to 1.3.8. - [Release notes](https://togithub.com/isaacs/ini/releases) - [Commits](https://togithub.com/isaacs/ini/compare/v1.3.5...v1.3.8) Signed-off-by: dependabot\[bot] Co-authored-by: dependabot\[bot] <49699333+dependabot\[bot][@​users](https://togithub.com/users).noreply.github.com> ### [`v4.0.18`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4018---Fri-Dec-04-2020-212015) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.17...v4.0.18) **Contributor:** dependabot\[bot] - Bump highlight.js from 10.1.2 to 10.4.1 ([#​133](https://togithub.com/kriasoft/node-sqlite/issues/133)) Bumps [highlight.js](https://togithub.com/highlightjs/highlight.js) from 10.1.2 to 10.4.1. - [Release notes](https://togithub.com/highlightjs/highlight.js/releases) - [Changelog](https://togithub.com/highlightjs/highlight.js/blob/master/CHANGES.md) - [Commits](https://togithub.com/highlightjs/highlight.js/compare/10.1.2...10.4.1) Signed-off-by: dependabot\[bot] Co-authored-by: dependabot\[bot] <49699333+dependabot\[bot][@​users](https://togithub.com/users).noreply.github.com> ### [`v4.0.17`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4017---Fri-Nov-13-2020-191804) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.16...v4.0.17) **Contributor:** Tiger Oakes - Add strict types for each() ([#​131](https://togithub.com/kriasoft/node-sqlite/issues/131)) ### [`v4.0.16`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4016---Fri-Nov-13-2020-191524) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.15...v4.0.16) **Contributor:** Tiger Oakes - Let migrations be read manually ([#​132](https://togithub.com/kriasoft/node-sqlite/issues/132)) ### [`v4.0.15`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4015---Wed-Sep-30-2020-160620) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.14...v4.0.15) **Contributor:** Paul Kiddle - Make down migrations optional ([#​129](https://togithub.com/kriasoft/node-sqlite/issues/129)) ### [`v4.0.14`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4014---Mon-Aug-10-2020-010829) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.13...v4.0.14) **Contributor:** Theo Gravity - Revert filename optional; update filename checks instead ([#​125](https://togithub.com/kriasoft/node-sqlite/issues/125)) The `filename` property is back to being required, but empty strings are valid values for the purpose of using an anonymous disk-based database. Values of `undefined` or `null` for `filename` will throw. ### [`v4.0.13`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4013---Mon-Aug-10-2020-005758) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.12...v4.0.13) **Contributor:** Theo Gravity - Make filename optional ([#​124](https://togithub.com/kriasoft/node-sqlite/issues/124)) This allows for the specification of an anonymous database. ### [`v4.0.12`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4012---Mon-Jul-20-2020-041901) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.11...v4.0.12) **Contributor:** dependabot\[bot] - Bump lodash from 4.17.15 to 4.17.19 ([#​122](https://togithub.com/kriasoft/node-sqlite/issues/122)) Bumps [lodash](https://togithub.com/lodash/lodash) from 4.17.15 to 4.17.19. - [Release notes](https://togithub.com/lodash/lodash/releases) - [Commits](https://togithub.com/lodash/lodash/compare/4.17.15...4.17.19) Signed-off-by: dependabot\[bot] Co-authored-by: dependabot\[bot] <49699333+dependabot\[bot][@​users](https://togithub.com/users).noreply.github.com> ### [`v4.0.11`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4011---Fri-Jun-12-2020-094339) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.10...v4.0.11) **Contributor:** Theo Gravity - Update readme for inserting rows ([#​120](https://togithub.com/kriasoft/node-sqlite/issues/120)) [@​akc42](https://togithub.com/akc42) pointed out that the docs for `db.run` says it returns `lastId` when it should be `lastID`. ### [`v4.0.10`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4010---Wed-Jun-03-2020-005141) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.9...v4.0.10) **Contributor:** Gustavo Rodrigues - Use HTTPS in README badges ([#​118](https://togithub.com/kriasoft/node-sqlite/issues/118)) Shields.io badges were being loaded using HTTP causing mixed-content errors in the NPM page. ### [`v4.0.9`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​409---Mon-May-25-2020-225002) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.8...v4.0.9) **Contributor:** Markus Felten - feat: provide native esm exports ([#​117](https://togithub.com/kriasoft/node-sqlite/issues/117)) ### [`v4.0.8`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​408---Thu-May-21-2020-225957) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.7...v4.0.8) **Contributor:** George Corney - Move triple-slash reference so it is recognized ([#​115](https://togithub.com/kriasoft/node-sqlite/issues/115)) ### [`v4.0.7`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​407---Sun-Apr-12-2020-194331) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.6...v4.0.7) **Contributor:** Yamavol - Fix typescript defs for sqlite3 loadExtension() ([#​112](https://togithub.com/kriasoft/node-sqlite/issues/112)) ### [`v4.0.6`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​406---Sat-Apr-11-2020-041608) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.5...v4.0.6) **Contributor:** Theo Gravity - Throw an error if two callbacks are defined for #each() This addresses an issue where the `sqlite3` API for `each()` uses two callbacks, while this library only uses one for `each()`. An error is now thrown if two callbacks are defined when using the `sqlite` `each()` method. (In `sqlite`, the second callback of `sqlite3` is used to resolve the promise.) ### [`v4.0.5`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​405---Sun-Apr-05-2020-201343) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.4...v4.0.5) **Contributor:** [jameswilddev](https://togithub.com/jameswilddev) - Use non-default imports rather than synthetic default imports. ([#​110](https://togithub.com/kriasoft/node-sqlite/issues/110)) ### [`v4.0.4`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​404---Sun-Apr-05-2020-074439) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.3...v4.0.4) - Fix Typescript reference issues for sqlite3 if it is not installed ([#​109](https://togithub.com/kriasoft/node-sqlite/issues/109)) This allows the usage of the `sqlite3-offline`; library in Typescript. ### [`v4.0.3`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​403---Sun-Apr-05-2020-000131) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.2...v4.0.3) - Fix Typescript issue where `sql-template-strings` is a forced requirement ([#​108](https://togithub.com/kriasoft/node-sqlite/issues/108)) It should be an optional dependency and is not required for installation. ### [`v4.0.2`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4025---Mon-Mar-07-2022-085006) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v4.0.1...v4.0.2) **Contributor:** Theo Gravity - Update packages, fix tests for latest jest ([#​159](https://togithub.com/kriasoft/node-sqlite/issues/159)) - Update packages, fix tests for latest jest - Update node version on ci ### [`v4.0.1`](https://togithub.com/kriasoft/node-sqlite/blob/HEAD/CHANGELOG.md#​4019---Wed-Dec-30-2020-021107) [Compare Source](https://togithub.com/kriasoft/node-sqlite/compare/v3.0.6...v4.0.1) **Contributor:** dependabot\[bot] - Bump ini from 1.3.5 to 1.3.8 ([#​135](https://togithub.com/kriasoft/node-sqlite/issues/135)) Bumps [ini](https://togithub.com/isaacs/ini) from 1.3.5 to 1.3.8. - [Release notes](https://togithub.com/isaacs/ini/releases) - [Commits](https://togithub.com/isaacs/ini/compare/v1.3.5...v1.3.8) Signed-off-by: dependabot\[bot] Co-authored-by: dependabot\[bot] <49699333+dependabot\[bot][@​users](https://togithub.com/users).noreply.github.com>

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.

renovate[bot] commented 1 year ago

āš  Artifact update problem

Renovate failed to update an artifact related to this branch. You probably do not want to merge this PR as-is.

ā™» Renovate will retry this branch, including artifacts, only when one of the following happens:

The artifact failure details are included below:

File name: yarn.lock
No /opt/buildpack/tools/yarn-slim/1.22.19/bin/yarn defined - aborting