Bump sqlalchemy from 1.3.16 to 1.3.19

Bumps sqlalchemy from 1.3.16 to 1.3.19.

Release notes

Sourced from sqlalchemy's releases.

1.3.19

Released: August 17, 2020

orm

• [orm] [usecase] Adjusted the workings of the _orm.Mapper.all_orm_descriptors() accessor to represent the attributes in the order that they are located in a deterministic way, assuming the use of Python 3.6 or higher which maintains the sorting order of class attributes based on how they were declared. This sorting is not guaranteed to match the declared order of attributes in all cases however; see the method documentation for the exact scheme.

  References: #5494

orm declarative

• [declarative] [orm] [usecase] The name of the virtual column used when using the _declarative.AbstractConcreteBase and _declarative.ConcreteBase classes can now be customized, to allow for models that have a column that is actually named type. Pull request courtesy Jesse-Bakker.

  References: #5513

sql

• [sql] [bug] Repaired an issue where the "ORDER BY" clause rendering a label name rather than a complete expression, which is particularly important for SQL Server, would fail to occur if the expression were enclosed in a parenthesized grouping in some cases. This case has been added to test support. The change additionally adjusts the "automatically add ORDER BY columns when DISTINCT is present" behavior of ORM query, deprecated in 1.4, to more accurately detect column expressions that are already present.

  References: #5470

• [sql] [bug] [datatypes] The LookupError message will now provide the user with up to four possible values that a column is constrained to via the Enum. Values longer than 11 characters will be truncated and replaced with ellipses. Pull request courtesy Ramon Williams.

  References: #4733

• [sql] [bug] Fixed issue where the _engine.Connection.execution_options.schema_translate_map

... (truncated)

Commits

• See full diff in compare view