renovate[bot]
commented
3 years ago Renovate Ignore Notification
As this PR has been closed unmerged, Renovate will now ignore this update (0.95.13). You will still receive a PR once a newer version is released, so if you wish to permanently ignore this dependency, please add it to the ignoreDeps array of your renovate config.
If this PR was closed by mistake or you changed your mind, you can simply rename this PR and you will soon get a fresh replacement PR opened.
This PR contains the following updates:
0.21.21->0.95.13Release Notes
knex/knex
### [`v0.95.13`](https://togithub.com/knex/knex/compare/0.95.12...29ac476b2bfe7593118da2884fae23a2e6004414) [Compare Source](https://togithub.com/knex/knex/compare/0.95.12...29ac476b2bfe7593118da2884fae23a2e6004414) ### [`v0.95.12`](https://togithub.com/knex/knex/blob/master/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/master/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/master/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/master/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/master/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/master/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/master/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/master/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/master/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/master/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/master/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/master/CHANGELOG.md#09511---03-September-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.0...aa7121fa9823b982684c89b7fcb60166a845711a) ##### 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.0`](https://togithub.com/knex/knex/blob/master/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)Configuration
📅 Schedule: 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 WhiteSource Renovate. View repository job log here.