chore(deps): bump mysql2, @mikro-orm/core and @mikro-orm/mysql in /sample/011-mirkoorm-app

[dependabot[bot]]

Bumps mysql2 to 3.9.4 and updates ancestor dependencies mysql2, @mikro-orm/core and @mikro-orm/mysql. These dependencies need to be updated together.

Updates mysql2 from 3.6.2 to 3.9.4

Release notes

Sourced from mysql2's releases.

v3.9.4

3.9.4 (2024-04-09)

Bug Fixes

• SSL: separate each certificate into an individual item #2542 (63f1055)
• security: improve supportBigNumbers and bigNumberStrings sanitization (#2572) (74abf9e)
  • Fixes a potential RCE attack vulnerability reported by Vsevolod Kokorin (Slonser) of Solidlab
• security: improve results object creation (#2574) (4a964a3)
  • Fixes a potential Prototype Pollution attack vulnerability reported by Vsevolod Kokorin (Slonser) of Solidlab
• docs: improve the contribution guidelines (#2552) (8a818ce)

v3.9.3

3.9.3 (2024-03-26)

Bug Fixes

• security: improve cache key formation (#2424) (0d54b0c)
  • Fixes a potential parser cache poisoning attack vulnerability reported by Vsevolod Kokorin (Slonser) of Solidlab
• update Amazon RDS SSL CA cert (#2131) (d9dccfd)

v3.9.2

3.9.2 (2024-02-26)

Bug Fixes

• stream: premature close when it is paused (#2416) (7c6bc64)
• types: expose TypeCast types (#2425) (336a7f1)

v3.9.1

3.9.1 (2024-01-29)

Bug Fixes

• types: support encoding for string type cast (#2407) (1dc2011)

v3.9.0

3.9.0 (2024-01-26)

Features

• introduce typeCast for execute method (#2398) (baaa92a)

v3.8.0

3.8.0 (2024-01-23)

... (truncated)

Changelog

Sourced from mysql2's changelog.

3.9.4 (2024-04-09)

Bug Fixes

• docs: improve the contribution guidelines (#2552) (8a818ce)
• security: improve results object creation (#2574) (4a964a3)
• security: improve supportBigNumbers and bigNumberStrings sanitization (#2572) (74abf9e)

3.9.3 (2024-03-26)

Bug Fixes

• security: improve cache key formation (#2424) (0d54b0c)
  • Fixes a potential parser cache poisoning attack vulnerability reported by Vsevolod Kokorin (Slonser) of Solidlab
• update Amazon RDS SSL CA cert (#2131) (d9dccfd)

3.9.2 (2024-02-26)

Bug Fixes

• stream: premature close when it is paused (#2416) (7c6bc64)
• types: expose TypeCast types (#2425) (336a7f1)

3.9.1 (2024-01-29)

Bug Fixes

• types: support encoding for string type cast (#2407) (1dc2011)

3.9.0 (2024-01-26)

Features

• introduce typeCast for execute method (#2398) (baaa92a)

3.8.0 (2024-01-23)

Features

• perf: cache iconv decoder (#2391) (b95b3db)

Bug Fixes

... (truncated)

Commits

• cf3fa60 chore(master): release 3.9.4 (#2566)
• 4a964a3 fix(security): improve results object creation (#2574)
• 71115d8 ci: improve parser tests (#2573)
• 74abf9e fix(security): improve supportBigNumbers and bigNumberStrings sanitization (#...
• 8a818ce fix(docs): improve the contribution guidelines (#2552)
• 0f08c7c build(deps-dev): bump @​docusaurus/tsconfig in /website (#2563)
• 165c4d6 build(deps-dev): bump @​docusaurus/eslint-plugin in /website (#2564)
• 9b5ed7b build(deps): bump @​docusaurus/preset-classic in /website (#2562)
• 096db64 build(deps-dev): bump typescript from 5.4.3 to 5.4.4 (#2561)
• b91fd16 build(deps-dev): bump tsx from 4.7.1 to 4.7.2 in /website (#2557)
• Additional commits viewable in compare view

Updates @mikro-orm/core from 5.9.7 to 6.2.0

Release notes

Sourced from @​mikro-orm/core's releases.

v6.2.0

6.2.0 (2024-04-09)

https://mikro-orm.io/blog/mikro-orm-6-2-released

Bug Fixes

• core: do not select 1:1 owning FK twice (fa69276)
• core: fix querying by embedded properties inside relations (2e74699), closes #5391
• core: fix support for custom repositories in @CreateRequestContext on type level (aacac83)
• core: fix TypeError when ordering by embedded populating properties (2c472ab), closes #5389
• core: ignore current context when creating repository instance (4c12fc5), closes #5395
• core: prefer entity type inference from the first parameter of entity manager methods (523963b)
• core: respect custom EntityManager type in em.fork() (bb1a3f9), closes #5415
• core: support passing Configuration instance to MikroORM.init (54a37d0), closes #5413
• entity-generator: allow arbitrary class and prop names as identifiers (#5359) (b0c0236)
• mariadb: rework pagination mechanism to fix extra results (a57cb19)
• mysql: support order by nulls first/last for raw query fragments in order by keys (a2a8f0d)
• postgres: drop text enum check constraints only when necessary (#5414) (5162345), closes #4112
• postgres: removed erroneous duplicates in FK discovery query (#5376) (eec2b38)
• query-builder: fix serialization hint of nested qb.joinAndSelect() calls (c2843b9)
• schema: improve detection of renamed columns (4d13c58)
• schema: rework dropping columns to support custom schemas and merge drop column queries (255f425)

Features

• core: add support for serialization groups (#5416) (818c290)
• core: allow better type-safety for custom types via IType (#5383) (0e18346)
• core: allow configuring driverOptions on replica level (05e81f8)
• core: include all dirty collections to UoW.getCollectionUpdates() (e7bd66f)
• core: make assign options configurable globally (bc9f6f5), closes #5410
• libsql: add libSQL driver (#5417) (6c63e4b), closes #5283
• mssql: add MS SQL Server driver (#1375) (eeaad45), closes #771
• postgres: allow defining deferred FK constraints (#5384) (f42d171), closes #5306
• query-builder: add limit 1 when executing query via getSingleResult() or execute('get') (c2b22e8), closes #5379
• query-builder: add qb.getLoggerContext() and qb.setLoggerContext() (779fa15), closes #5358
• schema: allow configuring updateRule and deleteRule for pivot tables (cc69c3c)
• schema: improve orm.schema.execute() to support executing batches (3c5a347)
• schema: support recreating the whole database via orm.schema.refreshDatabase() (2e4ab49)

Performance Improvements

• core: optimize metadata discovery (c322f9b)
• query-builder: remove unnecessary join branches when pagination is applied (d228976)

... (truncated)

Changelog

Sourced from @​mikro-orm/core's changelog.

6.2.0 (2024-04-09)

Bug Fixes

• core: do not select 1:1 owning FK twice (fa69276)
• core: fix querying by embedded properties inside relations (2e74699), closes #5391
• core: fix support for custom repositories in @CreateRequestContext on type level (aacac83)
• core: fix TypeError when ordering by embedded populating properties (2c472ab), closes #5389
• core: ignore current context when creating repository instance (4c12fc5), closes #5395
• core: prefer entity type inference from the first parameter of entity manager methods (523963b)
• core: respect custom EntityManager type in em.fork() (bb1a3f9), closes #5415
• core: support passing Configuration instance to MikroORM.init (54a37d0), closes #5413
• entity-generator: allow arbitrary class and prop names as identifiers (#5359) (b0c0236)
• mariadb: rework pagination mechanism to fix extra results (a57cb19)
• mysql: support order by nulls first/last for raw query fragments in order by keys (a2a8f0d)
• postgres: drop text enum check constraints only when necessary (#5414) (5162345), closes #4112
• postgres: removed erroneous duplicates in FK discovery query (#5376) (eec2b38)
• query-builder: fix serialization hint of nested qb.joinAndSelect() calls (c2843b9)
• schema: improve detection of renamed columns (4d13c58)
• schema: rework dropping columns to support custom schemas and merge drop column queries (255f425)

Features

• core: add support for serialization groups (#5416) (818c290)
• core: allow better type-safety for custom types via IType (#5383) (0e18346)
• core: allow configuring driverOptions on replica level (05e81f8)
• core: include all dirty collections to UoW.getCollectionUpdates() (e7bd66f)
• core: make assign options configurable globally (bc9f6f5), closes #5410
• libsql: add libSQL driver (#5417) (6c63e4b), closes #5283
• mssql: add MS SQL Server driver (#1375) (eeaad45), closes #771
• postgres: allow defining deferred FK constraints (#5384) (f42d171), closes #5306
• query-builder: add limit 1 when executing query via getSingleResult() or execute('get') (c2b22e8), closes #5379
• query-builder: add qb.getLoggerContext() and qb.setLoggerContext() (779fa15), closes #5358
• schema: allow configuring updateRule and deleteRule for pivot tables (cc69c3c)
• schema: improve orm.schema.execute() to support executing batches (3c5a347)
• schema: support recreating the whole database via orm.schema.refreshDatabase() (2e4ab49)

Performance Improvements

• core: optimize metadata discovery (c322f9b)
• query-builder: remove unnecessary join branches when pagination is applied (d228976)

6.1.12 (2024-03-24)

... (truncated)

Commits

• e85e7a9 chore(release): v6.2.0 [skip ci]
• 61410cd docs: add v6.2 blog post [skip ci]
• 005f86e test: coverage
• e7bd66f feat(core): include all dirty collections to UoW.getCollectionUpdates()
• 5d89ac2 chore: update mysql2 dependency + adjust result mapping to be compatible with...
• b0c0236 fix(entity-generator): allow arbitrary class and prop names as identifiers (#...
• acd6590 chore(deps): update patch/minor dependencies
• 05e81f8 feat(core): allow configuring driverOptions on replica level
• 2c472ab fix(core): fix TypeError when ordering by embedded populating properties
• 2e74699 fix(core): fix querying by embedded properties inside relations
• Additional commits viewable in compare view

Updates @mikro-orm/mysql from 5.9.7 to 6.2.0

Release notes

Sourced from @​mikro-orm/mysql's releases.

v6.2.0

6.2.0 (2024-04-09)

https://mikro-orm.io/blog/mikro-orm-6-2-released

Bug Fixes

• core: do not select 1:1 owning FK twice (fa69276)
• core: fix querying by embedded properties inside relations (2e74699), closes #5391
• core: fix support for custom repositories in @CreateRequestContext on type level (aacac83)
• core: fix TypeError when ordering by embedded populating properties (2c472ab), closes #5389
• core: ignore current context when creating repository instance (4c12fc5), closes #5395
• core: prefer entity type inference from the first parameter of entity manager methods (523963b)
• core: respect custom EntityManager type in em.fork() (bb1a3f9), closes #5415
• core: support passing Configuration instance to MikroORM.init (54a37d0), closes #5413
• entity-generator: allow arbitrary class and prop names as identifiers (#5359) (b0c0236)
• mariadb: rework pagination mechanism to fix extra results (a57cb19)
• mysql: support order by nulls first/last for raw query fragments in order by keys (a2a8f0d)
• postgres: drop text enum check constraints only when necessary (#5414) (5162345), closes #4112
• postgres: removed erroneous duplicates in FK discovery query (#5376) (eec2b38)
• query-builder: fix serialization hint of nested qb.joinAndSelect() calls (c2843b9)
• schema: improve detection of renamed columns (4d13c58)
• schema: rework dropping columns to support custom schemas and merge drop column queries (255f425)

Features

• core: add support for serialization groups (#5416) (818c290)
• core: allow better type-safety for custom types via IType (#5383) (0e18346)
• core: allow configuring driverOptions on replica level (05e81f8)
• core: include all dirty collections to UoW.getCollectionUpdates() (e7bd66f)
• core: make assign options configurable globally (bc9f6f5), closes #5410
• libsql: add libSQL driver (#5417) (6c63e4b), closes #5283
• mssql: add MS SQL Server driver (#1375) (eeaad45), closes #771
• postgres: allow defining deferred FK constraints (#5384) (f42d171), closes #5306
• query-builder: add limit 1 when executing query via getSingleResult() or execute('get') (c2b22e8), closes #5379
• query-builder: add qb.getLoggerContext() and qb.setLoggerContext() (779fa15), closes #5358
• schema: allow configuring updateRule and deleteRule for pivot tables (cc69c3c)
• schema: improve orm.schema.execute() to support executing batches (3c5a347)
• schema: support recreating the whole database via orm.schema.refreshDatabase() (2e4ab49)

Performance Improvements

• core: optimize metadata discovery (c322f9b)
• query-builder: remove unnecessary join branches when pagination is applied (d228976)

... (truncated)

Changelog

Sourced from @​mikro-orm/mysql's changelog.

6.2.0 (2024-04-09)

Bug Fixes

• core: do not select 1:1 owning FK twice (fa69276)
• core: fix querying by embedded properties inside relations (2e74699), closes #5391
• core: fix support for custom repositories in @CreateRequestContext on type level (aacac83)
• core: fix TypeError when ordering by embedded populating properties (2c472ab), closes #5389
• core: ignore current context when creating repository instance (4c12fc5), closes #5395
• core: prefer entity type inference from the first parameter of entity manager methods (523963b)
• core: respect custom EntityManager type in em.fork() (bb1a3f9), closes #5415
• core: support passing Configuration instance to MikroORM.init (54a37d0), closes #5413
• entity-generator: allow arbitrary class and prop names as identifiers (#5359) (b0c0236)
• mariadb: rework pagination mechanism to fix extra results (a57cb19)
• mysql: support order by nulls first/last for raw query fragments in order by keys (a2a8f0d)
• postgres: drop text enum check constraints only when necessary (#5414) (5162345), closes #4112
• postgres: removed erroneous duplicates in FK discovery query (#5376) (eec2b38)
• query-builder: fix serialization hint of nested qb.joinAndSelect() calls (c2843b9)
• schema: improve detection of renamed columns (4d13c58)
• schema: rework dropping columns to support custom schemas and merge drop column queries (255f425)

Features

• core: add support for serialization groups (#5416) (818c290)
• core: allow better type-safety for custom types via IType (#5383) (0e18346)
• core: allow configuring driverOptions on replica level (05e81f8)
• core: include all dirty collections to UoW.getCollectionUpdates() (e7bd66f)
• core: make assign options configurable globally (bc9f6f5), closes #5410
• libsql: add libSQL driver (#5417) (6c63e4b), closes #5283
• mssql: add MS SQL Server driver (#1375) (eeaad45), closes #771
• postgres: allow defining deferred FK constraints (#5384) (f42d171), closes #5306
• query-builder: add limit 1 when executing query via getSingleResult() or execute('get') (c2b22e8), closes #5379
• query-builder: add qb.getLoggerContext() and qb.setLoggerContext() (779fa15), closes #5358
• schema: allow configuring updateRule and deleteRule for pivot tables (cc69c3c)
• schema: improve orm.schema.execute() to support executing batches (3c5a347)
• schema: support recreating the whole database via orm.schema.refreshDatabase() (2e4ab49)

Performance Improvements

• core: optimize metadata discovery (c322f9b)
• query-builder: remove unnecessary join branches when pagination is applied (d228976)

6.1.12 (2024-03-24)

... (truncated)

Commits

• e85e7a9 chore(release): v6.2.0 [skip ci]
• 61410cd docs: add v6.2 blog post [skip ci]
• 005f86e test: coverage
• e7bd66f feat(core): include all dirty collections to UoW.getCollectionUpdates()
• 5d89ac2 chore: update mysql2 dependency + adjust result mapping to be compatible with...
• b0c0236 fix(entity-generator): allow arbitrary class and prop names as identifiers (#...
• acd6590 chore(deps): update patch/minor dependencies
• 05e81f8 feat(core): allow configuring driverOptions on replica level
• 2c472ab fix(core): fix TypeError when ordering by embedded populating properties
• 2e74699 fix(core): fix querying by embedded properties inside relations
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/nestjs/terminus/network/alerts).