[Dependency] Bump doctrine/dbal from 2.13.9 to 3.7.2 in /site

Bumps doctrine/dbal from 2.13.9 to 3.7.2.

Release notes

Sourced from doctrine/dbal's releases.

3.7.2

Release Notes for 3.7.2

3.7.2

Total issues resolved: 0

Total pull requests resolved: 9

Total contributors: 5

Static Analysis

6223: PHPStan 1.10.42 thanks to @derrabus

6211: PHPStan 1.10.41 thanks to @derrabus

6188: Make the type annotation for CompositeExpression::count more specific thanks to @oliverklee

6178: PHPStan 1.10.38 thanks to @derrabus

CI,Oracle

6217: Add Oracle v23 to CI testing thanks to @mvorisek

Schema Introspection,Test Suite

6210: Generalize CustomIntrospectionTest thanks to @derrabus

CI,MySQL

6207: Run tests on MySQL 8.2 thanks to @derrabus

Bug,MariaDB,Performance,Schema Introspection

6202: Fix MariaDB list columns performance thanks to @ausi

Bug,MariaDB,Schema Introspection

6189: MySQLSchemaManager: Check expected database type for json columns only thanks to @cgknx

3.7.1

Release Notes for 3.7.1

3.7.1

Total issues resolved: 0

Total pull requests resolved: 3

Total contributors: 3

Bug,Schema Comparison

... (truncated)

Upgrade guide

Sourced from doctrine/dbal's upgrade guide.

Note about upgrading: Doctrine uses static and runtime mechanisms to raise awareness about deprecated code.

Use of @deprecated docblock that is detected by IDEs (like PHPStorm) or Static Analysis tools (like Psalm, phpstan)

Use of our low-overhead runtime deprecation API, details: https://github.com/doctrine/deprecations/

Upgrade to 3.6

Deprecated not setting a schema manager factory

DBAL 4 will change the way the schema manager is created. To opt in to the new behavior, please configure the schema manager factory:
$configuration = new Configuration();
$configuration->setSchemaManagerFactory(new DefaultSchemaManagerFactory());
$connection = DriverManager::getConnection(
[/* your parameters */],
$configuration,
);
If you use a custom platform implementation, please make sure it implements the createSchemaManager()method . Otherwise, the connection will fail to create a schema manager.

Deprecated the url connection parameter

DBAL ships with a new and configurable DSN parser that can be used to parse a database URL into connection parameters understood by DriverManager.

Before
$connection = DriverManager::getConnection(
    ['url' => 'mysql://my-user:t0ps3cr3t@my-host/my-database']
);
After
$dsnParser  = new DsnParser(['mysql' => 'pdo_mysql']);
$connection = DriverManager::getConnection(
    $dsnParser->parse('mysql://my-user:t0ps3cr3t@my-host/my-database')
);

... (truncated)

Commits

0ac3c27 PHPStan 1.10.42 (#6223)
2caad21 Add Oracle v23 to CI testing (#6217)
1f1aad9 Fix MariaDB list columns performance (#6202)
3529bdf PHPStan 1.10.41 (#6211)
c86e909 Generalize CustomIntrospectionTest (#6210)
ebe1520 Run tests on MySQL 8.2 (#6207)
4134b86 MySQLSchemaManager. Check expected database type for json columns only. (#6189)
45941c6 Make the type annotation for CompositeExpression::count more specific (#6188)
d3954ec PHPStan 1.10.38 (#6178)
5b7bd66 Correct Column->getDefault() annotation (#6125)
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)

Codecov Report

Merging #1042 (2bb2838) into master (00d119c) will increase coverage by 22.66%. Report is 397 commits behind head on master. The diff coverage is 87.77%.

:exclamation: Your organization needs to install the Codecov GitHub app to enable full functionality.

Additional details and impacted files

[![Impacted file tree graph](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1042/graphs/tree.svg?width=650&height=150&src=pr&token=e62XEdReOc&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None)](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1042?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) ```diff @@ Coverage Diff @@ ## master #1042 +/- ## ============================================= + Coverage 23.32% 45.99% +22.66% ============================================= Files 220 44 -176 Lines 27303 3520 -23783 Branches 70 73 +3 ============================================= - Hits 6369 1619 -4750 + Misses 20866 1831 -19035 - Partials 68 70 +2 ``` | [Flag](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1042/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | Coverage Δ | | |---|---|---| | [autograder](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1042/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | `22.15% <59.25%> (+0.58%)` | :arrow_up: | | [js](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1042/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | `27.51% <ø> (-0.96%)` | :arrow_down: | | [migrator](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1042/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | `100.00% <100.00%> (ø)` | | | [php](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1042/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | `?` | | | [python_submitty_utils](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1042/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | `71.65% <ø> (ø)` | | | [submitty_daemon_jobs](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1042/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | `91.01% <ø> (ø)` | | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None#carryforward-flags-in-the-pull-request-comment) to find out more.

wwu-cs / Submitty