search

pawiromitchel / resty

A REST builder with Node.js 🚀🏗
MIT License
7 stars 0 forks source link

Update dependency sequelize to v5 [SECURITY] #31

Closed renovate[bot] closed 5 years ago

renovate[bot] commented 5 years ago

This PR contains the following updates:

Package Type Update Change References
sequelize dependencies major ^4.41.1 -> ^5.0.0 homepage, source

GitHub Vulnerability Alerts

CVE-2019-11069

Sequelize before 5.3.0 does not properly ensure that standard conforming strings are used.

Release Notes

sequelize/sequelize ### [`v5.8.7`](https://togithub.com/sequelize/sequelize/releases/v5.8.7) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.8.6...v5.8.7) ##### Bug Fixes - **types:** add beforeSave and afterSave typings ([#​10987](https://togithub.com/sequelize/sequelize/issues/10987)) ([0569f42](https://togithub.com/sequelize/sequelize/commit/0569f42)) - correct grammar ([#​10981](https://togithub.com/sequelize/sequelize/issues/10981)) ([41985c5](https://togithub.com/sequelize/sequelize/commit/41985c5)) - **types:** add missing alter option ([#​10939](https://togithub.com/sequelize/sequelize/issues/10939)) ([30c5ca5](https://togithub.com/sequelize/sequelize/commit/30c5ca5)) - **types:** add missing types to SyncOptions ([#​10948](https://togithub.com/sequelize/sequelize/issues/10948)) ([2f7b32b](https://togithub.com/sequelize/sequelize/commit/2f7b32b)) ### [`v5.8.6`](https://togithub.com/sequelize/sequelize/releases/v5.8.6) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.8.5...v5.8.6) ##### Bug Fixes - **types:** add poolable to count options ([#​10938](https://togithub.com/sequelize/sequelize/issues/10938)) ([b3d2849](https://togithub.com/sequelize/sequelize/commit/b3d2849)) ### [`v5.8.5`](https://togithub.com/sequelize/sequelize/releases/v5.8.5) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.8.4...v5.8.5) ##### Bug Fixes - **ci:** flaky tests and dead code ([5f9d590](https://togithub.com/sequelize/sequelize/commit/5f9d590)) ### [`v5.8.4`](https://togithub.com/sequelize/sequelize/releases/v5.8.4) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.8.3...v5.8.4) ##### Bug Fixes - **typings:** use correct set of allowed options for addIndex ([#​10885](https://togithub.com/sequelize/sequelize/issues/10885)) ([8662fc8](https://togithub.com/sequelize/sequelize/commit/8662fc8)) ### [`v5.8.3`](https://togithub.com/sequelize/sequelize/releases/v5.8.3) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.8.2...v5.8.3) ##### Bug Fixes - **querying:** treat having the same as where when using scopes ([#​10884](https://togithub.com/sequelize/sequelize/issues/10884)) ([15354c7](https://togithub.com/sequelize/sequelize/commit/15354c7)) ### [`v5.8.2`](https://togithub.com/sequelize/sequelize/releases/v5.8.2) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.8.1...v5.8.2) ##### Bug Fixes - **querying:** prevent `having` clause from cascading ([#​10859](https://togithub.com/sequelize/sequelize/issues/10859)) ([1b8c389](https://togithub.com/sequelize/sequelize/commit/1b8c389)) - **sync:** handle alter correctly with underscored/aliased columns ([#​10872](https://togithub.com/sequelize/sequelize/issues/10872)) ([4de34c5](https://togithub.com/sequelize/sequelize/commit/4de34c5)) - **types:** add dialectModule types ([#​10863](https://togithub.com/sequelize/sequelize/issues/10863)) ([48eafaa](https://togithub.com/sequelize/sequelize/commit/48eafaa)) - **types:** add duplicating option ([#​10871](https://togithub.com/sequelize/sequelize/issues/10871)) ([42927d3](https://togithub.com/sequelize/sequelize/commit/42927d3)) - **types:** add Model#addScope overload ([5767fba](https://togithub.com/sequelize/sequelize/commit/5767fba)) - **types:** add random function to sequelize ([dc41875](https://togithub.com/sequelize/sequelize/commit/dc41875)) ### [`v5.8.1`](https://togithub.com/sequelize/sequelize/releases/v5.8.1) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.8.0...v5.8.1) ##### Bug Fixes - **types:** add validate option to CreateOptions ([bf4700b](https://togithub.com/sequelize/sequelize/commit/bf4700b)) ### [`v5.8.0`](https://togithub.com/sequelize/sequelize/releases/v5.8.0) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.7.6...v5.8.0) ##### Bug Fixes - **associations:** check presence of multi-joined instances ([#​10853](https://togithub.com/sequelize/sequelize/issues/10853)) ([32be061](https://togithub.com/sequelize/sequelize/commit/32be061)) ##### Features - **typings:** add some missing operators ([#​10846](https://togithub.com/sequelize/sequelize/issues/10846)) ([ba5192c](https://togithub.com/sequelize/sequelize/commit/ba5192c)) ### [`v5.7.6`](https://togithub.com/sequelize/sequelize/releases/v5.7.6) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.7.5...v5.7.6) ##### Bug Fixes - **typings:** types for addIndex ([#​10844](https://togithub.com/sequelize/sequelize/issues/10844)) ([5412ade](https://togithub.com/sequelize/sequelize/commit/5412ade)) ### [`v5.7.5`](https://togithub.com/sequelize/sequelize/releases/v5.7.5) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.7.4...v5.7.5) ##### Bug Fixes - **model:** make aggregate merge attributes rather than override ([#​10662](https://togithub.com/sequelize/sequelize/issues/10662)) ([379b56c](https://togithub.com/sequelize/sequelize/commit/379b56c)), closes [/github.com/sequelize/sequelize/commit/88a340dacec0b1b27d4f67866e2b416482ce7b85#diff-a140b60b6a99a8c69f4b5d0d1f1f2bfaR1964](https://togithub.com//github.com/sequelize/sequelize/commit/88a340dacec0b1b27d4f67866e2b416482ce7b85/issues/diff-a140b60b6a99a8c69f4b5d0d1f1f2bfaR1964) - **types:** reorder model.get overload ([#​10797](https://togithub.com/sequelize/sequelize/issues/10797)) ([8d1972f](https://togithub.com/sequelize/sequelize/commit/8d1972f)) ### [`v5.7.4`](https://togithub.com/sequelize/sequelize/releases/v5.7.4) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.7.3...v5.7.4) ##### Bug Fixes - **redshift:** allow standard_conforming_strings option ([#​10816](https://togithub.com/sequelize/sequelize/issues/10816)) ([2bb6098](https://togithub.com/sequelize/sequelize/commit/2bb6098)) ### [`v5.7.3`](https://togithub.com/sequelize/sequelize/releases/v5.7.3) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.7.2...v5.7.3) ##### Bug Fixes - **types:** add index hints ([#​10815](https://togithub.com/sequelize/sequelize/issues/10815)) ([99f396c](https://togithub.com/sequelize/sequelize/commit/99f396c)) - **types:** adding upsert with returning: true ([#​10800](https://togithub.com/sequelize/sequelize/issues/10800)) ([030e0fa](https://togithub.com/sequelize/sequelize/commit/030e0fa)) ### [`v5.7.2`](https://togithub.com/sequelize/sequelize/releases/v5.7.2) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.7.1...v5.7.2) ##### Bug Fixes - **types:** add Paranoid to Includeable ([#​10804](https://togithub.com/sequelize/sequelize/issues/10804)) ([2c06293](https://togithub.com/sequelize/sequelize/commit/2c06293)) ### [`v5.7.1`](https://togithub.com/sequelize/sequelize/releases/v5.7.1) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.7.0...v5.7.1) ##### Bug Fixes - **types:** add using & operator index interface ([#​10813](https://togithub.com/sequelize/sequelize/issues/10813)) ([3926991](https://togithub.com/sequelize/sequelize/commit/3926991)) - **types:** scope typing ([#​10803](https://togithub.com/sequelize/sequelize/issues/10803)) ([032d996](https://togithub.com/sequelize/sequelize/commit/032d996)) ### [`v5.7.0`](https://togithub.com/sequelize/sequelize/releases/v5.7.0) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.6.1...v5.7.0) ##### Bug Fixes - **instance:** isSoftDelete true after creating ([#​10799](https://togithub.com/sequelize/sequelize/issues/10799)) ([c44c72a](https://togithub.com/sequelize/sequelize/commit/c44c72a)) - **mssql:** describeTable for VARCHAR(MAX) ([#​10795](https://togithub.com/sequelize/sequelize/issues/10795)) ([d1645f2](https://togithub.com/sequelize/sequelize/commit/d1645f2)) ##### Features - **types:** adding Literal type to Operators ([#​10796](https://togithub.com/sequelize/sequelize/issues/10796)) ([e3d6795](https://togithub.com/sequelize/sequelize/commit/e3d6795)) ### [`v5.6.1`](https://togithub.com/sequelize/sequelize/releases/v5.6.1) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.6.0...v5.6.1) ##### Bug Fixes - **model:** handle virtual attributes in includes ([#​10785](https://togithub.com/sequelize/sequelize/issues/10785)) ([4cc7dc8](https://togithub.com/sequelize/sequelize/commit/4cc7dc8)) ### [`v5.6.0`](https://togithub.com/sequelize/sequelize/releases/v5.6.0) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.5.1...v5.6.0) ##### Features - **mysql:** indexHints support ([#​10756](https://togithub.com/sequelize/sequelize/issues/10756)) ([720f7ec](https://togithub.com/sequelize/sequelize/commit/720f7ec)) ### [`v5.5.1`](https://togithub.com/sequelize/sequelize/releases/v5.5.1) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.5.0...v5.5.1) ##### Bug Fixes - **typings:** add OptimisticLockError type ([#​10777](https://togithub.com/sequelize/sequelize/issues/10777)) ([f4a46dc](https://togithub.com/sequelize/sequelize/commit/f4a46dc)) ### [`v5.5.0`](https://togithub.com/sequelize/sequelize/releases/v5.5.0) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.4.0...v5.5.0) ##### Features - **sync:** allow altering comments ([#​10758](https://togithub.com/sequelize/sequelize/issues/10758)) ([2c18e08](https://togithub.com/sequelize/sequelize/commit/2c18e08)) ### [`v5.4.0`](https://togithub.com/sequelize/sequelize/releases/v5.4.0) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.3.5...v5.4.0) ##### Bug Fixes - **typings:** extend FindOptions with QueryOptions ([#​10766](https://togithub.com/sequelize/sequelize/issues/10766)) ([2f6e01b](https://togithub.com/sequelize/sequelize/commit/2f6e01b)) ##### Features - **typings:** model.count with group by ([#​10763](https://togithub.com/sequelize/sequelize/issues/10763)) ([638b13b](https://togithub.com/sequelize/sequelize/commit/638b13b)) ### [`v5.3.5`](https://togithub.com/sequelize/sequelize/releases/v5.3.5) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.3.4...v5.3.5) ##### Bug Fixes - **mssql:** unexpected error event when connect fails, crashing node process ([#​10762](https://togithub.com/sequelize/sequelize/issues/10762)) ([7a6c60d](https://togithub.com/sequelize/sequelize/commit/7a6c60d)) ### [`v5.3.4`](https://togithub.com/sequelize/sequelize/releases/v5.3.4) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.3.3...v5.3.4) ##### Bug Fixes - **associations:** fix foreign key with a targetkey on table without pk or with unique key ([#​10654](https://togithub.com/sequelize/sequelize/issues/10654)) ([e879460](https://togithub.com/sequelize/sequelize/commit/e879460)) ### [`v5.3.3`](https://togithub.com/sequelize/sequelize/releases/v5.3.3) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.3.2...v5.3.3) ##### Bug Fixes - **querying:** swap startWith and endsWith operators ([#​10753](https://togithub.com/sequelize/sequelize/issues/10753)) ([e33462a](https://togithub.com/sequelize/sequelize/commit/e33462a)) - **types:** uniqueKey support for BelongsToManyOptions interface ([#​10751](https://togithub.com/sequelize/sequelize/issues/10751)) ([0caf84b](https://togithub.com/sequelize/sequelize/commit/0caf84b)) ### [`v5.3.2`](https://togithub.com/sequelize/sequelize/releases/v5.3.2) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.3.1...v5.3.2) ##### Bug Fixes - **postgres:** rename debug context ([#​10752](https://togithub.com/sequelize/sequelize/issues/10752)) ([728707c](https://togithub.com/sequelize/sequelize/commit/728707c)), closes [#​10630](https://togithub.com/sequelize/sequelize/issues/10630) ### [`v5.3.1`](https://togithub.com/sequelize/sequelize/releases/v5.3.1) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.3.0...v5.3.1) ##### Bug Fixes - **types:** replication options ([#​10741](https://togithub.com/sequelize/sequelize/issues/10741)) ([504034c](https://togithub.com/sequelize/sequelize/commit/504034c)) ### [`v5.3.0`](https://togithub.com/sequelize/sequelize/releases/v5.3.0) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.15...v5.3.0) ##### Features - **security(postgres):** enable standard conforming strings when required ([#​10746](https://togithub.com/sequelize/sequelize/issues/10746)) ([850c7fd](https://togithub.com/sequelize/sequelize/commit/850c7fd)) ### [`v5.2.15`](https://togithub.com/sequelize/sequelize/releases/v5.2.15) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.14...v5.2.15) ##### Bug Fixes - **types:** add regex operators to WhereOperators ([#​10738](https://togithub.com/sequelize/sequelize/issues/10738)) ([3dbb318](https://togithub.com/sequelize/sequelize/commit/3dbb318)) ### [`v5.2.14`](https://togithub.com/sequelize/sequelize/releases/v5.2.14) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.13...v5.2.14) ##### Bug Fixes - **types:** add models property to sequelize class ([#​10736](https://togithub.com/sequelize/sequelize/issues/10736)) ([4d5be9a](https://togithub.com/sequelize/sequelize/commit/4d5be9a)) - **types:** enhance having parameters ([#​10733](https://togithub.com/sequelize/sequelize/issues/10733)) ([f6dd943](https://togithub.com/sequelize/sequelize/commit/f6dd943)) ### [`v5.2.13`](https://togithub.com/sequelize/sequelize/releases/v5.2.13) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.12...v5.2.13) ##### Bug Fixes - **mariadb:** named timezone support ([#​10705](https://togithub.com/sequelize/sequelize/issues/10705)) ([175da2d](https://togithub.com/sequelize/sequelize/commit/175da2d)) - **query:** add escape of null character for postgres bind parameters ([#​10716](https://togithub.com/sequelize/sequelize/issues/10716)) ([d6daaf1](https://togithub.com/sequelize/sequelize/commit/d6daaf1)) - **query-generator:** handle field names in scope include ([#​10718](https://togithub.com/sequelize/sequelize/issues/10718)) ([4c9d18f](https://togithub.com/sequelize/sequelize/commit/4c9d18f)) - **types:** add parent transaction and enhance `where` parameters ([#​10726](https://togithub.com/sequelize/sequelize/issues/10726)) ([47c5f30](https://togithub.com/sequelize/sequelize/commit/47c5f30)) ### [`v5.2.12`](https://togithub.com/sequelize/sequelize/releases/v5.2.12) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.11...v5.2.12) ##### Bug Fixes - **types:** add basic support for `bind` in sequelize.query() method ([#​10694](https://togithub.com/sequelize/sequelize/issues/10694)) ([b6c9117](https://togithub.com/sequelize/sequelize/commit/b6c9117)) ### [`v5.2.11`](https://togithub.com/sequelize/sequelize/releases/v5.2.11) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.10...v5.2.11) ##### Bug Fixes - **types:** add missing useCLS static ([#​10693](https://togithub.com/sequelize/sequelize/issues/10693)) ([6b65998](https://togithub.com/sequelize/sequelize/commit/6b65998)) ### [`v5.2.10`](https://togithub.com/sequelize/sequelize/releases/v5.2.10) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.9...v5.2.10) ##### Bug Fixes - **scope:** conform includes correctly ([#​10691](https://togithub.com/sequelize/sequelize/issues/10691)) ([061787f](https://togithub.com/sequelize/sequelize/commit/061787f)) ### [`v5.2.9`](https://togithub.com/sequelize/sequelize/releases/v5.2.9) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.8...v5.2.9) ##### Bug Fixes - **types:** add version property to init options ([#​10681](https://togithub.com/sequelize/sequelize/issues/10681)) ([0f505ef](https://togithub.com/sequelize/sequelize/commit/0f505ef)) ### [`v5.2.8`](https://togithub.com/sequelize/sequelize/releases/v5.2.8) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.7...v5.2.8) ##### Bug Fixes - **typings:** add missing sourceKey option in HasOneOptions association type ([#​10651](https://togithub.com/sequelize/sequelize/issues/10651)) ([5a2c6a6](https://togithub.com/sequelize/sequelize/commit/5a2c6a6)) - **typings:** remove lib/model double export ([#​10665](https://togithub.com/sequelize/sequelize/issues/10665)) ([26ec367](https://togithub.com/sequelize/sequelize/commit/26ec367)) ### [`v5.2.7`](https://togithub.com/sequelize/sequelize/releases/v5.2.7) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.6...v5.2.7) ##### Bug Fixes - **model:** map fields only once when saving ([#​10658](https://togithub.com/sequelize/sequelize/issues/10658)) ([ea5afbf](https://togithub.com/sequelize/sequelize/commit/ea5afbf)) - **typings:** upsert options ([#​10655](https://togithub.com/sequelize/sequelize/issues/10655)) ([a676eea](https://togithub.com/sequelize/sequelize/commit/a676eea)) ### [`v5.2.6`](https://togithub.com/sequelize/sequelize/releases/v5.2.6) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.5...v5.2.6) ##### Bug Fixes - **typings:** add modelName to InitOptions ([#​10648](https://togithub.com/sequelize/sequelize/issues/10648)) ([d8345dc](https://togithub.com/sequelize/sequelize/commit/d8345dc)) ### [`v5.2.5`](https://togithub.com/sequelize/sequelize/releases/v5.2.5) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.4...v5.2.5) ##### Bug Fixes - **data-types:** keep options for array type ([#​10645](https://togithub.com/sequelize/sequelize/issues/10645)) ([258776a](https://togithub.com/sequelize/sequelize/commit/258776a)) ### [`v5.2.4`](https://togithub.com/sequelize/sequelize/releases/v5.2.4) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.3...v5.2.4) ##### Bug Fixes - **mysql:** boolean TINYINT support ([#​10644](https://togithub.com/sequelize/sequelize/issues/10644)) ([9757d24](https://togithub.com/sequelize/sequelize/commit/9757d24)) ### [`v5.2.3`](https://togithub.com/sequelize/sequelize/releases/v5.2.3) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.2...v5.2.3) ##### Bug Fixes - **typings:** sequelize.close returns promise ([#​10639](https://togithub.com/sequelize/sequelize/issues/10639)) ([a421c35](https://togithub.com/sequelize/sequelize/commit/a421c35)) ### [`v5.2.2`](https://togithub.com/sequelize/sequelize/releases/v5.2.2) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.1...v5.2.2) ##### Bug Fixes - **associations:** symmetric getters/setters on foreign keys ([#​10635](https://togithub.com/sequelize/sequelize/issues/10635)) ([917b5bd](https://togithub.com/sequelize/sequelize/commit/917b5bd)) - **typings:** addConstraint ([#​10634](https://togithub.com/sequelize/sequelize/issues/10634)) ([4a0f41c](https://togithub.com/sequelize/sequelize/commit/4a0f41c)) ### [`v5.2.1`](https://togithub.com/sequelize/sequelize/releases/v5.2.1) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.2.0...v5.2.1) ##### Bug Fixes - **postgres:** quote trigger query identifiers ([#​10632](https://togithub.com/sequelize/sequelize/issues/10632)) ([d43f162](https://togithub.com/sequelize/sequelize/commit/d43f162)) ### [`v5.2.0`](https://togithub.com/sequelize/sequelize/releases/v5.2.0) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.1.1...v5.2.0) ##### Bug Fixes - **associations:** correctly parse include options ([#​10580](https://togithub.com/sequelize/sequelize/issues/10580)) ([ef18710](https://togithub.com/sequelize/sequelize/commit/ef18710)) - **query-generator:** convert numbers to date types ([#​10569](https://togithub.com/sequelize/sequelize/issues/10569)) ([b6f04ac](https://togithub.com/sequelize/sequelize/commit/b6f04ac)) - **typings:** correct return type for model.schema() ([#​10624](https://togithub.com/sequelize/sequelize/issues/10624)) ([b0da59b](https://togithub.com/sequelize/sequelize/commit/b0da59b)) ### [`v5.1.1`](https://togithub.com/sequelize/sequelize/releases/v5.1.1) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v5.1.0...v5.1.1) ### Changelog: #### 5.1.1 - [`6b82bee`](https://togithub.com/sequelize/sequelize/commit/6b82bee6) fix(typescript): add missing data types ([#​10607](https://togithub.com/sequelize/sequelize/issues/10607)) - [`d1c1958`](https://togithub.com/sequelize/sequelize/commit/d1c19582) docs(typescript): add typescript project guide ([#​10594](https://togithub.com/sequelize/sequelize/issues/10594)) - [`aefb863`](https://togithub.com/sequelize/sequelize/commit/aefb8638) docs(model): clarify documentation on projection aliasing ([#​10595](https://togithub.com/sequelize/sequelize/issues/10595)) - [`e07a7be`](https://togithub.com/sequelize/sequelize/commit/e07a7bea) fix(query-generator): correctly treat projection inversion in include default scope ([#​10597](https://togithub.com/sequelize/sequelize/issues/10597)) - [`db16cd5`](https://togithub.com/sequelize/sequelize/commit/db16cd56) fix(typescript): do not use const enums ([#​10585](https://togithub.com/sequelize/sequelize/issues/10585)) - [`d566c25`](https://togithub.com/sequelize/sequelize/commit/d566c25e) docs(data-types): fix param locations ([#​10586](https://togithub.com/sequelize/sequelize/issues/10586)) - [`7f00a55`](https://togithub.com/sequelize/sequelize/commit/7f00a55b) docs(define): Update docs to use classes instead of `define` ([#​10584](https://togithub.com/sequelize/sequelize/issues/10584)) - [`0b868c8`](https://togithub.com/sequelize/sequelize/commit/0b868c83) feat(types): add generics types for associations ([#​10524](https://togithub.com/sequelize/sequelize/issues/10524)) - [`3578062`](https://togithub.com/sequelize/sequelize/commit/35780624) refactor: optimize with spread operator ([#​10570](https://togithub.com/sequelize/sequelize/issues/10570)) - [`493d8e3`](https://togithub.com/sequelize/sequelize/commit/493d8e32) docs: fix typo ([#​10568](https://togithub.com/sequelize/sequelize/issues/10568)) - [`1e7e410`](https://togithub.com/sequelize/sequelize/commit/1e7e4108) chore(tests): use sinon resolves ([#​10567](https://togithub.com/sequelize/sequelize/issues/10567)) - [`80a7931`](https://togithub.com/sequelize/sequelize/commit/80a79315) fix(connection-manager): correctly assign default port ([#​10558](https://togithub.com/sequelize/sequelize/issues/10558)) - [`197ba54`](https://togithub.com/sequelize/sequelize/commit/197ba548) docs: improve getting-started documentation ([#​10548](https://togithub.com/sequelize/sequelize/issues/10548)) - [`03a2b3f`](https://togithub.com/sequelize/sequelize/commit/03a2b3f0) docs(upgrade-to-v5): typescript typings section - [`8303575`](https://togithub.com/sequelize/sequelize/commit/83035755) fix(hooks): don't expose unsupported hooks on models ([#​10547](https://togithub.com/sequelize/sequelize/issues/10547)) - [`bee4d61`](https://togithub.com/sequelize/sequelize/commit/bee4d613) docs: remove v5-beta tag - [`9941cd8`](https://togithub.com/sequelize/sequelize/commit/9941cd81) docs: update contributing guidelines ([#​10549](https://togithub.com/sequelize/sequelize/issues/10549)) ### [`v5.1.0`](https://togithub.com/sequelize/sequelize/releases/v5.1.0) [Compare Source](https://togithub.com/sequelize/sequelize/compare/v4.44.0...v5.1.0) #### Breaking Changes ##### Support for Node 6 and up Sequelize v5 will only support Node 6 and up [#​9015](https://togithub.com/sequelize/sequelize/issues/9015) ##### Secure Operators With v4 you started to get a deprecation warning `String based operators are now deprecated`. Also concept of operators was introduced. These operators are Symbols which prevent hash injection attacks. **With v5** - Operators are now enabled by default. - You can still use string operators by passing an operators map in `operatorsAliases`, but that will give you deprecation warning. - Op.$raw is removed ##### Typescript Support Sequelize now ship official typings [#​10287](https://togithub.com/sequelize/sequelize/issues/10287). You can consider migrating away from external typings which may get out of sync. ##### Pooling With v5 Sequelize now use `sequelize-pool` which is a modernized fork of `generic-pool@2.5`. You no longer need to call `sequelize.close` to shutdown pool, this helps with lambda executions. [#​8468](https://togithub.com/sequelize/sequelize/issues/8468) ##### Model **Validators** Custom validators defined per attribute (as opposed to the custom validators defined in the model's options) now run when the attribute's value is `null` and `allowNull` is `true` (while previously they didn't run and the validation succeeded immediately). To avoid problems when upgrading, please check all your custom validators defined per attribute, where `allowNull` is `true`, and make sure all these validators behave correctly when the value is `null`. See [#​9143](https://togithub.com/sequelize/sequelize/issues/9143). **Attributes** `Model.attributes` now removed, use `Model.rawAttributes`. [#​5320](https://togithub.com/sequelize/sequelize/issues/5320) **Note**: _Please don't confuse this with `options.attributes`, they are still valid_ **Paranoid Mode** With v5 if `deletedAt` is set, record will be considered as deleted. `paranoid` option will only use `deletedAt` as flag. [#​8496](https://togithub.com/sequelize/sequelize/issues/8496) **Model.bulkCreate** `updateOnDuplicate` option which used to accept boolean and array, now only accepts non-empty array of attributes. [#​9288](https://togithub.com/sequelize/sequelize/issues/9288) **Underscored Mode** Implementation of `Model.options.underscored` is changed. You can find full specifications [here](https://togithub.com/sequelize/sequelize/issues/6423#issuecomment-379472035). Main outline 1. Both `underscoredAll` and `underscored` options are merged into single `underscored` option 2. All attributes are now generated with camelcase naming by default. With the `underscored` option set to `true`, the `field` option for attributes will be set as underscored version of attribute name. 3. `underscored` will control all attributes including timestamps, version and foreign keys. It will not affect any attribute which already specifies the `field` option. [#​9304](https://togithub.com/sequelize/sequelize/pull/9304) **Removed aliases** Many model based aliases has been removed [#​9372](https://togithub.com/sequelize/sequelize/issues/9372) | Removed in v5 | Official Alternative | | :---------------------- | :------------------- | | insertOrUpdate | upsert | | find | findOne | | findAndCount | findAndCountAll | | findOrInitialize | findOrBuild | | updateAttributes | update | | findById, findByPrimary | findByPk | | all | findAll | | hook | addHook | ##### Datatypes **Range** Now supports only one standard format `[{ value: 1, inclusive: true }, { value: 20, inclusive: false }]` [#​9364](https://togithub.com/sequelize/sequelize/pull/9364) **Case insensitive text** Added support for `CITEXT` for Postgres and SQLite **Removed** `NONE` type has been removed, use `VIRTUAL` instead ##### Hooks **Removed aliases** Hooks aliases has been removed [#​9372](https://togithub.com/sequelize/sequelize/issues/9372) | Removed in v5 | Official Alternative | | :----------------------- | :------------------------ | | [after,before]BulkDelete | [after,before]BulkDestroy | | [after,before]Delete | [after,before]Destroy | | beforeConnection | beforeConnect | ##### Sequelize **Removed aliases** Prototype references for many constants, objects and classes has been removed [#​9372](https://togithub.com/sequelize/sequelize/issues/9372) | Removed in v5 | Official Alternative | | :------------------------------ | :-------------------- | | Sequelize.prototype.Utils | Sequelize.Utils | | Sequelize.prototype.Promise | Sequelize.Promise | | Sequelize.prototype.TableHints | Sequelize.TableHints | | Sequelize.prototype.Op | Sequelize.Op | | Sequelize.prototype.Transaction | Sequelize.Transaction | | Sequelize.prototype.Model | Sequelize.Model | | Sequelize.prototype.Deferrable | Sequelize.Deferrable | | Sequelize.prototype.Error | Sequelize.Error | | Sequelize.prototype[error] | Sequelize[error] | ```js import Sequelize from 'sequelize'; const sequelize = new Sequelize('postgres://user:password@127.0.0.1:mydb'); /** * In v4 you can do this */ console.log(sequelize.Op === Sequelize.Op) // logs `true` console.log(sequelize.UniqueConstraintError === Sequelize.UniqueConstraintError) // logs `true` Model.findAll({ where: { [sequelize.Op.and]: [ // Using sequelize.Op or Sequelize.Op interchangeably { name: "Abc" }, { age: { [Sequelize.Op.gte]: 18 } } ] } }).catch(sequelize.ConnectionError, () => { console.error('Something wrong with connection?'); }); /** * In v5 aliases has been removed from Sequelize prototype * You should use Sequelize directly to access Op, Errors etc */ Model.findAll({ where: { [Sequelize.Op.and]: [ // Dont use sequelize.Op, use Sequelize.Op instead { name: "Abc" }, { age: { [Sequelize.Op.gte]: 18 } } ] } }).catch(Sequelize.ConnectionError, () => { console.error('Something wrong with connection?'); }); ``` ##### Query Interface - `changeColumn` no longer generates constraint with `_idx` suffix. Now Sequelize does not specify any name for constraints thus defaulting to database engine naming. This aligns behavior of `sync`, `createTable` and `changeColumn`. ##### Others - Sequelize now use parameterized queries for all INSERT / UPDATE operations (except UPSERT). They provide better protection against SQL Injection attack. - `ValidationErrorItem` now holds reference to original error in the `original` property, rather than the `__raw` property. - [retry-as-promised](https://togithub.com/mickhansen/retry-as-promised) has been updated to `3.1.0`, which use [any-promise](https://togithub.com/kevinbeaty/any-promise). This module repeat all `sequelize.query` operations. You can configure `any-promise` to use `bluebird` for better performance on Node 4 or 6 - Sequelize will throw for all `undefined` keys in `where` options, In past versions `undefined` was converted to `null`. ##### Dialect Specific ##### MSSQL - Sequelize now works with `tedious >= 6.0.0`. Old `dialectOptions` has to be updated to match their new format. Please refer to tedious [documentation](http://tediousjs.github.io/tedious/api-connection.html#function_newConnection). An example of new `dialectOptions` is given below ```json dialectOptions: { authentication: { domain: 'my-domain' }, options: { requestTimeout: 60000, cryptoCredentialsDetails: { ciphers: "RC4-MD5" } } } ``` ##### MySQL - Requires `mysql2 >= 1.5.2` for prepared statements ##### MariaDB - `dialect: 'mariadb'` is now [supported](https://togithub.com/sequelize/sequelize/pull/10192) with `mariadb` package ##### Packages - removed: terraformer-wkt-parser [#​9545](https://togithub.com/sequelize/sequelize/pull/9545) - removed: `generic-pool` - added: `sequelize-pool` #### Changelog ##### 5.0.0-beta.17 - fix(build): default null for multiple primary keys - fix(util): improve performance of classToInvokable [#​10534](https://togithub.com/sequelize/sequelize/pull/10534) - fix(model/update): propagate paranoid to individualHooks query [#​10369](https://togithub.com/sequelize/sequelize/pull/10369) - fix(association): use minimal select for hasAssociation [#​10529](https://togithub.com/sequelize/sequelize/pull/10529) - fix(query-interface): reject with error for describeTable [#​10528](https://togithub.com/sequelize/sequelize/pull/10528) - fix(model): throw for invalid include type [#​10527](https://togithub.com/sequelize/sequelize/pull/10527) - fix(types): additional options for db.query and add missing retry [#​10512](https://togithub.com/sequelize/sequelize/pull/10512) - fix(query): don't prepare options & sql for every retry [#​10498](https://togithub.com/sequelize/sequelize/pull/10498) - feat: expose Sequelize.BaseError - feat: upgrade to tedious@6.0.0 [#​10494](https://togithub.com/sequelize/sequelize/pull/10494) - feat(sqlite/query-generator): support restart identity for truncate-table [#​10522](https://togithub.com/sequelize/sequelize/pull/10522) - feat(data-types): handle numbers passed as objects [#​10492](https://togithub.com/sequelize/sequelize/pull/10492) - feat(types): enabled string association [#​10481](https://togithub.com/sequelize/sequelize/pull/10481) - feat(postgres): allow customizing client_min_messages [#​10448](https://togithub.com/sequelize/sequelize/pull/10448) - refactor(data-types): move to classes [#​10495](https://togithub.com/sequelize/sequelize/pull/10495) - docs(legacy): fix N:M example [#​10509](https://togithub.com/sequelize/sequelize/pull/10509) - docs(migrations): use migrationStorageTableSchema [#​10417](https://togithub.com/sequelize/sequelize/pull/10417) - docs(hooks): add documentation for connection hooks [#​10410](https://togithub.com/sequelize/sequelize/pull/10410) - docs(addIndex): concurrently option [#​10409](https://togithub.com/sequelize/sequelize/pull/10409) - docs(model): fix typo [#​10405](https://togithub.com/sequelize/sequelize/pull/10405) - docs(usage): fix broken link on Basic Usage [#​10381](https://togithub.com/sequelize/sequelize/pull/10381) - docs(package.json): add homepage [#​10372](https://togithub.com/sequelize/sequelize/pull/10372) ##### 5.0.0-beta.16 - feat: add typescript typings [#​10287](https://togithub.com/sequelize/sequelize/pull/10117) - fix(mysql): match with newlines in error message [#​10320](https://togithub.com/sequelize/sequelize/pull/10320) - fix(update): skips update when nothing to update [#​10248](https://togithub.com/sequelize/sequelize/pull/10248) - fix(utils): flattenObject for null values [#​10293](https://togithub.com/sequelize/sequelize/pull/10293) - fix(instance-validator): don't skip custom validators on null [#​9143](https://togithub.com/sequelize/sequelize/pull/9143) - docs(transaction): after save example [#​10280](https://togithub.com/sequelize/sequelize/pull/10280) - docs(query-generator): typo [#​10277](https://togithub.com/sequelize/sequelize/pull/10277) - refactor(errors): restructure [#​10355](https://togithub.com/sequelize/sequelize/pull/10355) - refactor(scope): documentation [#​9087](https://togithub.com/sequelize/sequelize/issues/9087) [#​10312](https://togithub.com/sequelize/sequelize/pull/10312) - refactor: cleanup association and spread use [#​10276](https://togithub.com/sequelize/sequelize/pull/10276) ##### 5.0.0-beta.15 - fix(query-generator): fix addColumn create comment [#​10117](https://togithub.com/sequelize/sequelize/pull/10117) - fix(sync): throw when no models defined [#​10175](https://togithub.com/sequelize/sequelize/pull/10175) - fix(association): enable eager load with include all([#​9928](https://togithub.com/sequelize/sequelize/issues/9928)) [#​10173](https://togithub.com/sequelize/sequelize/pull/10173) - fix(sqlite): simplify connection error handling - fix(model): prevent version number from being incremented as string [#​10217](https://togithub.com/sequelize/sequelize/pull/10217) - feat(dialect): mariadb [#​10192](https://togithub.com/sequelize/sequelize/pull/10192) - docs(migrations): improve dialect options docs - docs: fix favicon [#​10242](https://togithub.com/sequelize/sequelize/pull/10242) - docs(model.init): `attribute.column.validate` option [#​10237](https://togithub.com/sequelize/sequelize/pull/10237) - docs(bulk-create): update support information about ignoreDuplicates - docs: explain custom/new data types [#​10170](https://togithub.com/sequelize/sequelize/pull/10170) - docs(migrations): Simplify CLI Call [#​10201](https://togithub.com/sequelize/sequelize/pull/10201) - docs(migrations): added advanced skeleton example [#​10190](https://togithub.com/sequelize/sequelize/pull/10190) - docs(transaction): default isolation level [#​10111](https://togithub.com/sequelize/sequelize/pull/10111) - docs: typo in associations.md [#​10157](https://togithub.com/sequelize/sequelize/pull/10157) - refactor: reduce code complexity [#​10120](https://togithub.com/sequelize/sequelize/pull/10120) - refactor: optimize memoize use, misc cases [#​10122](https://togithub.com/sequelize/sequelize/pull/10122) - chore(lint): enforce consistent spacing [#​10193](https://togithub.com/sequelize/sequelize/pull/10193) ##### 5.0.0-beta.14 - fix(query): correctly quote identifier for attributes ([#​9964](https://togithub.com/sequelize/sequelize/issues/9964)) [#​10118](https://togithub.com/sequelize/sequelize/pull/10118) - feat(postgres): dyanmic oids [#​10077](https://togithub.com/sequelize/sequelize/pull/10077) - fix(error): optimistic lock message [#​10068](https://togithub.com/sequelize/sequelize/pull/10068) - fix(package): update depd to version 2.0.0 [#​10081](https://togithub.com/sequelize/sequelize/pull/10081) - fix(model): validate virtual attribute ([#​9947](https://togithub.com/sequelize/sequelize/issues/9947)) [#​10085](https://togithub.com/sequelize/sequelize/pull/10085) - fix(test): actually test get method with raw option [#​10059](https://togithub.com/sequelize/sequelize/pull/10059) - fix(model): return deep cloned value for toJSON [#​10058](https://togithub.com/sequelize/sequelize/pull/10058) - fix(model): create instance with many-to-many association with extra column ([#​10034](https://togithub.com/sequelize/sequelize/issues/10034)) [#​10050](https://togithub.com/sequelize/sequelize/pull/10050) - fix(query-generator): fix bad property access [#​10056](https://togithub.com/sequelize/sequelize/pull/10056) - docs(upgrade-to-v4): typo [#​10060](https://togithub.com/sequelize/sequelize/pull/10060) - docs(model-usage): order expression format [#​10061](https://togithub.com/sequelize/sequelize/pull/10061) - chore(package): update retry-as-promised to version 3.1.0 [#​10065](https://togithub.com/sequelize/sequelize/pull/10065) - refactor(scopes): just in time options conforming [#​9735](https://togithub.com/sequelize/sequelize/pull/9735) - refactor: use sequelize-pool for pooling [#​10051](https://togithub.com/sequelize/sequelize/pull/10051) - refactor(\*): cleanup code [#​10091](https://togithub.com/sequelize/sequelize/pull/10091) - refactor: use template strings [#​10055](https://togithub.com/sequelize/sequelize/pull/10055) - refactor(query-generation): cleanup template usage [#​10047](https://togithub.com/sequelize/sequelize/pull/10047) ##### 5.0.0-beta.13 - fix: throw on undefined where parameters [#​10048](https://togithub.com/sequelize/sequelize/pull/10048) - fix(model): improve wrong alias error message [#​10041](https://togithub.com/sequelize/sequelize/pull/10041) - feat(sqlite): CITEXT datatype [#​10036](https://togithub.com/sequelize/sequelize/pull/10036) - fix(postgres): remove if not exists and cascade from create/drop database queries [#​10033](https://togithub.com/sequelize/sequelize/pull/10033) - fix(syntax): correct parentheses around union [#​10003](https://togithub.com/sequelize/sequelize/pull/10003) - feat(query-interface): createDatabase / dropDatabase support [#​10027](https://togithub.com/sequelize/sequelize/pull/10027) - feat(postgres): CITEXT datatype [#​10024](https://togithub.com/sequelize/sequelize/pull/10024) - feat: pass uri query parameters to dialectOptions [#​10025](https://togithub.com/sequelize/sequelize/pull/10025) - docs(query-generator): remove doc about where raw query [#​10017](https://togithub.com/sequelize/sequelize/pull/10017) - fix(query): handle undefined field on unique constraint error [#​10018](https://togithub.com/sequelize/sequelize/pull/10018) - fix(model): sum returns zero when empty matching [#​9984](https://togithub.com/sequelize/sequelize/pull/9984) - feat(query-generator): add startsWith, endsWith and substring operators [#​9999](https://togithub.com/sequelize/sequelize/pull/9999) - docs(sequelize): correct jsdoc annotations for authenticate [#​10002](https://togithub.com/sequelize/sequelize/pull/10002) - docs(query-interface): add bulkUpdate docs [#​10005](https://togithub.com/sequelize/sequelize/pull/10005) - fix(tinyint): ignore params for TINYINT on postgres [#​9992](https://togithub.com/sequelize/sequelize/pull/9992) - fix(belongs-to): create now returns target model [#​9980](https://togithub.com/sequelize/sequelize/pull/9980) - refactor(model): remove .all alias [#​9975](https://togithub.com/sequelize/sequelize/pull/9975) - perf: fix memory leak due to instance reference by isImmutable [#​9973](https://togithub.com/sequelize/sequelize/pull/9973) - feat(sequelize): dialectModule option [#​9972](https://togithub.com/sequelize/sequelize/pull/9972) - fix(query): check valid warn message [#​9948](https://togithub.com/sequelize/sequelize/pull/9948) - fix(model): check for own property when overriding association mixins [#​9953](https://togithub.com/sequelize/sequelize/pull/9953) - fix(create-table): support for uniqueKeys [#​9946](https://togithub.com/sequelize/sequelize/pull/9946) - refactor(transaction): remove autocommit mode [#​9921](https://togithub.com/sequelize/sequelize/pull/9921) - feat(sequelize): getDatabaseName [#​9937](https://togithub.com/sequelize/sequelize/pull/9937) - refactor: remove aliases [#​9933](https://togithub.com/sequelize/sequelize/pull/9933) - feat(belongsToMany): override unique constraint name with uniqueKey [#​9914](https://togithub.com/sequelize/sequelize/pull/9914) - fix(postgres): properly disconnect connections [#​9911](https://togithub.com/sequelize/sequelize/pull/9911) - docs(instances.md): add section for restore() [#​9917](https://togithub.com/sequelize/sequelize/pull/9917) - docs(hooks.md): add warning about memory limits of individual hooks [#​9881](https://togithub.com/sequelize/sequelize/pull/9881) - fix(package): update debug to version 4.0.0 [#​9908](https://togithub.com/sequelize/sequelize/pull/9908) - feat(postgres): support ignoreDuplicates with ON CONFLICT DO NOTHING [#​9883](https://togithub.com/sequelize/sequelize/pull/9883) ##### 5.0.0-beta.12 - fix(changeColumn): normalize attribute [#​9897](https://togithub.com/sequelize/sequelize/pull/9897) - feat(describeTable): support string length for mssql [#​9896](https://togithub.com/sequelize/sequelize/pull/9896) - feat(describeTable): support autoIncrement for mysql [#​9894](https://togithub.com/sequelize/sequelize/pull/9894) - fix(sqlite): unable to reference foreignKey on primaryKey [#​9893](https://togithub.com/sequelize/sequelize/pull/9893) - fix(postgres): enum with string COMMENT breaks query [#​9891](https://togithub.com/sequelize/sequelize/pull/9891) - fix(changeColumn): use engine defaults for foreign/unique key naming [#​9890](https://togithub.com/sequelize/sequelize/pull/9890) - fix(transaction): fixed unhandled rejection when connection acquire timeout [#​9879](https://togithub.com/sequelize/sequelize/pull/9879) - fix(sqlite): close connection properly and cleanup files [#​9851](https://togithub.com/sequelize/sequelize/pull/9851) - fix(model): incorrect error message for findCreateFind [#​9849](https://togithub.com/sequelize/sequelize/pull/9849) ##### 5.0.0-beta.11 - fix(count): duplicate mapping of fields break scopes [#​9788](https://togithub.com/sequelize/sequelize/pull/9788) - fix(model): bulkCreate should populate dataValues directly [#​9797](https://togithub.com/sequelize/sequelize/pull/9797) - fix(mysql): improve unique key violation handling [#​9724](https://togithub.com/sequelize/sequelize/pull/9724) - fix(separate): don't propagate group to separated queries [#​9754](https://togithub.com/sequelize/sequelize/pull/9754) - fix(scope): incorrect query generated when sequelize.fn used with scopes [#​9730](https://togithub.com/sequelize/sequelize/pull/9730) - fix(json): access included data with attributes [#​9662](https://togithub.com/sequelize/sequelize/pull/9662) - (fix): pass offset in UNION'ed queries [#​9577](https://togithub.com/sequelize/sequelize/pull/9577) - fix(destroy): attributes updated in a beforeDestroy hook are now persisted on soft delete [#​9319](https://togithub.com/sequelize/sequelize/pull/9319) - fix(addScope): only throw when defaultScope is defined [#​9703](https://togithub.com/sequelize/sequelize/pull/9703) ##### 5.0.0-beta.10 - fix(belongsToMany): association.add returns array of array of through records [#​9700](https://togithub.com/sequelize/sequelize/pull/9700) - feat: association hooks [#​9590](https://togithub.com/sequelize/sequelize/pull/9590) - fix(bulkCreate): dont map dataValue to fields for individualHooks:true[#​9672](https://togithub.com/sequelize/sequelize/pull/9672) - feat(postgres): drop enum support [#​9641](https://togithub.com/sequelize/sequelize/pull/9641) - feat(validation): improve validation for type[#​9660](https://togithub.com/sequelize/sequelize/pull/9660) - feat: allow querying sqlite_master table [#​9645](https://togithub.com/sequelize/sequelize/pull/9645) - fix(hasOne.sourceKey): setup sourceKeyAttribute for joins [#​9658](https://togithub.com/sequelize/sequelize/pull/9658) - fix: throw when type of array values is not defined [#​9649](https://togithub.com/sequelize/sequelize/pull/9649) - fix(query-generator): ignore undefined keys in query [#​9548](https://togithub.com/sequelize/sequelize/pull/9548) - fix(model): unable to override rejectOnEmpty [#​9632](https://togithub.com/sequelize/sequelize/pull/9632) - fix(reload): instance.changed() remains unaffected [#​9615](https://togithub.com/sequelize/sequelize/pull/9615) - feat(model): column level comments [#​9573](https://togithub.com/sequelize/sequelize/pull/9573) - docs: cleanup / correct jsdoc references [#​9702](https://togithub.com/sequelize/sequelize/pull/9702) ##### 5.0.0-beta.9 - fix(model): ignore undefined values in update payload [#​9587](https://togithub.com/sequelize/sequelize/pull/9587) - fix(mssql): set encrypt as default false for dialect options [#​9588](https://togithub.com/sequelize/sequelize/pull/9588) - fix(model): ignore VIRTUAL/getters with attributes.exclude [#​9568](https://togithub.com/sequelize/sequelize/pull/9568) - feat(data-types): CIDR, INET, MACADDR support for Postgres [#​9567](https://togithub.com/sequelize/sequelize/pull/9567) - fix: customize allowNull message with notNull validator [#​9549](https://togithub.com/sequelize/sequelize/pull/9549) ##### 5.0.0-beta.8 - feat(query-generator): Generate INSERT / UPDATE using bind parameters [#​9431](https://togithub.com/sequelize/sequelize/pull/9431) [#​9492](https://togithub.com/sequelize/sequelize/pull/9492) - performance: remove terraformer-wkt-parser dependency [#​9545](https://togithub.com/sequelize/sequelize/pull/9545) - fix(constructor): set username, password, database via options in addition to connection string[#​9517](https://togithub.com/sequelize/sequelize/pull/9517) - fix(associations/belongs-to-many): catch EmptyResultError in set/add helpers [#​9535](https://togithub.com/sequelize/sequelize/pull/9535) - fix: sync with alter:true doesn't use field name [#​9529](https://togithub.com/sequelize/sequelize/pull/9529) - fix(UnknownConstraintError): improper handling of error options [#​9547](https://togithub.com/sequelize/sequelize/pull/9547) ##### 5.0.0-beta.7 - fix(data-types/blob): only return null for mysql binary null [#​9441](https://togithub.com/sequelize/sequelize/pull/9441) - fix(errors): use standard .original rather than .\_\_raw for actual error - fix(connection-manager): mssql datatype parsing [#​9470](https://togithub.com/sequelize/sequelize/pull/9470) - fix(query/removeConstraint): support schemas - fix: use Buffer.from - fix(transactions): return patched promise from sequelize.query [#​9473](https://togithub.com/sequelize/sequelize/pull/9473) ##### 5.0.0-beta.6 - fix(postgres/query-generator): syntax error with auto-increment SMALLINT [#​9406](https://togithub.com/sequelize/sequelize/pull/9406) - fix(postgres/range): inclusive property lost in JSON format [#​8471](https://togithub.com/sequelize/sequelize/issues/8471) - fix(postgres/range): range bound not applied [#​8176](https://togithub.com/sequelize/sequelize/issues/8176) - fix(mssql): no unique constraint error thrown for PRIMARY case [#​9415](https://togithub.com/sequelize/sequelize/pull/9415) - fix(query-generator): regexp operator escaping - docs: various improvements and hinting update ##### 5.0.0-beta.5 - fix: inject foreignKey when using separate:true [#​9396](https://togithub.com/sequelize/sequelize/pull/9396) - fix(isSoftDeleted): just use deletedAt as flag - feat(hasOne): sourceKey support with key validation [#​9382](https://togithub.com/sequelize/sequelize/pull/9382) - fix(query-generator/deleteQuery): remove auto limit [#​9377](https://togithub.com/sequelize/sequelize/pull/9377) - feat(postgres): skip locked support [#​9197](https://togithub.com/sequelize/sequelize/pull/9197) - fix(mssql): case sensitive operation fails because of uppercased system table references [#​9337](https://togithub.com/sequelize/sequelize/pull/9337) ##### 5.0.0-beta.4 - change(model): setDataValue should not mark null to null as changed [#​9347](https://togithub.com/sequelize/sequelize/pull/9347) - change(mysql/connection-manager): do not execute SET time_zone query if keepDefaultTimezone config is true [#​9358](https://togithub.com/sequelize/sequelize/pull/9358) - feat(transactions): Add afterCommit hooks for transactions [#​9287](https://togithub.com/sequelize/sequelize/pull/9287) ##### 5.0.0-beta.3 - change(model): new options.underscored implementation [#​9304](https://togithub.com/sequelize/sequelize/pull/9304) - fix(mssql): duplicate order generated with limit offset [#​9307](https://togithub.com/sequelize/sequelize/pull/9307) - fix(scope): do not assign scope on eagerly loaded associations [#​9292](https://togithub.com/sequelize/sequelize/pull/9292) - change(bulkCreate): only support non-empty array as updateOnDuplicate ##### 5.0.0-beta.2 - change(operators): Symbol operators now enabled by default, removed deprecation warning - fix(model): don't add LIMIT in findOne() queries on unique key [#​9248](https://togithub.com/sequelize/sequelize/pull/9248) - fix(model): use schema when generating foreign keys [#​9029](https://togithub.com/sequelize/sequelize/issues/9029) ##### 5.0.0-beta.1 - fix(postgres): reserved words support [#​9236](https://togithub.com/sequelize/sequelize/pull/9236) - fix(findOrCreate): warn and handle unknown attributes in defaults - fix(query-generator): 1-to-many join in subQuery filter missing where clause [#​9228](https://togithub.com/sequelize/sequelize/issues/9228) ##### 5.0.0-beta - `Model.attributes` now removed, use `Model.rawAttributes` [#​5320](https://togithub.com/sequelize/sequelize/issues/5320) - `paranoid` mode will now treat any record with `deletedAt` as deleted [#​8496](https://togithub.com/sequelize/sequelize/issues/8496) - Node 6 and up [#​9015](https://togithub.com/sequelize/sequelize/issues/9015)

Renovate configuration

:date: Schedule: "" (UTC).

:vertical_traffic_light: Automerge: Disabled by config. Please merge this manually once you are satisfied.

:recycle: Rebasing: Whenever PR becomes conflicted, or if you modify the PR title to begin with "rebase!".

:no_bell: Ignore: Close this PR and you won't be reminded about this update again.

This PR has been generated by Renovate Bot. View repository job log here.