delta/python-packages/sqlalchemy.git/test, branch pr/284

Ensure CTE internals are handled during clone

2016-06-10T21:24:36+00:00

The CTE construct was missing a _copy_internals() method
which would handle CTE-specific structures including _cte_alias,
_restates during a clone operation.

Change-Id: I9aeac9cd24d8f7ae6b70e52650d61f7c96cb6d7e
Fixes: #3722

Support `postgresql_concurrently` on index dropping.

2016-06-08T18:41:05+00:00

Also adds version detection so that DROP INDEX CONCURRENTLY
only renders if the Postgresql version is 9.2 or higher;
for CREATE INDEX CONCURRENTLY, version detection is added
to allow the phrase to omit if the Postgresql version is
less than 8.2.

Co-authored-by: Mike Bayer 
Change-Id: I597287e0ebbbe256c957a3579b58ace6848ab4f4
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/84

Merge "Support normal /materialized views in PG separately"

2016-06-08T17:21:12+00:00

Use the "committed" values when extracting many-to-one lazyload value

2016-06-08T16:57:21+00:00

The scalar object set() method calls upon the lazy loader
to get at the "old" value of the attriute, however doesn't
ensure that the "committed" value of the foreign key attributes
is used.  If the user has manipulated these attributes and they
themselves have pending, non committed changes, we get the
"new" value which these attributes would have set up if they
were flushed.  "old" vs "new" value is always about how the
value has changed since the load, so we always have to use the
DB-persisted values for everything when looking for "old".

Change-Id: I82bdc40ad0cf033c3a98f3361776cf3161542cd6
Fixes: #3708

Merge "Add 'FOR NO KEY UPDATE' / 'FOR KEY SHARE' support for Postgresql"

2016-06-08T15:52:22+00:00

Add 'FOR NO KEY UPDATE' / 'FOR KEY SHARE' support for Postgresql

2016-06-08T15:24:57+00:00

Adds ``key_share=True`` for with_for_update().

Co-authored-by: Mike Bayer 
Change-Id: I74e0c3fcbc023e1dc98a1fa0c7db67b4c3693a31
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/279

Support range specification in window function

2016-06-07T19:17:22+00:00

Fixes: #3049
Co-authored-by: Mike Bayer 
Change-Id: Ie572095c3e25f70a1e72e1af6858e5edd89fd25e
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/264

Support normal /materialized views in PG separately

2016-06-06T22:57:10+00:00

Fixes: #3588
Change-Id: Ifbfcab67375f289ddb5c4522f4b803cb8b7c34de
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/250

Add "render_nulls" flag to bulk_insert as optional performance optimization

2016-06-06T20:22:11+00:00

Currently, ``Session.bulk_insert_mappings`` omits NULL values which
causes it to break up batches of inserts based on which batches
contain NULL and which do not.

By adding this flag, the same columns are rendered in the INSERT
for all rows allowing them to be batched.  The downside is that
server-side defaults are omitted.

Doctext-author: Mike Bayer 
Change-Id: Iec5969304d4bdbf57290b200331bde02254aa3a5
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/243

Add IS (NOT) DISTINCT FROM operators

2016-06-06T19:53:25+00:00

None / True / False render as literals.
For SQLite, "IS" is used as SQLite lacks
"IS DISTINCT FROM" but its "IS" operator acts
this way for NULL.

Doctext-author: Mike Bayer 
Change-Id: I9227b81f7207b42627a0349d14d40b46aa756cce
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/248