delta/python-packages/sqlalchemy.git/test/aaa_profiling, branch workflow_test_cython

Replace c extension with cython versions.

2021-12-17T20:29:05+00:00

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

Removals: strings for join(), loader_options().

2021-12-09T00:32:44+00:00

* The :meth:`_orm.Query.join` method no longer accepts strings for
relationship names; the long-documented approach of using
``Class.attrname`` for join targets is now standard.

* Loader options no longer accept strings for attribute names.  The
long-documented approach of using ``Class.attrname`` for loader option
targets is now standard.

It is hoped that a subsequent commit can refactor loader
options to no longer need "UnboundLoad" for most cases.

Change-Id: If4629882c40523dccbf4459256bf540fb468b618
References: #6986

Clean up most py3k compat

2021-11-25T03:51:27+00:00

Change-Id: I8172fdcc3103ff92aa049827728484c8779af6b7

Remove object in class definition

2021-11-22T15:03:17+00:00

References: #4600
Change-Id: I2a62ddfe00bc562720f0eae700a497495d7a987a

removals: all unicode encoding / decoding

2021-11-10T16:24:53+00:00

Removed here includes:

* convert_unicode parameters
* encoding create_engine() parameter
* description encoding support
* "non-unicode fallback" modes under Python 2
* String symbols regarding Python 2 non-unicode fallbacks
* any concept of DBAPIs that don't accept unicode
  statements, unicode bound parameters, or that return bytes
  for strings anywhere except an explicit Binary / BLOB
  type
* unicode processors in Python / C

Risk factors:

* Whether all DBAPIs do in fact return Unicode objects for
  all entries in cursor.description now
* There was logic for mysql-connector trying to determine
  description encoding.   A quick test shows Unicode coming
  back but it's not clear if there are still edge cases where
  they return bytes.  if so, these are bugs in that driver,
  and at most we would only work around it in the mysql-connector
  DBAPI itself (but we won't do that either).
* It seems like Oracle 8 was not expecting unicode bound parameters.
  I'm assuming this was all Python 2 stuff and does not apply
  for modern cx_Oracle under Python 3.
* third party dialects relying upon built in unicode encoding/decoding
  but it's hard to imagine any non-SQLAlchemy database driver not
  dealing exclusively in Python unicode strings in Python 3

Change-Id: I97d762ef6d4dd836487b714d57d8136d0310f28a
References: #7257

fully implement future engine and remove legacy

2021-11-07T19:30:35+00:00

The major action here is to lift and move future.Connection
and future.Engine fully into sqlalchemy.engine.base.   This
removes lots of engine concepts, including:

* autocommit
* Connection running without a transaction, autobegin
  is now present in all cases
* most "autorollback" is obsolete
* Core-level subtransactions (i.e. MarkerTransaction)
* "branched" connections, copies of connections
* execution_options() returns self, not a new connection
* old argument formats, distill_params(), simplifies calling
  scheme between engine methods
* before/after_execute() events (oriented towards compiled constructs)
  don't emit for exec_driver_sql().  before/after_cursor_execute()
  is still included for this
* old helper methods superseded by context managers, connection.transaction(),
  engine.transaction() engine.run_callable()
* ancient engine-level reflection methods has_table(), table_names()
* sqlalchemy.testing.engines.proxying_engine

References: #7257

Change-Id: Ib20ed816642d873b84221378a9ec34480e01e82c

First round of removal of python 2

2021-11-01T19:11:25+00:00

References: #4600
Change-Id: I61e35bc93fe95610ae75b31c18a3282558cd4ffe

2.0 removals: LegacyRow, connectionless execution, close_with_result

2021-10-31T19:37:08+00:00

in order to remove LegacyRow / LegacyResult, we have
to also lose close_with_result, which connectionless
execution relies upon.

also includes a new profiles.txt file that's all against
py310, as that's what CI is on now.  some result counts
changed by one function call which was enough to fail the
low-count result tests.

Replaces Connectable as the common interface between
Connection and Engine with EngineEventsTarget.  Engine
is no longer Connectable.  Connection and MockConnection
still are.

References: #7257
Change-Id: Iad5eba0313836d347e65490349a22b061356896a

warnings: session.autocommit, subtransactions

2021-10-29T21:14:57+00:00

Change-Id: I7eb7c87c9656f8043ea90d53897958afad2b8fe9

Modernize tests - session_query_get

2021-10-29T00:31:09+00:00

Co-authored-by: Mike Bayer 
Change-Id: I92013aad471baf32df1b51b756e86d95449b5cfd