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

[dependabot[bot]]

Bumps sqlalchemy from 1.4.29 to 2.0.22.

Release notes

Sourced from sqlalchemy's releases.

2.0.22

Released: October 12, 2023

orm

• [orm] [usecase] Added method _orm.Session.get_one() that behaves like _orm.Session.get() but raises an exception instead of returning None if no instance was found with the provided primary key. Pull request courtesy of Carlos Sousa.

  References: #10202

• [orm] [usecase] Added an option to permanently close sessions. Set to False the new parameter _orm.Session.close_resets_only will prevent a _orm.Session from performing any other operation after _orm.Session.close() has been called.

  Added new method _orm.Session.reset() that will reset a _orm.Session to its initial state. This is an alias of _orm.Session.close(), unless _orm.Session.close_resets_only is set to False.

  References: #7787

• [orm] [bug] Fixed a wide range of _orm.mapped_column() parameters that were not being transferred when using the _orm.mapped_column() object inside of a pep-593 Annotated object, including _orm.mapped_column.sort_order, _orm.mapped_column.deferred, _orm.mapped_column.autoincrement, _orm.mapped_column.system, _orm.mapped_column.info etc.

  Additionally, it remains not supported to have dataclass arguments, such as _orm.mapped_column.kw_only, _orm.mapped_column.default_factory etc. indicated within the _orm.mapped_column() received by Annotated, as this is not supported with pep-681 Dataclass Transforms. A warning is now emitted when these parameters are used within Annotated in this way (and they continue to be ignored).

  References: #10046, #10369

• [orm] [bug] Fixed issue where calling _engine.Result.unique() with a new-style select() query in the ORM, where one or more columns yields values that are of "unknown hashability", typically when using JSON functions like func.json_build_object() without providing a type, would fail internally when the returned values were not actually hashable. The behavior is repaired to test the objects as they are received for

... (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 #1026 (f26076c) 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.

@@             Coverage Diff              @@
##             master    #1026      +/-   ##
============================================
- 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	Coverage Δ
autograder	?
js	27.51% <ø> (-0.96%)	:arrow_down:
migrator	?
php	20.15% <6.88%> (-0.06%)	:arrow_down:
python_submitty_utils	71.65% <ø> (ø)
submitty_daemon_jobs	?

Flags with carried forward coverage won't be shown. Click here to find out more.

[dependabot[bot]]

Superseded by #1046.