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:
- any of the package files in this branch needs updating, or
- the branch becomes conflicted, or
- you click the rebase/retry checkbox if found above, or
- you rename this PR's title to start with "rebase!" to trigger it manually
The artifact failure details are included below:
File name: package-lock.json
ERROR: npm v9.6.6 is known not to run on Node.js v12.22.12. This version of npm supports the following node versions: `^14.17.0 || ^16.13.0 || >=18.0.0`. You can find the latest version at https://nodejs.org/.
ERROR:
/opt/buildpack/tools/npm/9.6.6/node_modules/npm/lib/utils/exit-handler.js:19
const hasLoadedNpm = npm?.config.loaded
^
SyntaxError: Unexpected token '.'
at wrapSafe (internal/modules/cjs/loader.js:915:16)
at Module._compile (internal/modules/cjs/loader.js:963:27)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1027:10)
at Module.load (internal/modules/cjs/loader.js:863:32)
at Function.Module._load (internal/modules/cjs/loader.js:708:14)
at Module.require (internal/modules/cjs/loader.js:887:19)
at require (internal/modules/cjs/helpers.js:74:18)
at module.exports (/opt/buildpack/tools/npm/9.6.6/node_modules/npm/lib/cli.js:42:23)
at Object.<anonymous> (/opt/buildpack/tools/npm/9.6.6/node_modules/npm/bin/npm-cli.js:2:25)
at Module._compile (internal/modules/cjs/loader.js:999:30)
ERROR: npm v9.6.6 is known not to run on Node.js v12.22.12. This version of npm supports the following node versions: `^14.17.0 || ^16.13.0 || >=18.0.0`. You can find the latest version at https://nodejs.org/.
ERROR:
/opt/buildpack/tools/npm/9.6.6/node_modules/npm/lib/utils/exit-handler.js:19
const hasLoadedNpm = npm?.config.loaded
^
SyntaxError: Unexpected token '.'
at wrapSafe (internal/modules/cjs/loader.js:915:16)
at Module._compile (internal/modules/cjs/loader.js:963:27)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1027:10)
at Module.load (internal/modules/cjs/loader.js:863:32)
at Function.Module._load (internal/modules/cjs/loader.js:708:14)
at Module.require (internal/modules/cjs/loader.js:887:19)
at require (internal/modules/cjs/helpers.js:74:18)
at module.exports (/opt/buildpack/tools/npm/9.6.6/node_modules/npm/lib/cli.js:42:23)
at Object.<anonymous> (/opt/buildpack/tools/npm/9.6.6/node_modules/npm/bin/npm-cli.js:2:25)
at Module._compile (internal/modules/cjs/loader.js:999:30)
This PR contains the following updates:
^0.15.2->^0.95.0Release Notes
knex/knex
### [`v0.95.15`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#09515---22-December-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.14...380cebefcbf04219f51dfeb0e06efc735796c148) ##### Bug fixes: - Oracle: - MariaDB: lock row fix during migration in MariaDB and Oracle [#4865](https://togithub.com/knex/knex/issues/4865) ### [`v0.95.14`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#09514---09-November-2021) [Compare Source](https://togithub.com/knex/knex/compare/29ac476b2bfe7593118da2884fae23a2e6004414...0.95.14) ##### Bug fixes: - MySQL: mysql2 dialect validate connection fix [#4794](https://togithub.com/knex/knex/issues/4794) ### [`v0.95.13`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#09513---02-November-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.12...29ac476b2bfe7593118da2884fae23a2e6004414) ##### Bug fixes: - PostgreSQL: Support zero precision in timestamp/datetime [#4784](https://togithub.com/knex/knex/issues/4784) ##### Typings: - Allow string indexType in index creation [#4791](https://togithub.com/knex/knex/issues/4791) ### [`v0.95.12`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#09512---28-October-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.11...0.95.12) ##### New features: - New dialect: CockroachDB [#4742](https://togithub.com/knex/knex/issues/4742) - New dialect: pg-native [#4327](https://togithub.com/knex/knex/issues/4327) - CockroachDB: add support for upsert [#4767](https://togithub.com/knex/knex/issues/4767) - PostgreSQL: Support SELECT .. FOR NO KEY UPDATE / KEY SHARE row level locking clauses [#4755](https://togithub.com/knex/knex/issues/4755) - PostgreSQL: Add support for 'CASCADE' in PostgreSQL 'DROP SCHEMA' queries [#4713](https://togithub.com/knex/knex/issues/4713) - MySQL: Add storage engine index Type support to index() and unique() schema [#4756](https://togithub.com/knex/knex/issues/4756) - MSSQL: Support table.primary, table.unique variant with options object [#4710](https://togithub.com/knex/knex/issues/4710) - SQLite: Add setNullable support to SQLite [#4684](https://togithub.com/knex/knex/issues/4684) - Add geometry column building [#4776](https://togithub.com/knex/knex/issues/4776) - Add support for creating table copies [#1373](https://togithub.com/knex/knex/issues/1373) - Implement support for views and materialized views [#1626](https://togithub.com/knex/knex/issues/1626) - Implement partial index support [#4768](https://togithub.com/knex/knex/issues/4768) - Support for 'is null' in 'order by' [#3667](https://togithub.com/knex/knex/issues/3667) ##### Bug fixes: - Fix support for Oracle connections passed via knex.connection() [#4757](https://togithub.com/knex/knex/issues/4757) - Avoid inserting multiple locks if a migration lock already exists [#4694](https://togithub.com/knex/knex/issues/4694) ##### Typings: - Some TableBuilder methods return wrong types [#4764](https://togithub.com/knex/knex/issues/4764) - Update JoinRaw bindings type to accept arrays [#4752](https://togithub.com/knex/knex/issues/4752) - fix onDelete/onUpdate for ColumnBuilder [#4656](https://togithub.com/knex/knex/issues/4656) ### [`v0.95.11`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#09511---03-September-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.10...0.95.11) ##### New features: - Add support for nullability modification via schema builder (table.setNullable() and table.dropNullable()) [#4657](https://togithub.com/knex/knex/issues/4657) - MySQL: Add support for mysql/mariadb-client JSON parameters in connectionURIs [#4629](https://togithub.com/knex/knex/issues/4629) - MSSQL: Support comments as MS_Description properties [#4632](https://togithub.com/knex/knex/issues/4632) ##### Bug fixes: - Fix Analytic orderBy and partitionBy to follow the SQL documentation [#4602](https://togithub.com/knex/knex/issues/4602) - CLI: fix migrate:up for migrations disabling transactions [#4550](https://togithub.com/knex/knex/issues/4550) - SQLite: Fix adding a column with a foreign key constraint in SQLite [#4649](https://togithub.com/knex/knex/issues/4649) - MSSQL: columnInfo() support case-sensitive database collations [#4633](https://togithub.com/knex/knex/issues/4633) - MSSQL: Generate valid SQL for withRecursive() [#4514](https://togithub.com/knex/knex/issues/4514) - Oracle: withRecursive: omit invalid RECURSIVE keyword, include column list [#4514](https://togithub.com/knex/knex/issues/4514) ##### Improvements: - Add .mjs migration and seed stubs [#4631](https://togithub.com/knex/knex/issues/4631) - SQLite: Clean up DDL handling and move all operations to the parser-based approach [#4648](https://togithub.com/knex/knex/issues/4648) ### [`v0.95.10`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#09510---20-August-2021) [Compare Source](https://togithub.com/knex/knex/compare/102a44d7a5fe641bdee8f7e66f6518f5418ff93e...0.95.10) ##### Improvements: - Use sys info function instead of connection db name [#4623](https://togithub.com/knex/knex/issues/4623) ##### Typings: - Deferrable and withkeyName should not be in ColumnBuilder [#4600](https://togithub.com/knex/knex/issues/4600) ### [`v0.95.9`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0959---31-July-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.8...102a44d7a5fe641bdee8f7e66f6518f5418ff93e) ##### New features: - Oracle: support specifying schema for dropTable and dropSequence [#4596](https://togithub.com/knex/knex/issues/4596) - Oracle: support specifying schema for autoincrement [#4594](https://togithub.com/knex/knex/issues/4594) ##### Typings: - Add TypeScript support for deferrable, new Primary/Unique syntax [#4589](https://togithub.com/knex/knex/issues/4589) ### [`v0.95.8`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0958---25-July-2021) [Compare Source](https://togithub.com/knex/knex/compare/3089d50ec9e7762e120af77a46d808162a048b0e...0.95.8) ##### New features: - Add deferrable support for constraint [#4584](https://togithub.com/knex/knex/issues/4584) - Implement delete with join [#4568](https://togithub.com/knex/knex/issues/4568) - Add DPI error codes for Oracle [#4536](https://togithub.com/knex/knex/issues/4536) ##### Bug fixes: - Fixing PostgreSQL datetime and timestamp column created with wrong format [#4578](https://togithub.com/knex/knex/issues/4578) ##### Typings: - Improve analytic types [#4576](https://togithub.com/knex/knex/issues/4576) - MSSQL: Add trustServerCertificate option [#4500](https://togithub.com/knex/knex/issues/4500) ### [`v0.95.7`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0957---10-July-2021) [Compare Source](https://togithub.com/knex/knex/compare/fff6eb15d7088d4198650a2c6e673dedaf3b8f36...3089d50ec9e7762e120af77a46d808162a048b0e) ##### New features: - Add ability to omit columns on an onConflict().ignore() [#4557](https://togithub.com/knex/knex/issues/4557) - CLI: Log error message [#4534](https://togithub.com/knex/knex/issues/4534) ##### Typings: - Export Knex.TransactionConfig [#4498](https://togithub.com/knex/knex/issues/4498) - Include options object in count(Distinct) typings [#4491](https://togithub.com/knex/knex/issues/4491) - Add types for analytic functions [#4544](https://togithub.com/knex/knex/issues/4544) ### [`v0.95.6`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0956---17-May-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.5...fff6eb15d7088d4198650a2c6e673dedaf3b8f36) ##### Typings: - Export TransactionProvider type [#4489](https://togithub.com/knex/knex/issues/4489) ### [`v0.95.5`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0955---11-May-2021) [Compare Source](https://togithub.com/knex/knex/compare/8cfad286f246aff7455784b51751fdd17ba24c4c...0.95.5) ##### New features: - SQLite: Add support for file open flags [#4446](https://togithub.com/knex/knex/issues/4446) - Add .cjs extension to Seeder.js to support Node ESM [#4381](https://togithub.com/knex/knex/issues/4381) [#4382](https://togithub.com/knex/knex/issues/4382) ##### Bug fixes: - Remove peerDependencies to avoid auto-install on npm 7 [#4480](https://togithub.com/knex/knex/issues/4480) ##### Typings: - Fix typing for increments and bigIncrements [#4406](https://togithub.com/knex/knex/issues/4406) - Add typings for on JoinClause for onVal [#4436](https://togithub.com/knex/knex/issues/4436) - Adding Type Definition for isTransaction [#4418](https://togithub.com/knex/knex/issues/4418) - Export client class from knex namespace [#4479](https://togithub.com/knex/knex/issues/4479) ### [`v0.95.4`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0954---26-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.3...8cfad286f246aff7455784b51751fdd17ba24c4c) ##### Typings: - Fix mistyping of stream [#4400](https://togithub.com/knex/knex/issues/4400) ### [`v0.95.3`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0953---25-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.2...0.95.3) ##### New features: - PostgreSQL: Add "same" as operator [#4372](https://togithub.com/knex/knex/issues/4372) - MSSQL: Improve an estimate of the max comment length [#4362](https://togithub.com/knex/knex/issues/4362) - Throw an error if negative offset is provided [#4361](https://togithub.com/knex/knex/issues/4361) ##### Bug fixes: - Fix timeout method [#4324](https://togithub.com/knex/knex/issues/4324) - SQLite: prevent dropForeign from being silently ignored [#4376](https://togithub.com/knex/knex/issues/4376) ##### Typings: - Allow config.client to be non-client instance [#4367](https://togithub.com/knex/knex/issues/4367) - Add dropForeign arg type for single column [#4363](https://togithub.com/knex/knex/issues/4363) - Update typings for TypePreservingAggregation and stream [#4377](https://togithub.com/knex/knex/issues/4377) ### [`v0.95.2`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0952---11-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/aa7121fa9823b982684c89b7fcb60166a845711a...0.95.2) ##### New features: - Improve ESM import support [#4350](https://togithub.com/knex/knex/issues/4350) ##### Bug fixes: - CLI: update ts.stub files to new TypeScript namespace [#4344](https://togithub.com/knex/knex/issues/4344) - CLI: fix TypeScript migration stub after 0.95.0 changes [#4366](https://togithub.com/knex/knex/issues/4366) ##### Typings: - Move QueryBuilder and KnexTimeoutError into knex namespace [#4358](https://togithub.com/knex/knex/issues/4358) ##### Test / internal changes: - Unify db test helpers [#4356](https://togithub.com/knex/knex/issues/4356) ### [`v0.95.1`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#09515---22-December-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.0...aa7121fa9823b982684c89b7fcb60166a845711a) ##### Bug fixes: - Oracle: - MariaDB: lock row fix during migration in MariaDB and Oracle [#4865](https://togithub.com/knex/knex/issues/4865) ### [`v0.95.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0950---03-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/823c7b60f74fb16bcb8a8230afe1fea6673c2bd0...0.95.0) Note: there are many breaking changes in this version, particularly in TypeScript support. Please see `UPGRADING.md` for details. ##### New features: - Add transaction isolation support [#4185](https://togithub.com/knex/knex/issues/4185) - Add analytic functions [#4188](https://togithub.com/knex/knex/issues/4188) - Change default to not trigger a promise rejection for transactions with a specified handler [#4195](https://togithub.com/knex/knex/issues/4195) - Make toSQL().toNative() work for Raw to match the API for QueryBuilder [#4058](https://togithub.com/knex/knex/issues/4058) - Allow 'match' operator [#3569](https://togithub.com/knex/knex/issues/3569) - Support optimizer hints [#4243](https://togithub.com/knex/knex/issues/4243) - Add parameter to prevent autoincrement columns from being primary keys [#4266](https://togithub.com/knex/knex/issues/4266) - Make "first" and "pluck" mutually exclusive [#4280](https://togithub.com/knex/knex/issues/4280) - Added merge strategy to allow selecting columns to upsert. [#4252](https://togithub.com/knex/knex/issues/4252) - Throw error if the array passed to insert is empty [#4289](https://togithub.com/knex/knex/issues/4289) - Events: introduce queryContext on query-error [#4301](https://togithub.com/knex/knex/issues/4301) - CLI: Use UTC timestamp for new migrations [#4245](https://togithub.com/knex/knex/issues/4245) - MSSQL: Replace MSSQL dialect with Tedious.js implementation [#2857](https://togithub.com/knex/knex/issues/2857) [#4281](https://togithub.com/knex/knex/issues/4281) - MSSQL: Use "nvarchar(max)" for ".json()" [#4278](https://togithub.com/knex/knex/issues/4278) - MSSQL: Schema builder - add predictable constraint names for default values [#4319](https://togithub.com/knex/knex/issues/4319) - MSSQL: Schema builder - attempt to drop default constraints when changing default value on columns [#4321](https://togithub.com/knex/knex/issues/4321) - SQLite: Fallback to json for sqlite3 when using jsonb [#4186](https://togithub.com/knex/knex/issues/4186) - SQLite: Return complete list of DDL commands for creating foreign keys [#4194](https://togithub.com/knex/knex/issues/4194) - SQLite: Support dropping composite foreign keys [#4202](https://togithub.com/knex/knex/issues/4202) - SQLite: Recreate indices when altering a table [#4277](https://togithub.com/knex/knex/issues/4277) - SQLite: Add support for altering columns [#4322](https://togithub.com/knex/knex/issues/4322) ##### Bug fixes: - Fix issue with .withSchema usage with joins on a subquery [#4267](https://togithub.com/knex/knex/issues/4267) - Fix issue with schema usage with FROM clause contain QueryBuilder, function or Raw [#4268](https://togithub.com/knex/knex/issues/4268) - CLI: Address raised security warnings by dropping liftoff [#4122](https://togithub.com/knex/knex/issues/4122) - CLI: Fix an issue with npm@7 and ESM when `type` was set to `'module'` in `package.json` [#4295](https://togithub.com/knex/knex/issues/4295) - PostgreSQL: Add check to only create native enum once [#3658](https://togithub.com/knex/knex/issues/3658) - SQLite: Fix foreign key "on delete" when altering a table [#4225](https://togithub.com/knex/knex/issues/4225) - SQLite: Made the constraint detection case-insensitive [#4330](https://togithub.com/knex/knex/issues/4330) - MySQL: Keep auto increment after rename [#4266](https://togithub.com/knex/knex/issues/4266) - MSSQL: don't raise query-error twice [#4314](https://togithub.com/knex/knex/issues/4314) - MSSQL: Alter column must have its own query [#4317](https://togithub.com/knex/knex/issues/4317) ##### Typings: - TypeScript 4.1+ is now required - Add missing onConflict overrides [#4182](https://togithub.com/knex/knex/issues/4182) - Introduce the "infamous triplet" export [#4181](https://togithub.com/knex/knex/issues/4181) - Fix type definition of Transaction [#4172](https://togithub.com/knex/knex/issues/4172) - Add typedefinitions for havingNotIn [#4265](https://togithub.com/knex/knex/issues/4265) - Include 'name' property in MigratorConfig [#4300](https://togithub.com/knex/knex/issues/4300) - Improve join and conflict types [#4318](https://togithub.com/knex/knex/issues/4318) - Fix ArrayIfAlready type [#4331](https://togithub.com/knex/knex/issues/4331) ##### Test / internal changes: - Drop global Knex.raw [#4180](https://togithub.com/knex/knex/issues/4180) - Stop using legacy url.parse API [#3702](https://togithub.com/knex/knex/issues/3702) - Various internal refactorings [#4175](https://togithub.com/knex/knex/issues/4175) [#4177](https://togithub.com/knex/knex/issues/4177) [#4178](https://togithub.com/knex/knex/issues/4178) [#4192](https://togithub.com/knex/knex/issues/4192) - Refactor to classes [#4190](https://togithub.com/knex/knex/issues/4190) [#4191](https://togithub.com/knex/knex/issues/4191) [#4193](https://togithub.com/knex/knex/issues/4193) [#4210](https://togithub.com/knex/knex/issues/4210) [#4253](https://togithub.com/knex/knex/issues/4253) - Move transaction type tests to TSD [#4208](https://togithub.com/knex/knex/issues/4208) - Clean up destroy logic [#4248](https://togithub.com/knex/knex/issues/4248) - Colorize code snippets in readme files [#4234](https://togithub.com/knex/knex/issues/4234) - Add "Ecosystem" documentation for Knex plugins [#4183](https://togithub.com/knex/knex/issues/4183) - Documentation cleanup - SQLite: Use SQLite "rename column" instead of a DDL helper [#4200](https://togithub.com/knex/knex/issues/4200) - SQLite: Simplify reinsert logic when altering a table [#4272](https://togithub.com/knex/knex/issues/4272) ### [`v0.21.21`](https://togithub.com/knex/knex/compare/4f0122283c8a7e3f2cc187d925e2bf1098c00bad...823c7b60f74fb16bcb8a8230afe1fea6673c2bd0) [Compare Source](https://togithub.com/knex/knex/compare/4f0122283c8a7e3f2cc187d925e2bf1098c00bad...823c7b60f74fb16bcb8a8230afe1fea6673c2bd0) ### [`v0.21.20`](https://togithub.com/knex/knex/compare/0d474aaab4546075013f5c198d0186f1b11fc57f...4f0122283c8a7e3f2cc187d925e2bf1098c00bad) [Compare Source](https://togithub.com/knex/knex/compare/0d474aaab4546075013f5c198d0186f1b11fc57f...4f0122283c8a7e3f2cc187d925e2bf1098c00bad) ### [`v0.21.19`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02119---02-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/d2f8a1b1d5d48a6e668f1fab39c08ce76daf587c...0d474aaab4546075013f5c198d0186f1b11fc57f) - SQLite: Made the constraint detection case-insensitive [#4332](https://togithub.com/knex/knex/issues/4332) ### [`v0.21.18`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02118---22-February-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.21.17...d2f8a1b1d5d48a6e668f1fab39c08ce76daf587c) - CLI: Fix an issue with npm@7 and ESM when type was set to 'module' in package.json [#4295](https://togithub.com/knex/knex/issues/4295) ### [`v0.21.17`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02117---30-January-2021) [Compare Source](https://togithub.com/knex/knex/compare/b2608569b4245d114248fa0e5bb0b328410ab717...0.21.17) ##### Bug fixes: - SQLite: Fix SQLite foreign on delete when altering a table [#4261](https://togithub.com/knex/knex/issues/4261) ##### New features: - Add support for optimizer hints (see [https://github.com/knex/documentation/pull/306](https://togithub.com/knex/documentation/pull/306) for documentation) [#4243](https://togithub.com/knex/knex/issues/4243) ### [`v0.21.16`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02116---17-January-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.21.15...b2608569b4245d114248fa0e5bb0b328410ab717) ##### Bug fixes: - MSSQL: Avoid passing unsupported pool param. Fixes node-mssql 7+ support [#4236](https://togithub.com/knex/knex/issues/4236) ### [`v0.21.15`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02115---26-December-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.14...0.21.15) ##### New features: - SQLite: Add primary/foreign support on alterTable [#4162](https://togithub.com/knex/knex/issues/4162) - SQLite: Add dropPrimary/dropForeign support on alterTable [#4162](https://togithub.com/knex/knex/issues/4162) ##### Typings: - Add "after" and "first" to columnBuilder types [#3549](https://togithub.com/knex/knex/issues/3549) [#4169](https://togithub.com/knex/knex/issues/4169) ##### Test / internal changes: - Extract knex config resolution logic [#4166](https://togithub.com/knex/knex/issues/4166) - Run CI using GitHub Actions [#4168](https://togithub.com/knex/knex/issues/4168) - Add Node.js 15 to CI matrix [#4173](https://togithub.com/knex/knex/issues/4173) ### [`v0.21.14`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02114---18-December-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.13...0.21.14) ##### New features: - MSSQL: support "returning" on inserts, updates and deletes on tables with triggers [#4152](https://togithub.com/knex/knex/issues/4152) - Use esm import if package.json type is "module" [#4158](https://togithub.com/knex/knex/issues/4158) ##### Bug fixes: - Make sure query-response and query-error events contain \_knexTxId [#4160](https://togithub.com/knex/knex/issues/4160) ##### Test / internal changes: - Improved integration test framework [#4161](https://togithub.com/knex/knex/issues/4161) ### [`v0.21.13`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02113---12-December-2020) [Compare Source](https://togithub.com/knex/knex/compare/90b145dc84b1281b985fa5cedd09b8cb362add9e...0.21.13) ##### New features: - SQLite: Add support for `dropForeign` [#4092](https://togithub.com/knex/knex/issues/4092) - Add support for WHERE clauses to "upsert" queries [#4148](https://togithub.com/knex/knex/issues/4148) ##### Bug fixes: - MSSQL: Avoid connection getting stuck on socket hangup [#4157](https://togithub.com/knex/knex/issues/4157) - Oracle: Support specifying non-default DB port [#4147](https://togithub.com/knex/knex/issues/4147) - Oracle: Support inserts with only default values (empty body) [#4092](https://togithub.com/knex/knex/issues/4092) - CLI: fix irregular seed file execution order [#4156](https://togithub.com/knex/knex/issues/4156) - Fix performance of asyncStackTraces with enable-source-maps node flag [#4154](https://togithub.com/knex/knex/issues/4154) ##### Typings: - PostgreSQL: Add support for application_name [#4153](https://togithub.com/knex/knex/issues/4153) - Fix types for insert to allow array [#4105](https://togithub.com/knex/knex/issues/4105) - Add types for userParams and withUserParams [#4119](https://togithub.com/knex/knex/issues/4119) - Added type for withKeyName [#4139](https://togithub.com/knex/knex/issues/4139) - Fix batchInsert definitions [#4131](https://togithub.com/knex/knex/issues/4131) - Fix types for WhereIn signature (value or query builder) [#3863](https://togithub.com/knex/knex/issues/3863) - Add types for connection config of mysql2 driver [#4144](https://togithub.com/knex/knex/issues/4144) ##### Test / internal changes: - Move TS tests to tsd (WIP) [#4109](https://togithub.com/knex/knex/issues/4109) [#4110](https://togithub.com/knex/knex/issues/4110) ### [`v0.21.12`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02112---02-November-2020) [Compare Source](https://togithub.com/knex/knex/compare/4cfb3ea17b8580d370f096807b7f8954a32a5f89...90b145dc84b1281b985fa5cedd09b8cb362add9e) ##### Typings: - Reintroduce support for globally defining table/record mapping [#4100](https://togithub.com/knex/knex/issues/4100) - Add a few missing types for MSSQL Connection [#4103](https://togithub.com/knex/knex/issues/4103) - Make .ignore() and .merge() return QueryBuilder rather than QueryInterface [#4102](https://togithub.com/knex/knex/issues/4102) - Use tarn config TS types instead of generic-pool [#4064](https://togithub.com/knex/knex/issues/4064) ### [`v0.21.11`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02111---01-November-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.10...4cfb3ea17b8580d370f096807b7f8954a32a5f89) ##### Typings: - Revert support for globally defining table/record mapping [#4099](https://togithub.com/knex/knex/issues/4099) ### [`v0.21.10`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02110---31-October-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.9...0.21.10) ##### New features: - Upsert support (Postgres/MySQL/Sqlite) [#3763](https://togithub.com/knex/knex/issues/3763) ##### Bug fixes: - Switch to non-uuid knexQueryUids to avoid issues when mocking global date [#4089](https://togithub.com/knex/knex/issues/4089) ##### Typings: - Allow to globally define table/record mapping [#4071](https://togithub.com/knex/knex/issues/4071) ### [`v0.21.9`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0219---27-October-2020) [Compare Source](https://togithub.com/knex/knex/compare/2bcaf51f9d025c9c8631e357da16e3cb3224792c...0.21.9) ##### New features: - add method clear(statement) to QueryBuilder [#4051](https://togithub.com/knex/knex/issues/4051) ##### Bug fixes: - CLI: fix help text being printed twice [#4072](https://togithub.com/knex/knex/issues/4072) - Oracle: columnInfo() no longer requires an Owner User [#4053](https://togithub.com/knex/knex/issues/4053) - Add missing "start" event propagation from transaction [#4087](https://togithub.com/knex/knex/issues/4087) ### [`v0.21.8`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0218---27-October-2020) [Compare Source](https://togithub.com/knex/knex/compare/23073fa83dfb4bf0ecb204c9ae1f720cd22f41ed...2bcaf51f9d025c9c8631e357da16e3cb3224792c) ##### Bug fixes: - MSSQL: Escape properly if literal '?' is needed [#4053](https://togithub.com/knex/knex/issues/4053) - Make toQuery behavior consistent with pre-0.21.7 (do not break on empty builder) [#4083](https://togithub.com/knex/knex/issues/4083) - Fix comment escaping for MySQL and PostgreSQL [#4084](https://togithub.com/knex/knex/issues/4084) ### [`v0.21.7`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0217---25-October-2020) [Compare Source](https://togithub.com/knex/knex/compare/7cfb78d16aa9dcd635c9ae1862837ccd4f507a21...23073fa83dfb4bf0ecb204c9ae1f720cd22f41ed) ##### New features: - CLI: Add migration stub for .cjs extension [#4065](https://togithub.com/knex/knex/issues/4065) ##### Bug fixes: - MSSQL: Add dynamic scaling for decimal values and prevents a UInt64 overflow [#3910](https://togithub.com/knex/knex/issues/3910) - MSSQL: Fix apostrophe escaping [#4077](https://togithub.com/knex/knex/issues/4077) - Ensure that semicolon is not appended to statements that already end with a semicolon [#4052](https://togithub.com/knex/knex/issues/4052) ##### Typings: - Add arguments to QueryCallback in Where [#4034](https://togithub.com/knex/knex/issues/4034) ##### Test / internal changes: - Replace lodash type-checks with native solutions [#4056](https://togithub.com/knex/knex/issues/4056) - Replace mkdirp with native recursive flag [#4060](https://togithub.com/knex/knex/issues/4060) - Replace inherits package with builtin utility [#4059](https://togithub.com/knex/knex/issues/4059) ### [`v0.21.6`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0216---27-September-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.5...7cfb78d16aa9dcd635c9ae1862837ccd4f507a21) ##### New features: - CLI: New config parameter / CLI flag to prefixing seed filename with timestamp [#3873](https://togithub.com/knex/knex/issues/3873) - CLI: throw an error when specific seed file cannot be found [#4011](https://togithub.com/knex/knex/issues/4011) - Warn if whereNot is used with 'in' or 'between' [#4038](https://togithub.com/knex/knex/issues/4038) ##### Bug fixes: - CLI: Fix double merging of config for migrator [#4040](https://togithub.com/knex/knex/issues/4040) ##### Typings: - Unify SeedsConfig and SeederConfig [#4003](https://togithub.com/knex/knex/issues/4003) - Allow string\[] type for directory in SeedsConfig [#4033](https://togithub.com/knex/knex/issues/4033) ### [`v0.21.5`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0215---17-August-2020) [Compare Source](https://togithub.com/knex/knex/compare/b2e3c5c4d9d3c587e4f3602e8ddd07096cdab46b...0.21.5) ##### New features: - CLI: Improve Esm interop [#3985](https://togithub.com/knex/knex/issues/3985) - CLI: Improve mjs module support [#3980](https://togithub.com/knex/knex/issues/3980) ##### Test / internal changes: - Bump version of dtslint [#3984](https://togithub.com/knex/knex/issues/3984) - Test/document esm interop mixed formats (knexfile/migrations/seeds) [#3986](https://togithub.com/knex/knex/issues/3986) ### [`v0.21.4`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0214---10-August-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.3...b2e3c5c4d9d3c587e4f3602e8ddd07096cdab46b) ##### New features: - CLI: Add new option for seed: recursive [#3974](https://togithub.com/knex/knex/issues/3974) ##### Bug fixes: - CLI: Do not load seeds from subfolders recursively by default [#3974](https://togithub.com/knex/knex/issues/3974) ### [`v0.21.3`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0213---08-August-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.2...0.21.3) ##### New features: - CLI: Support multiple directories for seeds [#3967](https://togithub.com/knex/knex/issues/3967) ##### Bug fixes: - Ensure DB stream is destroyed when the PassThrough is destroyed [#2324](https://togithub.com/knex/knex/issues/2324) - Support postProcessResponse for streams [#3931](https://togithub.com/knex/knex/issues/3931) - Fix ESM module interop for calling module/package of type 'module' [#3938](https://togithub.com/knex/knex/issues/3938) - CLI: Fix migration source name in rollback all [#3956](https://togithub.com/knex/knex/issues/3956) - Fix getMergedConfig calls to include client logger [#3920](https://togithub.com/knex/knex/issues/3920) - Escape single quoted values passed to defaultTo function [#3899](https://togithub.com/knex/knex/issues/3899) ##### Typings: - Add .timeout(ms) to .raw()'s typescript typings [#3885](https://togithub.com/knex/knex/issues/3885) - Add typing for double table column builder [#3950](https://togithub.com/knex/knex/issues/3950) - Add a phantom tag to Ref type to mark received type parameters as used [#3934](https://togithub.com/knex/knex/issues/3934) - Add `null` as valid binding type [#3946](https://togithub.com/knex/knex/issues/3946) ##### Test / internal changes: - Change query lab link to https [#3933](https://togithub.com/knex/knex/issues/3933) ### [`v0.21.2`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0212---10-July-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.1...0.21.2) ##### New features: - Warn user if custom migration source is being reset [#3839](https://togithub.com/knex/knex/issues/3839) - Prefer `void` as return type on migration generator ts stub [#3865](https://togithub.com/knex/knex/issues/3865) - MSSQL: Added the removal of a columns default constraint, before dropping the column [#3855](https://togithub.com/knex/knex/issues/3855) ##### Typings: - Fix definition for raw querybuilders [#3846](https://togithub.com/knex/knex/issues/3846) ##### Test / internal changes: - Refactor migration logic to use async/await [#3838](https://togithub.com/knex/knex/issues/3838) ### [`v0.21.1`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02119---02-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.21.0...0.21.1) - SQLite: Made the constraint detection case-insensitive [#4332](https://togithub.com/knex/knex/issues/4332) ### [`v0.21.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0210---18-April-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.20.15...0.21.0) ##### Improvements - Reduce size of lodash in bundle [#3804](https://togithub.com/knex/knex/issues/3804) ##### Breaking changes - Dropped support for Node 8 - Breaking upstream change in `pg-query-stream`: `Changed stream.close to stream.destroy which is the official way to terminate a readable stream. This is a breaking change if you rely on the stream.close method on pg-query-stream...though should be just a find/replace type operation to upgrade as the semantics remain very similar (not exactly the same, since internals are rewritten, but more in line with how streams are "supposed" to behave).` ##### Test / internal changes: - Updated Tarn.js to a version 3.0.0 - Updated mkdirp to a version 1.0.4 - Updated examples to use ES2015 style [#3810](https://togithub.com/knex/knex/issues/3810) ### [`v0.20.15`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02015---16-April-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.20.14...0.20.15) ##### Bug fixes: - Support for `.finally(..)` on knex's Promise-alikes [#3800](https://togithub.com/knex/knex/issues/3800) ##### Typings: - Add types for `.distinctOn` [#3784](https://togithub.com/knex/knex/issues/3784) ### [`v0.20.14`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02014---13-April-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.20.13...0.20.14) ##### New features: - CLI: adds support for asynchronous knexfile loading [#3748](https://togithub.com/knex/knex/issues/3748) - Add clearGroup method [#3771](https://togithub.com/knex/knex/issues/3771) ##### Typings: - Support Raw types for insert, where, update [#3730](https://togithub.com/knex/knex/issues/3730) - Add typings for MigrationSource [#3756](https://togithub.com/knex/knex/issues/3756) - Update signature of orderBy to support QueryBuilder inside array [#3757](https://togithub.com/knex/knex/issues/3757) - Add toSQL and toString to SchemaBuilder [#3758](https://togithub.com/knex/knex/issues/3758) - `interface Knex` and `function Knex` should have the same types [#3787](https://togithub.com/knex/knex/issues/3787) - Fix minor issues around typings [#3765](https://togithub.com/knex/knex/issues/3765) ##### Test / internal changes: - Minor test internal enhancements [#3747](https://togithub.com/knex/knex/issues/3747) - Minor improvements on the usage of fs utilities [#3749](https://togithub.com/knex/knex/issues/3749) - Split tests in groups [#3785](https://togithub.com/knex/knex/issues/3785) ### [`v0.20.13`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02013---23-March-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.20.12...0.20.13) ##### Bug fixes: - Correctly handle dateToString escaping without timezone passed [#3742](https://togithub.com/knex/knex/issues/3742) - Make protocol length check more defensive [#3744](https://togithub.com/knex/knex/issues/3744) ##### Typings: - Make the ChainableInterface conform to PromiseConfiguration
📅 Schedule: Branch creation - "before 2pm on Tuesday,before 2pm on Friday" in timezone Europe/Stockholm, 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.