| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Upgrade to release 1.3.19:
- orm: Adjusted the workings of the 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.
- orm: The name of the virtual column used when using the
AbstractConcreteBase and ConcreteBase classes can now be
customized, to allow for models that have a column that is
actually named type.
- sql: 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.
- mysql: The MySQL dialect will render FROM DUAL for a SELECT
statement that has no FROM clause but has a WHERE clause. This
allows things like "SELECT 1 WHERE EXISTS (subquery)" kinds of
queries to be used as well as other use cases.
- sqlite: Applied a sweep through all included dialects to ensure
names that contain single or double quotes are properly escaped
when querying system tables, for all Inspector methods that
accept object names as an argument (e.g. table names, view
names, etc). SQLite and MSSQL contained two quoting issues that
were repaired.
- mssql: Fixed bug where the mssql dialect incorrectly escaped
object names that contained ‘]’ character(s).
- Added a **kw argument to the DeclarativeMeta.__init__() method.
This allows a class to support the PEP 487 metaclass hook
__init_subclass__.
For more details have a look at the complete changelog:
https://docs.sqlalchemy.org/en/13/changelog/changelog_13.html
Signed-off-by: Leon Anavi <leon.anavi@konsulko.com>
Acked-by: Trevor Gamblin <trevor.gamblin@windriver.com>
Signed-off-by: Khem Raj <raj.khem@gmail.com>
|
|
|
Upgrade to release 1.3.18:
- orm: Improve error message when using Query.filter_by() in a
query where the first entity is not a mapped class.
- orm: Added a new parameter query_expression.default_expr to the
query_expression() construct, which will be appled to queries
automatically if the with_expression() option is not used.
- engine: Further refinements to the fixes to the "reset" agent
fixed in #5326, which now emits a warning when it is not being
correctly invoked and corrects for the behavior. Additional
scenarios have been identified and fixed where this warning was
being emitted.
- engine: Fixed issue in URL object where stringifying the object
would not URL encode special characters, preventing the URL from
being re-consumable as a real URL.
- sql: Added a “.schema” parameter to the table() construct,
allowing ad-hoc table expressions to also include a schema name.
- sql: Introduce IdentityOptions to store common parameters for
sequences and identity columns.
- schema: Fixed issue where dialect_options were omitted when a
database object (e.g., Table) was copied using tometadata().
Signed-off-by: Leon Anavi <leon.anavi@konsulko.com>
Acked-by: Trevor Gamblin <trevor.gamblin@windriver.com>
Signed-off-by: Khem Raj <raj.khem@gmail.com>
|
