delta/python-packages/sqlalchemy.git/examples, branch workflow_test_aiosqlite github.com: zzzeek/sqlalchemy.git add asyncio.gather() example; add connection opts 2021-09-02T14:19:20+00:00 Mike Bayer mike_mp@zzzcomputing.com 2021-09-01T12:58:06+00:00 d640192877e4d1da75e8dea34d2374c404e80538 while I dont like this approach very much, people will likely be asking for it a lot, so represent the most correct and efficient form we can handle right now. Added missing ``**kw`` arguments to the :meth:`_asyncio.AsyncSession.connection` method. Change-Id: Idadae2a02a4d96ecb96a5723ce64d017ab4c6217 References: https://github.com/sqlalchemy/sqlalchemy/discussions/6965 
while I dont like this approach very much, people will likely
be asking for it a lot, so represent the most correct and
efficient form we can handle right now.

Added missing ``**kw`` arguments to the
:meth:`_asyncio.AsyncSession.connection` method.

Change-Id: Idadae2a02a4d96ecb96a5723ce64d017ab4c6217
References: https://github.com/sqlalchemy/sqlalchemy/discussions/6965
accommodate for untracked boundparam lambda in offline_string 2021-08-05T23:19:02+00:00 Mike Bayer mike_mp@zzzcomputing.com 2021-08-05T23:17:07+00:00 3729a070d23421c94239bd24520592287476fdde Fixed an issue in the ``CacheKey.to_offline_string()`` method used by the dogpile.caching example where attempting to create a proper cache key from the special "lambda" query generated by the lazy loader would fail to include the parameter values, leading to an incorrect cache key. Fixes: #6858 Change-Id: Ice27087583c6f3ff79cf7d5b879e5dd0a4e58158 
Fixed an issue in the ``CacheKey.to_offline_string()`` method used by the
dogpile.caching example where attempting to create a proper cache key from
the special "lambda" query generated by the lazy loader would fail to
include the parameter values, leading to an incorrect cache key.

Fixes: #6858
Change-Id: Ice27087583c6f3ff79cf7d5b879e5dd0a4e58158
update local_session_caching.py example for 1.4 2021-08-05T17:54:06+00:00 Mike Bayer mike_mp@zzzcomputing.com 2021-08-05T17:54:06+00:00 b75630cec9418ef087e7c6af0370ac6ba728a251 Fixes: #6858 Change-Id: I9b4113243f9ef32f27dcd1f7e9751923283eba2d 
Fixes: #6858
Change-Id: I9b4113243f9ef32f27dcd1f7e9751923283eba2d
update case statement in dictlike-polymorphic 2021-07-15T02:59:16+00:00 Mike Bayer mike_mp@zzzcomputing.com 2021-07-15T02:58:07+00:00 daaf36840bb3ebbaea3722413998604ed21d36a8 this was using a long-ago not working form of case(). Change-Id: I39c7cec2e46dd215d7acb7d3ee6debd30fa1ec34 
this was using a long-ago not working form of case().

Change-Id: I39c7cec2e46dd215d7acb7d3ee6debd30fa1ec34
Replace all http:// links to https:// 2021-07-04T18:54:33+00:00 Federico Caselli cfederico87@gmail.com 2021-07-04T17:29:19+00:00 fb81f9c8d914f9911925dd3f4e77d7fc374b267c Also replace http://pypi.python.org/pypi with https://pypi.org/project Change-Id: I84b5005c39969a82140706472989f2a30b0c7685 
Also replace http://pypi.python.org/pypi with https://pypi.org/project

Change-Id: I84b5005c39969a82140706472989f2a30b0c7685
Update black flak8 and zimports 2021-05-12T20:10:19+00:00 Federico Caselli cfederico87@gmail.com 2021-05-12T20:01:45+00:00 debeea97eeae4b4a39a2d50f2a2d96c366421a30 Change-Id: I488c9557eda390e4a88319affd4c8813ee274f80 
Change-Id: I488c9557eda390e4a88319affd4c8813ee274f80
Document implicit IO points in ORM 2021-02-07T14:51:48+00:00 Mike Bayer mike_mp@zzzcomputing.com 2021-02-07T14:51:48+00:00 10f05288dca4fdbaa4670dd7ef856e441bdb4adc I purposely didn't spend much documentation writing about implicit IO when I first pushed out the asyncio extension because I wanted to get a sense on what kinds of issues people had. Now we know and the answer is predictably "all of them". List out all the known implicit IO points and how to avoid them. Also rename the "adapting lazy loads" section, so that the title is less suggestive that this is a necessary technique. References: #5926 Change-Id: I3933b74bd37a5b06989531adbeade34347db679b 
I purposely didn't spend much documentation writing
about implicit IO when I first pushed out the asyncio
extension because I wanted to get a sense on what kinds
of issues people had.   Now we know and the answer is
predictably "all of them".  List out all the known
implicit IO points and how to avoid them.  Also rename
the "adapting lazy loads" section, so that the title is less
suggestive that this is a necessary technique.

References: #5926

Change-Id: I3933b74bd37a5b06989531adbeade34347db679b
Revise attribute refresh for with_loader_criteria, related 2020-12-11T16:46:48+00:00 Mike Bayer mike_mp@zzzcomputing.com 2020-12-11T15:34:44+00:00 c46279d1c215b7af956e40cb29afafba29d9143f Added new attribute :attr:`_orm.ORMExecuteState.is_column_load` to indicate that a :meth:`_orm.SessionEvents.do_orm_execute` handler that a particular operation is a primary-key-directed column attribute load, such as from an expiration or a deferred attribute, and that WHERE criteria or additional loader options should not be added to the query. This has been added to the examples which illustrate the :func:`_orm.with_loader_criteria` option. The :func:`_orm.with_loader_criteria` option has been modified so that it will never apply its criteria to the SELECT statement for an ORM refresh operation, such as that invoked by :meth:`_orm.Session.refresh` or whenever an expired attribute is loaded. These queries are only against the primary key row of the object that is already present in memory so there should not be additional criteria added. Added doc caveats for using lambdas. Added test coverage for most ORMExecuteState flags and fixed a few basic access issues. Change-Id: I6707e4cf0dc95cdfb8ce93e5ca22ead86074baa7 References: #5760 Fixes: #5761 Fixes: #5762 
Added new attribute :attr:`_orm.ORMExecuteState.is_column_load` to indicate
that a :meth:`_orm.SessionEvents.do_orm_execute` handler that a particular
operation is a primary-key-directed column attribute load, such as from an
expiration or a deferred attribute, and that WHERE criteria or additional
loader options should not be added to the query.   This has been added to
the examples which illustrate the :func:`_orm.with_loader_criteria` option.

The :func:`_orm.with_loader_criteria` option has been modified so that it
will never apply its criteria to the SELECT statement for an ORM refresh
operation, such as that invoked by :meth:`_orm.Session.refresh` or whenever
an expired attribute is loaded.   These queries are only against the
primary key row of the object that is already present in memory so there
should not be additional criteria added.

Added doc caveats for using lambdas.

Added test coverage for most ORMExecuteState flags and fixed a few
basic access issues.

Change-Id: I6707e4cf0dc95cdfb8ce93e5ca22ead86074baa7
References: #5760
Fixes: #5761
Fixes: #5762
Deprecate duplicated column names in Table definition 2020-10-12T17:52:06+00:00 Mike Bayer mike_mp@zzzcomputing.com 2020-09-03T18:14:39+00:00 9e82f32f274e649b04740c819d21ba232c89cfff The :class:`_schema.Table` class now raises a deprecation warning when columns with the same name are defined. To replace a column a new parameter :paramref:`_schema.Table.append_column.replace_existing` was added to the :meth:`_schema.Table.append_column` method. The :meth:`_expression.ColumnCollection.contains_column` will now raises an error when called with a string, suggesting the caller to use ``in`` instead. Co-authored-by: Federico Caselli <cfederico87@gmail.com> Change-Id: I1d58c8ebe081079cb669e7ead60886ffc1b1a7f5 
The :class:`_schema.Table` class now raises a deprecation warning
when columns with the same name are defined. To replace a column a new
parameter :paramref:`_schema.Table.append_column.replace_existing` was
added to the :meth:`_schema.Table.append_column` method.

The :meth:`_expression.ColumnCollection.contains_column` will now
raises an error when called with a string, suggesting the caller
to use ``in`` instead.

Co-authored-by: Federico Caselli <cfederico87@gmail.com>
Change-Id: I1d58c8ebe081079cb669e7ead60886ffc1b1a7f5
upgrade to black 20.8b1 2020-09-28T19:17:26+00:00 Mike Bayer mike_mp@zzzcomputing.com 2020-09-28T18:08:59+00:00 c3f102c9fe9811fd5286628cc6aafa5fbc324621 It's better, the majority of these changes look more readable to me. also found some docstrings that had formatting / quoting issues. Change-Id: I582a45fde3a5648b2f36bab96bad56881321899b 
It's better, the majority of these changes look more readable to me.
also found some docstrings that had formatting / quoting issues.

Change-Id: I582a45fde3a5648b2f36bab96bad56881321899b