delta/python-packages/sqlalchemy.git/examples, branch rel_1_@

Add Query.lazy_load_from attribute for sharding

2018-06-04T16:30:05+00:00

Added new attribute :attr:`.Query.lazy_loaded_from` which is populated
with an :class:`.InstanceState` that is using this :class:`.Query` in
order to lazy load a relationship.  The rationale for this is that
it serves as a hint for the horizontal sharding feature to use, such that
the identity token of the state can be used as the default identity token
to use for the query within id_chooser().

Also repaired an issue in the :meth:`.Result.with_post_criteria`
method added in I899808734458e25a023142c2c5bb37cbed869479
for :ticket:`4128` where the "unbake subquery loaders" version was calling
the post crtieria functions given the :class:`.Result` as the argument
rather than applying them to the :class:`.Query`.

Change-Id: I3c0919ce7fd151b80fe2f9b5f99f60df31c2d73d
Fixes: #4243

Update dogpile.cache example to be compatible with baked query.

2018-05-17T16:43:44+00:00

Updated the dogpile.caching example to include new structures that
accommodate for the "baked" query system, which is used by default within
lazy loaders and some eager relationship loaders. The dogpile.caching
"relationship_caching" and "advanced" examples were also broken due to
:ticket:`4256`.  The issue here is also worked-around by the fix in
:ticket:`4128`.

Note that this recipe requires
I3f86fcb12a6a9a89aa308b335e75c25969bcc30e in order for the
"advanced" example to work.

Change-Id: I9d35417f1d6c1906555583b8225d3da7f81736f7
Fixes: #4258

- modernize versioning examples

2018-05-05T22:21:08+00:00

- add new example versioned_rows_w_versionid

Change-Id: I592cd5eb7db50162b4c4ad6191813d9def2b6d7c

- add space invaders example

2018-04-27T19:05:56+00:00

Change-Id: I439b6012af8c2bd8f555744657b8091ac168242b

Add an identity_token to the identity key

2017-12-22T16:36:53+00:00

For the purposes of assisting with sharded setups, add a new
member to the identity key that can be customized.  this allows
sharding across databases where the primary key space is shared.

Change-Id: Iae3909f5d4c501b62c10d0371fbceb01abda51db
Fixes: #4137

modernize and repair inheritance examples

2017-05-16T13:51:06+00:00

remarkably, the examples for concrete and single were still
using classical mappings.    Ensure all three examples use
modern declarative patterns, each illustrate the identical set
of query operations.  Use back_populates, flat=True for joins,
etc. ensure flake8 linting, correct links and add a link back
from newly reworked inheritance documentation.

Change-Id: I8465a9badbb0eda804f457ccac599f051ee3c27c

fix pep8 errors in association example

2017-03-18T18:42:48+00:00

(cherry picked from commit 6aad7fb4217ef294f68f693be5b3137c28184949)

fix pep8 errors in adjacency_list example

2017-03-18T18:42:43+00:00

(cherry picked from commit ff230f1862892eb2b479ed85e6858a82159b435f)

Set autoincrement to False; use sqlite_autoincrement in versioned_history

2017-01-09T23:00:33+00:00

Ensure that the history table sets autoincrement=False, since these values
are copied in all cases; the flag will emit an error as of 1.1 if the
primary key is composite.   Additionally, use the sqlite_autoincrement flag
so that SQLite uses unique primary key identifiers for new rows even if
some rows have been deleted.

Fixes: #3872
Change-Id: I65912eb394b3b69d7f4e3c098f4f948b0a7a5374
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/93

spelling: Postgis -> PostGIS

2016-10-08T17:42:50+00:00