opengovsg / checkfirst

Don't Know? CheckFirst. A tool to build eligibility checkers and calculators for Singapore Government policies
https://checkfirst.gov.sg
Other
11 stars 6 forks source link

[Snyk] Security upgrade sequelize from 6.9.0 to 6.21.2 #1309

Closed liangyuanruo closed 2 years ago

liangyuanruo commented 2 years ago

This PR was automatically created by Snyk using the credentials of a real user.


Snyk has created this PR to fix one or more vulnerable packages in the `npm` dependencies of this project.

![merge advice](https://app.snyk.io/badges/merge-advice/?package_manager=npm&package_name=sequelize&from_version=6.9.0&to_version=6.21.2&pr_id=545e8dbe-c8fe-4bd7-a3e5-0ce2162a569c&visibility=true&has_feature_flag=false) #### Changes included in this PR - Changes to the following files to upgrade the vulnerable dependencies to a fixed version: - package.json - package-lock.json #### Vulnerabilities that will be fixed ##### With an upgrade: Severity | Priority Score (*) | Issue | Breaking Change | Exploit Maturity :-------------------------:|-------------------------|:-------------------------|:-------------------------|:------------------------- ![high severity](https://res.cloudinary.com/snyk/image/upload/w_20,h_20/v1561977819/icon/h.png "high severity") | **636/1000**
**Why?** Recently disclosed, Has a fix available, CVSS 7 | SQL Injection
[SNYK-JS-SEQUELIZE-2959225](https://snyk.io/vuln/SNYK-JS-SEQUELIZE-2959225) | No | No Known Exploit (*) Note that the real score may have changed since the PR was raised.
Commit messages
Package name: sequelize The new version differs by 179 commits.
  • 7bb60e3 fix: properly escaoe multiple `$` in `fn` args (#14678)
  • 86d35b1 docs: added nest option inside findAll query (#14683)
  • 2f3b924 fix(postgres): use schema set in sequelize config by default (#14665)
  • cbdf73e feat: exports types to support typescript >= 4.5 nodenext module (#14620)
  • a333862 docs(readme): update README to be more like main (#14626)
  • e1a9c28 fix: kill connection on commit/rollback error (#14535)
  • b37df96 feat: support cyclic foreign keys (#14499)
  • e37c572 fix: accept replacements in `ARRAY[]` & followed by `;` (#14518)
  • 6c5f8ec test: disable mysql/mariadb deadlock test (#14514)
  • 87655eb build: fix esdoc (#14513)
  • ccaa399 fix: do not replace `:replacements` inside of strings (#14472)
  • 5954d2c feat(types): make `Model.init` aware of pre-configured foreign keys (#14370)
  • 0d0aade fix(types): make `WhereOptions` more accurate (#14368)
  • 7e8b707 docs: restore Model api reference & make fail on error (#14323)
  • ca0e017 test: disable deadlock test for mariadb 10.5.15 (#14314)
  • 62564f7 docs: fix dead link in API reference (#14313)
  • cdc8881 build: remove v6 docs from repository (#14234)
  • 730af27 docs: document scope whereMergeStrategy option (#14201)
  • 8349c02 feat: add whereScopeStrategy to merge where scopes with Op.and (#14152)
  • e974e20 feat(types): make `Model.getAttributes` stricter (#14017)
  • 2d339d0 fix: fix typo in query-generator.js error message (#14151)
  • b80aeed fix(types): update return type of `Model.update` (#14155)
  • f5c06bd feat(types): infer nullable creation attributes as optional (#14147)
  • af6cbe6 build(deps): move @ types/validator to prod deps (#14159)
See the full diff
Check the changes in this PR to ensure they won't cause issues with your project. ------------ **Note:** *You are seeing this because you or someone else with access to this repository has authorized Snyk to open fix PRs.* For more information: 🧐 [View latest project report](https://app.snyk.io/org/checkfirst/project/f3263281-13f7-46d0-9389-177c00ea1b67?utm_source=github&utm_medium=referral&page=fix-pr) 🛠 [Adjust project settings](https://app.snyk.io/org/checkfirst/project/f3263281-13f7-46d0-9389-177c00ea1b67?utm_source=github&utm_medium=referral&page=fix-pr/settings) 📚 [Read more about Snyk's upgrade and patch logic](https://support.snyk.io/hc/en-us/articles/360003891078-Snyk-patches-to-fix-vulnerabilities) [//]: # (snyk:metadata:{"prId":"545e8dbe-c8fe-4bd7-a3e5-0ce2162a569c","prPublicId":"545e8dbe-c8fe-4bd7-a3e5-0ce2162a569c","dependencies":[{"name":"sequelize","from":"6.9.0","to":"6.21.2"}],"packageManager":"npm","projectPublicId":"f3263281-13f7-46d0-9389-177c00ea1b67","projectUrl":"https://app.snyk.io/org/checkfirst/project/f3263281-13f7-46d0-9389-177c00ea1b67?utm_source=github&utm_medium=referral&page=fix-pr","type":"auto","patch":[],"vulns":["SNYK-JS-SEQUELIZE-2959225"],"upgrade":["SNYK-JS-SEQUELIZE-2959225"],"isBreakingChange":false,"env":"prod","prType":"fix","templateVariants":["updated-fix-title","priorityScore","merge-advice-badge-shown"],"priorityScoreList":[636]}) --- **Learn how to fix vulnerabilities with free interactive lessons:** 🦉 [SQL Injection](https://learn.snyk.io/lessons/sql-injection/javascript?loc=fix-pr)