Skip to content

Update sqlalchemy requirement from ~=1.4.22 to ~=1.4.40

ENDERZOMBI102 requested to merge dependabot/pip/sqlalchemy-approx-eq-1.4.40 into master

Created by: dependabot[bot]

Updates the requirements on sqlalchemy to permit the latest version.

Release notes

Sourced from sqlalchemy's releases.

1.4.40

Released: August 8, 2022

orm

  • [orm] [bug] Fixed issue where referencing a CTE multiple times in conjunction with a polymorphic SELECT could result in multiple "clones" of the same CTE being constructed, which would then trigger these two CTEs as duplicates. To resolve, the two CTEs are deep-compared when this occurs to ensure that they are equivalent, then are treated as equivalent.

    References: #8357

  • [orm] [bug] A _sql.select() construct that is passed a sole '*' argument for SELECT *, either via string, _sql.text(), or _sql.literal_column(), will be interpreted as a Core-level SQL statement rather than as an ORM level statement. This is so that the *, when expanded to match any number of columns, will result in all columns returned in the result. the ORM- level interpretation of _sql.select() needs to know the names and types of all ORM columns up front which can't be achieved when '*' is used.

    If '* is used amongst other expressions simultaneously with an ORM statement, an error is raised as this can't be interpreted correctly by the ORM.

    References: #8235

orm declarative

  • [orm] [declarative] [bug] Fixed issue where a hierarchy of classes set up as an abstract or mixin declarative classes could not declare standalone columns on a superclass that would then be copied correctly to a _orm.declared_attr callable that wanted to make use of them on a descendant class.

    References: #8190

engine

  • [engine] [usecase] Implemented new _engine.Connection.execution_options.yield_per execution option for _engine.Connection in Core, to mirror that of the same yield_per <orm_queryguide_yield_per> option available in the ORM. The option sets both the _engine.Connection.execution_options.stream_results option at the same time as invoking _engine.Result.yield_per(), to provide the most common streaming result configuration which also mirrors that of the

... (truncated)

Commits

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 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)

Merge request reports