delta/python-packages/sqlalchemy.git/lib/sqlalchemy/util, branch workflow_test_cython github.com: zzzeek/sqlalchemy.git Replace c extension with cython versions. 2021-12-17T20:29:05+00:00 Federico Caselli cfederico87@gmail.com 2021-01-01T15:09:01+00:00 76fa211620de167b76846f0e5db5b64b8756ad48 Re-implement c version immutabledict / processors / resultproxy / utils with cython. Performance is in general in par or better than the c version Added a collection module that has cython version of OrderedSet and IdentitySet Added a new test/perf file to compare the implementations. Run ``python test/perf/compiled_extensions.py all`` to execute the comparison test. See results here: https://docs.google.com/document/d/1nOcDGojHRtXEkuy4vNXcW_XOJd9gqKhSeALGG3kYr6A/edit?usp=sharing Fixes: #7256 Change-Id: I2930ef1894b5048210384728118e586e813f6a76 Signed-off-by: Federico Caselli <cfederico87@gmail.com> 
Re-implement c version immutabledict / processors / resultproxy / utils with cython.
Performance is in general in par or better than the c version
Added a collection module that has cython version of OrderedSet and IdentitySet

Added a new test/perf file to compare the implementations.
Run ``python test/perf/compiled_extensions.py all`` to execute the comparison test.

See results here: https://docs.google.com/document/d/1nOcDGojHRtXEkuy4vNXcW_XOJd9gqKhSeALGG3kYr6A/edit?usp=sharing

Fixes: #7256
Change-Id: I2930ef1894b5048210384728118e586e813f6a76
Signed-off-by: Federico Caselli <cfederico87@gmail.com>
Include import error message when greenlet is not installed 2021-12-09T20:48:29+00:00 Federico Caselli cfederico87@gmail.com 2021-12-09T20:47:22+00:00 533f5718904b620be8d63f2474229945d6f8ba5d Fixes: #7419 Change-Id: I0c604875a80287acff3bab732f67601a5e2db98c 
Fixes: #7419
Change-Id: I0c604875a80287acff3bab732f67601a5e2db98c
provide connectionfairy on initialize 2021-11-29T18:46:23+00:00 Mike Bayer mike_mp@zzzcomputing.com 2021-11-26T15:17:38+00:00 db85d28a857945ce021e27a187a14999eeb5c89e This is so that dialect methods that are called within init can assume the same argument structure as when they are called in other places; we can nail down the type of object as well. This change seems to mostly impact the isolation level routines in the dialects, as these are called during initialize() as well as on established connections. these methods can now assume a non-proxied DBAPI connection object in all cases, as it is commonly required that attributes like ".autocommit" are set on the object which don't work well in a proxied situation. Other changes: * adds an interface for the "connectionfairy" concept called PoolProxiedConnection. * Removes ``Connectable`` superclass of Connection. ``Connectable`` was originally meant to provide for the "method which accepts connection or engine" theme. As this pattern is greatly reduced in 2.0 and Engine no longer extends from it, the ``Connectable`` superclass doesnt serve any real purpose. Leading from that, to set this in I also applied pep 484 annotations to the Dialect base, and then in the interests of seeing some of the typing information show up in my IDE did a little bit for Engine, Connection and others. I hope that it's feasible that we can add annotations to specific classes and attributes ahead of when we actually try to mass-populate the whole library. This was the original spirit of pep-484 that we can apply annotations gradually. I do of course want to try to do a mass-populate although i think even in that case we will end up doing a lot of manual work anyway (in particular for the changes here which are distinct from what the stubs have). Fixes: #7122 Change-Id: I5dd7fbff8a7ae520a81c165091af12a6a68826db 
This is so that dialect methods that are called within init
can assume the same argument structure as when they are called
in other places; we can nail down the type of object as well.

This change seems to mostly impact the isolation level routines
in the dialects, as these are called during initialize()
as well as on established connections.  these methods can now
assume a non-proxied DBAPI connection object in all cases,
as it is commonly required that attributes like ".autocommit"
are set on the object which don't work well in a proxied
situation.

Other changes:

* adds an interface for the "connectionfairy" concept
  called PoolProxiedConnection.
* Removes ``Connectable`` superclass of Connection.
  ``Connectable`` was originally meant to provide for the
  "method which accepts connection or engine" theme.  As this
  pattern  is greatly reduced in 2.0 and Engine no longer extends
  from it, the ``Connectable`` superclass doesnt serve any real
  purpose.

Leading from that, to set this in I also applied pep 484 annotations
to the Dialect base, and then in the interests of seeing some
of the typing information show up in my IDE did a little bit for Engine,
Connection and others.  I hope that it's feasible that we can
add annotations to specific classes and attributes ahead of when we
actually try to mass-populate the whole library.  This was
the original spirit of pep-484 that we can apply annotations
gradually.  I do of course want to try to do a mass-populate
although i think even in that case we will end up doing a lot
of manual work anyway (in particular for the changes here which
are distinct from what the stubs have).

Fixes: #7122
Change-Id: I5dd7fbff8a7ae520a81c165091af12a6a68826db
Clean up most py3k compat 2021-11-25T03:51:27+00:00 Federico Caselli cfederico87@gmail.com 2021-11-21T20:17:27+00:00 31acba8ff7c123a20ae308b7f4ab6df3df264b48 Change-Id: I8172fdcc3103ff92aa049827728484c8779af6b7 
Change-Id: I8172fdcc3103ff92aa049827728484c8779af6b7
Remove object in class definition 2021-11-22T15:03:17+00:00 Federico Caselli cfederico87@gmail.com 2021-11-21T19:36:35+00:00 0b95f0055be252b13e99b0a944466f60b5e367ff References: #4600 Change-Id: I2a62ddfe00bc562720f0eae700a497495d7a987a 
References: #4600
Change-Id: I2a62ddfe00bc562720f0eae700a497495d7a987a
use tuple expansion if type._is_tuple, test for Sequence if no type 2021-11-05T15:55:14+00:00 Mike Bayer mike_mp@zzzcomputing.com 2021-11-05T14:18:42+00:00 0c44a1e77cfde0f841a4a64140314c6b833efdab Fixed regression where the row objects returned for ORM queries, which are now the normal :class:`_sql.Row` objects, would not be interpreted by the :meth:`_sql.ColumnOperators.in_` operator as tuple values to be broken out into individual bound parameters, and would instead pass them as single values to the driver leading to failures. The change to the "expanding IN" system now accommodates for the expression already being of type :class:`.TupleType` and treats values accordingly if so. In the uncommon case of using "tuple-in" with an untyped statement such as a textual statement with no typing information, a tuple value is detected for values that implement ``collections.abc.Sequence``, but that are not ``str`` or ``bytes``, as always when testing for ``Sequence``. Added :class:`.TupleType` to the top level ``sqlalchemy`` import namespace. Fixes: #7292 Change-Id: I8286387e3b3c3752b3bd4ae3560d4f31172acc22 
Fixed regression where the row objects returned for ORM queries, which are
now the normal :class:`_sql.Row` objects, would not be interpreted by the
:meth:`_sql.ColumnOperators.in_` operator as tuple values to be broken out
into individual bound parameters, and would instead pass them as single
values to the driver leading to failures. The change to the "expanding IN"
system now accommodates for the expression already being of type
:class:`.TupleType` and treats values accordingly if so. In the uncommon
case of using "tuple-in" with an untyped statement such as a textual
statement with no typing information, a tuple value is detected for values
that implement ``collections.abc.Sequence``, but that are not ``str`` or
``bytes``, as always when testing for ``Sequence``.

Added :class:`.TupleType` to the top level ``sqlalchemy`` import namespace.

Fixes: #7292
Change-Id: I8286387e3b3c3752b3bd4ae3560d4f31172acc22
First round of removal of python 2 2021-11-01T19:11:25+00:00 Federico Caselli cfederico87@gmail.com 2021-10-30T20:00:25+00:00 36e7aebd8d6faac77570403e99f9aa7b2330fa59 References: #4600 Change-Id: I61e35bc93fe95610ae75b31c18a3282558cd4ffe 
References: #4600
Change-Id: I61e35bc93fe95610ae75b31c18a3282558cd4ffe
warnings removal, merge_result 2021-10-30T01:11:37+00:00 Mike Bayer mike_mp@zzzcomputing.com 2021-10-29T21:36:26+00:00 a291457664d3b4ef7e0b4a29110749674ec0da75 this is the last warning to remove. Also fixes some mistakes I made with the new Base20DeprecationWarning and LegacyAPIWarning classes created, where functions in deprecations.py were still hardcoded to RemovedIn20Warning. Change-Id: I9a6045ac9b813fd2f9668c4bc518c46a7774c6ef 
this is the last warning to remove.

Also fixes some mistakes I made with the new
Base20DeprecationWarning and LegacyAPIWarning classes created,
where functions in deprecations.py were still hardcoded to
RemovedIn20Warning.

Change-Id: I9a6045ac9b813fd2f9668c4bc518c46a7774c6ef
deprecation warnings: with_parent, aliased, from_joinpoint 2021-10-27T15:41:00+00:00 Mike Bayer mike_mp@zzzcomputing.com 2021-10-26T19:37:16+00:00 0f98ead274df103a5a623baa3898580932e1c8e2 most of the work for aliased / from_joinpoint has been done already as I added all new tests for these and moved most aliased/from_joinpoint to test/orm/test_deprecations.py already Change-Id: Ia23e332dec183de17b2fb9d89d946af8d5e89ae7 
most of the work for aliased / from_joinpoint has been done
already as I added all new tests for these and moved
most aliased/from_joinpoint to test/orm/test_deprecations.py
already

Change-Id: Ia23e332dec183de17b2fb9d89d946af8d5e89ae7
vendor asynccontextmanager outside of greenlet dependency 2021-10-18T18:31:40+00:00 Mike Bayer mike_mp@zzzcomputing.com 2021-10-18T18:31:40+00:00 aaf4643bc2734442f053216874a6b9d299a8d89e Fixed installation issue where the ``sqlalchemy.dialects.mysql`` module would not be importable if "greenlet" were not installed. This was actually breaking the sphinx build for when greenlet were not installed. Fixes: #7204 Change-Id: Ia351c124a2f1ca44bafe20a97267ce20cb55808f 
Fixed installation issue where the ``sqlalchemy.dialects.mysql`` module
would not be importable if "greenlet" were not installed.

This was actually breaking the sphinx build for when greenlet
were not installed.

Fixes: #7204
Change-Id: Ia351c124a2f1ca44bafe20a97267ce20cb55808f