[Dependency] Bump sqlalchemy from 1.4.29 to 2.0.23 in /.setup/pip

[dependabot[bot]]

Bumps sqlalchemy from 1.4.29 to 2.0.23.

Release notes

Sourced from sqlalchemy's releases.

2.0.23

Released: November 2, 2023

orm

• [orm] [usecase] Implemented the _orm.Session.bulk_insert_mappings.render_nulls parameter for new style bulk ORM inserts, allowing render_nulls=True as an execution option. This allows for bulk ORM inserts with a mixture of None values in the parameter dictionaries to use a single batch of rows for a given set of dicationary keys, rather than breaking up into batches that omit the NULL columns from each INSERT.

  References: #10575

• [orm] [bug] Fixed issue where the __allow_unmapped__ directive failed to allow for legacy Column / deferred() mappings that nonetheless had annotations such as Any or a specific type without Mapped[] as their type, without errors related to locating the attribute name.

  References: #10516

• [orm] [bug] Fixed caching bug where using the _orm.with_expression() construct in conjunction with loader options _orm.selectinload(), _orm.lazyload() would fail to substitute bound parameter values correctly on subsequent caching runs.

  References: #10570

• [orm] [bug] Fixed bug in ORM annotated declarative where using a ClassVar that nonetheless referred in some way to an ORM mapped class name would fail to be interpreted as a ClassVar that's not mapped.

  References: #10472

sql

• [sql] [usecase] Implemented "literal value processing" for the Interval datatype for both the PostgreSQL and Oracle dialects, allowing literal rendering of interval values. Pull request courtesy Indivar Mishra.

  References: #9737

• [sql] [bug] Fixed issue where using the same bound parameter more than once with literal_execute=True in some combinations with other literal rendering parameters would cause the wrong values to render due to an iteration issue.

... (truncated)

Commits

• See full diff 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)

[dependabot[bot]]

The following labels could not be found: dependencies.

[codecov-commenter]

Codecov Report

Merging #1046 (7528afd) into master (00d119c) will decrease coverage by 2.57%. Report is 397 commits behind head on master. The diff coverage is 6.88%.

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

Additional details and impacted files

[](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1046?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) ```diff @@ Coverage Diff @@ ## master #1046 +/- ## ============================================ - Coverage 23.32% 20.75% -2.57% - Complexity 7818 8232 +414 ============================================ Files 220 201 -19 Lines 27303 26537 -766 Branches 70 73 +3 ============================================ - Hits 6369 5509 -860 - Misses 20866 20958 +92 - Partials 68 70 +2 ``` | [Flag](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1046/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/1046/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | `?` | | | [js](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1046/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/1046/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | `?` | | | [php](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1046/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | `20.15% <6.88%> (-0.06%)` | :arrow_down: | | [python_submitty_utils](https://app.codecov.io/gh/wwu-cs/Submitty/pull/1046/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/1046/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | `?` | | 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.