Changelog
### 1.3.4
```
:released: May 27, 2019
.. change::
:tags: feature, mssql
:tickets: 4657
Added support for SQL Server filtered indexes, via the ``mssql_where``
parameter which works similarly to that of the ``postgresql_where`` index
function in the PostgreSQL dialect.
.. seealso::
:ref:`mssql_index_where`
.. change::
:tags: bug, misc
:tickets: 4625
Removed errant "sqla_nose.py" symbol from MANIFEST.in which created an
undesirable warning message.
.. change::
:tags: bug, sql
:tickets: 4653
Fixed that the :class:`.GenericFunction` class was inadvertently
registering itself as one of the named functions. Pull request courtesy
Adrien Berchet.
.. change::
:tags: bug, engine, postgresql
:tickets: 4663
Moved the "rollback" which occurs during dialect initialization so that it
occurs after additional dialect-specific initialize steps, in particular
those of the psycopg2 dialect which would inadvertently leave transactional
state on the first new connection, which could interfere with some
psycopg2-specific APIs which require that no transaction is started. Pull
request courtesy Matthew Wilkes.
.. change::
:tags: bug, orm
:tickets: 4695
Fixed issue where the :paramref:`.AttributeEvents.active_history` flag
would not be set for an event listener that propgated to a subclass via the
:paramref:`.AttributeEvents.propagate` flag. This bug has been present
for the full span of the :class:`.AttributeEvents` system.
.. change::
:tags: bug, orm
:tickets: 4690
Fixed regression where new association proxy system was still not proxying
hybrid attributes when they made use of the ``hybrid_property.expression``
decorator to return an alternate SQL expression, or when the hybrid
returned an arbitrary :class:`.PropComparator`, at the expression level.
This involved futher generalization of the heuristics used to detect the
type of object being proxied at the level of :class:`.QueryableAttribute`,
to better detect if the descriptor ultimately serves mapped classes or
column expressions.
.. change::
:tags: bug, orm
:tickets: 4686
Applied the mapper "configure mutex" against the declarative class mapping
process, to guard against the race which can occur if mappers are used
while dynamic module import schemes are still in the process of configuring
mappers for related classes. This does not guard against all possible race
conditions, such as if the concurrent import has not yet encountered the
dependent classes as of yet, however it guards against as much as possible
within the SQLAlchemy declarative process.
.. change::
:tags: bug, mssql
:tickets: 4680
Added error code 20047 to "is_disconnect" for pymssql. Pull request
courtesy Jon Schuff.
.. change::
:tags: bug, postgresql, orm
:tickets: 4661
Fixed an issue where the "number of rows matched" warning would emit even if
the dialect reported "supports_sane_multi_rowcount=False", as is the case
for psycogp2 with ``use_batch_mode=True`` and others.
.. change::
:tags: bug, sql
:tickets: 4618
Fixed issue where double negation of a boolean column wouldn't reset
the "NOT" operator.
.. change::
:tags: mysql, bug
:tickets: 4650
Added support for DROP CHECK constraint which is required by MySQL 8.0.16
to drop a CHECK constraint; MariaDB supports plain DROP CONSTRAINT. The
logic distinguishes between the two syntaxes by checking the server version
string for MariaDB presence. Alembic migrations has already worked
around this issue by implementing its own DROP for MySQL / MariaDB CHECK
constraints, however this change implements it straight in Core so that its
available for general use. Pull request courtesy Hannes Hansen.
.. change::
:tags: bug, orm
:tickets: 4647
A warning is now emitted for the case where a transient object is being
merged into the session with :meth:`.Session.merge` when that object is
already transient in the :class:`.Session`. This warns for the case where
the object would normally be double-inserted.
.. change::
:tags: bug, orm
:tickets: 4676
Fixed regression in new relationship m2o comparison logic first introduced
at :ref:`change_4359` when comparing to an attribute that is persisted as
NULL and is in an un-fetched state in the mapped instance. Since the
attribute has no explicit default, it needs to default to NULL when
accessed in a persistent setting.
.. change::
:tags: bug, sql
:tickets: 4569
The :class:`.GenericFunction` namespace is being migrated so that function
names are looked up in a case-insensitive manner, as SQL functions do not
collide on case sensitive differences nor is this something which would
occur with user-defined functions or stored procedures. Lookups for
functions declared with :class:`.GenericFunction` now use a case
insensitive scheme, however a deprecation case is supported which allows
two or more :class:`.GenericFunction` objects with the same name of
different cases to exist, which will cause case sensitive lookups to occur
for that particular name, while emitting a warning at function registration
time. Thanks to Adrien Berchet for a lot of work on this complicated
feature.
.. changelog::
```
Links
- PyPI: https://pypi.org/project/sqlalchemy
- Changelog: https://pyup.io/changelogs/sqlalchemy/
- Homepage: http://www.sqlalchemy.org
pyup-bot
commented
5 years ago
Update boto3 from 1.9.156 to 1.9.159.
Changelog
### 1.9.159 ``` ======= * api-change:``iotevents-data``: [``botocore``] Update iotevents-data client to latest version * api-change:``iotevents``: [``botocore``] Update iotevents client to latest version * api-change:``pinpoint-email``: [``botocore``] Update pinpoint-email client to latest version * api-change:``iotanalytics``: [``botocore``] Update iotanalytics client to latest version * api-change:``codecommit``: [``botocore``] Update codecommit client to latest version * api-change:``rds-data``: [``botocore``] Update rds-data client to latest version * api-change:``rds``: [``botocore``] Update rds client to latest version * api-change:``servicecatalog``: [``botocore``] Update servicecatalog client to latest version * api-change:``kafka``: [``botocore``] Update kafka client to latest version ``` ### 1.9.158 ``` ======= * api-change:``ssm``: [``botocore``] Update ssm client to latest version * api-change:``securityhub``: [``botocore``] Update securityhub client to latest version * api-change:``iotthingsgraph``: [``botocore``] Update iotthingsgraph client to latest version * api-change:``dlm``: [``botocore``] Update dlm client to latest version * api-change:``rds``: [``botocore``] Update rds client to latest version * api-change:``ec2``: [``botocore``] Update ec2 client to latest version ``` ### 1.9.157 ``` ======= * api-change:``groundstation``: [``botocore``] Update groundstation client to latest version * api-change:``transcribe``: [``botocore``] Update transcribe client to latest version * api-change:``chime``: [``botocore``] Update chime client to latest version * api-change:``rds``: [``botocore``] Update rds client to latest version * api-change:``waf``: [``botocore``] Update waf client to latest version * api-change:``pinpoint-email``: [``botocore``] Update pinpoint-email client to latest version * api-change:``robomaker``: [``botocore``] Update robomaker client to latest version * api-change:``sts``: [``botocore``] Update sts client to latest version * api-change:``storagegateway``: [``botocore``] Update storagegateway client to latest version ```Links
- PyPI: https://pypi.org/project/boto3 - Changelog: https://pyup.io/changelogs/boto3/ - Repo: https://github.com/boto/boto3Update sqlalchemy from 1.3.3 to 1.3.4.
Changelog
### 1.3.4 ``` :released: May 27, 2019 .. change:: :tags: feature, mssql :tickets: 4657 Added support for SQL Server filtered indexes, via the ``mssql_where`` parameter which works similarly to that of the ``postgresql_where`` index function in the PostgreSQL dialect. .. seealso:: :ref:`mssql_index_where` .. change:: :tags: bug, misc :tickets: 4625 Removed errant "sqla_nose.py" symbol from MANIFEST.in which created an undesirable warning message. .. change:: :tags: bug, sql :tickets: 4653 Fixed that the :class:`.GenericFunction` class was inadvertently registering itself as one of the named functions. Pull request courtesy Adrien Berchet. .. change:: :tags: bug, engine, postgresql :tickets: 4663 Moved the "rollback" which occurs during dialect initialization so that it occurs after additional dialect-specific initialize steps, in particular those of the psycopg2 dialect which would inadvertently leave transactional state on the first new connection, which could interfere with some psycopg2-specific APIs which require that no transaction is started. Pull request courtesy Matthew Wilkes. .. change:: :tags: bug, orm :tickets: 4695 Fixed issue where the :paramref:`.AttributeEvents.active_history` flag would not be set for an event listener that propgated to a subclass via the :paramref:`.AttributeEvents.propagate` flag. This bug has been present for the full span of the :class:`.AttributeEvents` system. .. change:: :tags: bug, orm :tickets: 4690 Fixed regression where new association proxy system was still not proxying hybrid attributes when they made use of the ``hybrid_property.expression`` decorator to return an alternate SQL expression, or when the hybrid returned an arbitrary :class:`.PropComparator`, at the expression level. This involved futher generalization of the heuristics used to detect the type of object being proxied at the level of :class:`.QueryableAttribute`, to better detect if the descriptor ultimately serves mapped classes or column expressions. .. change:: :tags: bug, orm :tickets: 4686 Applied the mapper "configure mutex" against the declarative class mapping process, to guard against the race which can occur if mappers are used while dynamic module import schemes are still in the process of configuring mappers for related classes. This does not guard against all possible race conditions, such as if the concurrent import has not yet encountered the dependent classes as of yet, however it guards against as much as possible within the SQLAlchemy declarative process. .. change:: :tags: bug, mssql :tickets: 4680 Added error code 20047 to "is_disconnect" for pymssql. Pull request courtesy Jon Schuff. .. change:: :tags: bug, postgresql, orm :tickets: 4661 Fixed an issue where the "number of rows matched" warning would emit even if the dialect reported "supports_sane_multi_rowcount=False", as is the case for psycogp2 with ``use_batch_mode=True`` and others. .. change:: :tags: bug, sql :tickets: 4618 Fixed issue where double negation of a boolean column wouldn't reset the "NOT" operator. .. change:: :tags: mysql, bug :tickets: 4650 Added support for DROP CHECK constraint which is required by MySQL 8.0.16 to drop a CHECK constraint; MariaDB supports plain DROP CONSTRAINT. The logic distinguishes between the two syntaxes by checking the server version string for MariaDB presence. Alembic migrations has already worked around this issue by implementing its own DROP for MySQL / MariaDB CHECK constraints, however this change implements it straight in Core so that its available for general use. Pull request courtesy Hannes Hansen. .. change:: :tags: bug, orm :tickets: 4647 A warning is now emitted for the case where a transient object is being merged into the session with :meth:`.Session.merge` when that object is already transient in the :class:`.Session`. This warns for the case where the object would normally be double-inserted. .. change:: :tags: bug, orm :tickets: 4676 Fixed regression in new relationship m2o comparison logic first introduced at :ref:`change_4359` when comparing to an attribute that is persisted as NULL and is in an un-fetched state in the mapped instance. Since the attribute has no explicit default, it needs to default to NULL when accessed in a persistent setting. .. change:: :tags: bug, sql :tickets: 4569 The :class:`.GenericFunction` namespace is being migrated so that function names are looked up in a case-insensitive manner, as SQL functions do not collide on case sensitive differences nor is this something which would occur with user-defined functions or stored procedures. Lookups for functions declared with :class:`.GenericFunction` now use a case insensitive scheme, however a deprecation case is supported which allows two or more :class:`.GenericFunction` objects with the same name of different cases to exist, which will cause case sensitive lookups to occur for that particular name, while emitting a warning at function registration time. Thanks to Adrien Berchet for a lot of work on this complicated feature. .. changelog:: ```Links
- PyPI: https://pypi.org/project/sqlalchemy - Changelog: https://pyup.io/changelogs/sqlalchemy/ - Homepage: http://www.sqlalchemy.orgUpdate kafka-python from 1.4.3 to 1.4.6.
Changelog
### 1.4.6 ``` This is a patch release primarily focused on bugs related to concurrency, SSL connections and testing, and SASL authentication: Client Concurrency Issues (Race Conditions / Deadlocks) * Fix race condition in `protocol.send_bytes` (isamaru / PR 1752) * Do not call `state_change_callback` with lock (dpkp / PR 1775) * Additional BrokerConnection locks to synchronize protocol/IFR state (dpkp / PR 1768) * Send pending requests before waiting for responses (dpkp / PR 1762) * Avoid race condition on `client._conns` in send() (dpkp / PR 1772) * Hold lock during `client.check_version` (dpkp / PR 1771) Producer Wakeup / TimeoutError * Dont wakeup during `maybe_refresh_metadata` -- it is only called by poll() (dpkp / PR 1769) * Dont do client wakeup when sending from sender thread (dpkp / PR 1761) SSL - Python3.7 Support / Bootstrap Hostname Verification / Testing * Wrap SSL sockets after connecting for python3.7 compatibility (dpkp / PR 1754) * Allow configuration of SSL Ciphers (dpkp / PR 1755) * Maintain shadow cluster metadata for bootstrapping (dpkp / PR 1753) * Generate SSL certificates for local testing (dpkp / PR 1756) * Rename ssl.keystore.location and ssl.truststore.location config files (dpkp) * Reset reconnect backoff on SSL connection (dpkp / PR 1777) SASL - OAuthBearer support / api version bugfix * Fix 0.8.2 protocol quick detection / fix SASL version check (dpkp / PR 1763) * Update sasl configuration docstrings to include supported mechanisms (dpkp) * Support SASL OAuthBearer Authentication (pt2pham / PR 1750) Miscellaneous Bugfixes * Dont force metadata refresh when closing unneeded bootstrap connections (dpkp / PR 1773) * Fix possible AttributeError during conn._close_socket (dpkp / PR 1776) * Return connection state explicitly after close in connect() (dpkp / PR 1778) * Fix flaky conn tests that use time.time (dpkp / PR 1758) * Add py to requirements-dev (dpkp) * Fixups to benchmark scripts for py3 / new KafkaFixture interface (dpkp) ``` ### 1.4.5 ``` This release is primarily focused on addressing lock contention and other coordination issues between the KafkaConsumer and the background heartbeat thread that was introduced in the 1.4 release. Consumer * connections_max_idle_ms must be larger than request_timeout_ms (jeffwidman / PR 1688) * Avoid race condition during close() / join heartbeat thread (dpkp / PR 1735) * Use last offset from fetch v4 if available to avoid getting stuck in compacted topic (keithks / PR 1724) * Synchronize puts to KafkaConsumer protocol buffer during async sends (dpkp / PR 1733) * Improve KafkaConsumer join group / only enable Heartbeat Thread during stable group (dpkp / PR 1695) * Remove unused `skip_double_compressed_messages` (jeffwidman / PR 1677) * Fix commit_offsets_async() callback (Faqa / PR 1712) Client * Retry bootstrapping after backoff when necessary (dpkp / PR 1736) * Recheck connecting nodes sooner when refreshing metadata (dpkp / PR 1737) * Avoid probing broker versions twice on newer brokers (dpkp / PR 1738) * Move all network connections and writes to KafkaClient.poll() (dpkp / PR 1729) * Do not require client lock for read-only operations (dpkp / PR 1730) * Timeout all unconnected conns (incl SSL) after request_timeout_ms (dpkp / PR 1696) Admin Client * Fix AttributeError in response topic error codes checking (jeffwidman) * Fix response error checking in KafkaAdminClient send_to_controller (jeffwidman) * Fix NotControllerError check (jeffwidman) Core/Protocol * Fix default protocol parser version / 0.8.2 version probe (dpkp / PR 1740) * Make NotEnoughReplicasError/NotEnoughReplicasAfterAppendError retriable (le-linh / PR 1722) Bugfixes * Use copy() in metrics() to avoid thread safety issues (emeric254 / PR 1682) Test Infrastructure * Mock dns lookups in test_conn (dpkp / PR 1739) * Use test.fixtures.version not test.conftest.version to avoid warnings (dpkp / PR 1731) * Fix test_legacy_correct_metadata_response on x86 arch (stanislavlevin / PR 1718) * Travis CI: 'sudo' tag is now deprecated in Travis (cclauss / PR 1698) * Use Popen.communicate() instead of Popen.wait() (Baisang / PR 1689) Compatibility * Catch thrown OSError by python 3.7 when creating a connection (danjo133 / PR 1694) * Update travis test coverage: 2.7, 3.4, 3.7, pypy2.7 (jeffwidman, dpkp / PR 1614) * Drop dependency on sphinxcontrib-napoleon (stanislavlevin / PR 1715) * Remove unused import from kafka/producer/record_accumulator.py (jeffwidman / PR 1705) * Fix SSL connection testing in Python 3.7 (seanthegeek, silentben / PR 1669) ``` ### 1.4.4 ``` Bugfixes * (Attempt to) Fix deadlock between consumer and heartbeat (zhgjun / dpkp 1628) * Fix Metrics dict memory leak (kishorenc 1569) Client * Support Kafka record headers (hnousiainen 1574) * Set socket timeout for the write-side of wake socketpair (Fleurer 1577) * Add kerberos domain name config for gssapi sasl mechanism handshake (the-sea 1542) * Support smaller topic metadata fetch during bootstrap (andyxning 1541) * Use TypeError for invalid timeout type (jeffwidman 1636) * Break poll if closed (dpkp) Admin Client * Add KafkaAdminClient class (llamahunter 1540) * Fix list_consumer_groups() to query all brokers (jeffwidman 1635) * Stop using broker-errors for client-side problems (jeffwidman 1639) * Fix send to controller (jeffwidman 1640) * Add group coordinator lookup (jeffwidman 1641) * Fix describe_groups (jeffwidman 1642) * Add list_consumer_group_offsets() (jeffwidman 1643) * Remove support for api versions as strings from KafkaAdminClient (jeffwidman 1644) * Set a clear default value for `validate_only`/`include_synonyms` (jeffwidman 1645) * Bugfix: Always set this_groups_coordinator_id (jeffwidman 1650) Consumer * Fix linter warning on import of ConsumerRebalanceListener (ben-harack 1591) * Remove ConsumerTimeout (emord 1587) * Return future from commit_offsets_async() (ekimekim 1560) Core / Protocol * Add protocol structs for {Describe,Create,Delete} Acls (ulrikjohansson 1646/partial) * Pre-compile pack/unpack function calls (billyevans / jeffwidman 1619) * Don't use `kafka.common` internally (jeffwidman 1509) * Be explicit with tuples for %s formatting (jeffwidman 1634) Documentation * Document connections_max_idle_ms (jeffwidman 1531) * Fix sphinx url (jeffwidman 1610) * Update remote urls: snappy, https, etc (jeffwidman 1603) * Minor cleanup of testing doc (jeffwidman 1613) * Various docstring / pep8 / code hygiene cleanups (jeffwidman 1647) Test Infrastructure * Stop pinning `pylint` (jeffwidman 1611) * (partial) Migrate from `Unittest` to `pytest` (jeffwidman 1620) * Minor aesthetic cleanup of partitioner tests (jeffwidman 1618) * Cleanup fixture imports (jeffwidman 1616) * Fix typo in test file name (jeffwidman) * Remove unused ivy_root variable (jeffwidman) * Add test fixtures for kafka versions 1.0.2 -> 2.0.1 (dpkp) * Bump travis test for 1.x brokers to 1.1.1 (dpkp) Logging / Error Messages * raising logging level on messages signalling data loss (sibiryakov 1553) * Stop using deprecated log.warn() (jeffwidman 1615) * Fix typo in logging message (jeffwidman) Compatibility * Vendor enum34 (jeffwidman 1604) * Bump vendored `six` to `1.11.0` (jeffwidman 1602) * Vendor `six` consistently (jeffwidman 1605) * Prevent `pylint` import errors on `six.moves` (jeffwidman 1609) ```Links
- PyPI: https://pypi.org/project/kafka-python - Changelog: https://pyup.io/changelogs/kafka-python/ - Repo: https://github.com/dpkp/kafka-pythonUpdate tornado from 5.1.1 to 6.0.2.
Changelog
Links
- PyPI: https://pypi.org/project/tornado - Changelog: https://pyup.io/changelogs/tornado/ - Homepage: http://www.tornadoweb.org/