---
- branch: MAIN
  date: Wed Jul  8 14:40:26 UTC 2020
  files:
  - new: '1.63'
    old: '1.62'
    path: pkgsrc/databases/py-sqlalchemy/Makefile
    pathrev: pkgsrc/databases/py-sqlalchemy/Makefile@1.63
    type: modified
  - new: '1.57'
    old: '1.56'
    path: pkgsrc/databases/py-sqlalchemy/distinfo
    pathrev: pkgsrc/databases/py-sqlalchemy/distinfo@1.57
    type: modified
  id: 20200708T144026Z.e797ed20a86ce39814b3e3b8f9ea48fd1fee7a7a
  log: "py-sqlalchemy: updated to 1.3.18\n\n1.3.18\n\norm\n\n[orm] [usecase]\nImprove
    error message when using Query.filter_by() in a query where the first entity is
    not a mapped class.\n\n[orm] [usecase]\nAdded 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. Pull request courtesy Haoyu Sun.\n\nengine\n\n[engine]
    [bug]\nFurther refinements to the fixes to the â\x80\x9Cresetâ\x80\x9D 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.\n\n[engine] [bug]\nFixed 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. Pull request courtesy Miguel Grinberg.\n\nsql\n\n[sql]
    [usecase]\nAdded a â\x80\x9C.schemaâ\x80\x9D parameter to the table() construct,
    allowing ad-hoc table expressions to also include a schema name. Pull request
    courtesy Dylan Modesitt.\n\n[sql] [bug]\nCorrectly apply self_group in type_coerce
    element.\nThe type coerce element did not correctly apply grouping rules when
    using in an expression\n\n[sql] [bug]\nAdded Select.with_hint() output to the
    generic SQL string that is produced when calling str() on a statement. Previously,
    this clause would be omitted under the assumption that it was dialect specific.
    The hint text is presented within brackets to indicate the rendering of such hints
    varies among backends.\n\n[sql] [schema]\nIntroduce IdentityOptions to store common
    parameters for sequences and identity columns.\n\n[sql] [change] [sybase]\nAdded
    .offset support to sybase dialect. Pull request courtesy Alan D. Snow.\n\nschema\n\n[schema]
    [bug]\nFixed issue where dialect_options were omitted when a database object (e.g.,
    Table) was copied using tometadata().\n\nmysql\n\n[mysql] [usecase]\nImplemented
    row-level locking support for mysql. Pull request courtesy Quentin Somerville.\n\nsqlite\n\n[sqlite]
    [usecase]\nSQLite 3.31 added support for computed column. This change enables
    their support in SQLAlchemy when targeting SQLite.\n\n[sqlite] [bug]\nAdded â\x80\x9Cexistsâ\x80\x9D
    to the list of reserved words for SQLite so that this word will be quoted when
    used as a label or column name. Pull request courtesy Thodoris Sotiropoulos.\n\nmssql\n\n[mssql]
    [bug]\nRefined the logic used by the SQL Server dialect to interpret multi-part
    schema names that contain many dots, to not actually lose any dots if the name
    does not have bracking or quoting used, and additionally to support a â\x80\x9Cdbnameâ\x80\x9D
    token that has many parts including that it may have multiple, independently-bracketed
    sections.\n\n[mssql] [bug] [pyodbc]\nFixed an issue in the pyodbc connector such
    that a warning about pyodbc â\x80\x9Cdrivernameâ\x80\x9D would be emitted when
    using a totally empty URL. Empty URLs are normal when producing a non-connected
    dialect object or when using the â\x80\x9Ccreatorâ\x80\x9D argument to create_engine().
    The warning now only emits if the driver name is missing but other parameters
    are still present.\n\n[mssql] [bug]\nFixed issue with assembling the ODBC connection
    string for the pyodbc DBAPI. Tokens containing semicolons and/or braces â\x80\x9C{}â\x80\x9D
    were not being correctly escaped, causing the ODBC driver to misinterpret the
    connection string attributes.\n\n[mssql] [bug]\nFixed issue where datetime.time
    parameters were being converted to datetime.datetime, making them incompatible
    with comparisons like >= against an actual TIME column.\n\n[mssql] [bug]\nFixed
    an issue where the is_disconnect function in the SQL Server pyodbc dialect was
    incorrectly reporting the disconnect state when the exception messsage had a substring
    that matched a SQL Server ODBC error code.\n\n[mssql] [change]\nMoved the supports_sane_rowcount_returning
    = False requirement from the PyODBCConnector level to the MSDialect_pyodbc since
    pyodbc does work properly in some circumstances.\n\noracle\n\n[oracle] [bug] [reflection]\nFixed
    bug in Oracle dialect where indexes that contain the full set of primary key columns
    would be mistaken as the primary key index itself, which is omitted, even if there
    were multiples. The check has been refined to compare the name of the primary
    key constraint against the index name itself, rather than trying to guess based
    on the columns present in the index.\n\nmisc\n\n[change] [examples]\nAdded new
    option --raw to the examples.performance suite which will dump the raw profile
    test for consumption by any number of profiling visualizer tools. Removed the
    â\x80\x9Crunsnakeâ\x80\x9D option as runsnake is very hard to build at this point;\n"
  module: pkgsrc
  subject: 'CVS commit: pkgsrc/databases/py-sqlalchemy'
  unixtime: '1594219226'
  user: adam