delta/python-packages/sqlalchemy.git/lib/sqlalchemy/sql/selectable.py, branch pr/307 github.com: zzzeek/sqlalchemy.git Fixed example of upsert in the HasCTE.cte docstring by 2016-08-27T11:21:56+00:00 Vladimir Magamedov vladimir@magamedov.com 2016-08-27T11:17:49+00:00 b42bcb2573980d314ec429f0bde4050706afbb82 replacing it with more concrete and working example. 
replacing it with more concrete and working example.
Merge "Add TABLESAMPLE clause support." 2016-06-15T19:17:10+00:00 mike bayer mike_mp@zzzcomputing.com 2016-06-15T19:17:10+00:00 5c80400ec7c5631d251bac43342637637b9c8214 






Add TABLESAMPLE clause support.
2016-06-15T18:42:08+00:00

saarni
saarni@gmail.com

2016-05-26T14:15:24+00:00

20f2f5b169d35cfee7cc21ff697e23fd00858171

The TABLESAMPLE clause allows randomly selecting an approximate percentage
of rows from a table. At least DB2, Microsoft SQL Server and recent
Postgresql support this standard clause.

Fixes: #3718
Change-Id: I3fb8b9223e12a57100df30876b461884c58d72fa
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/277





The TABLESAMPLE clause allows randomly selecting an approximate percentage
of rows from a table. At least DB2, Microsoft SQL Server and recent
Postgresql support this standard clause.

Fixes: #3718
Change-Id: I3fb8b9223e12a57100df30876b461884c58d72fa
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/277







Interpret lateral, alias as from clauses
2016-06-15T18:36:24+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-06-15T18:36:24+00:00

51e4512abd25340b016279b92ae9ecadb41e237d

Also add doc members for Lateral.

Change-Id: Ic801c296377ce84230139c6a43ecb3e93a852832





Also add doc members for Lateral.

Change-Id: Ic801c296377ce84230139c6a43ecb3e93a852832







Deprecate FromClause.count()
2016-06-14T15:48:04+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-06-13T19:18:13+00:00

f38f890849700ee1bf719a31275260e2da455bc3

count() here is misleading in that it not only
counts from an arbitrary column in the table, it also
does not make accommodations for DISTINCT, JOIN, etc.
as the ORM-level function does.  Core should not be
attempting to provide a function like this.

Change-Id: I9916fc51ef744389a92c54660ab08e9695b8afc2
Fixes: #3724





count() here is misleading in that it not only
counts from an arbitrary column in the table, it also
does not make accommodations for DISTINCT, JOIN, etc.
as the ORM-level function does.  Core should not be
attempting to provide a function like this.

Change-Id: I9916fc51ef744389a92c54660ab08e9695b8afc2
Fixes: #3724







Ensure CTE internals are handled during clone
2016-06-10T21:24:36+00:00

Mike Bayer
mike_mp@zzzcomputing.com

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

7189d0bc82598c2d6dcbb55b054837416db2ee7d

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





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







Add 'FOR NO KEY UPDATE' / 'FOR KEY SHARE' support for Postgresql
2016-06-08T15:24:57+00:00

Sergey Skopin
sa.skopin@gmail.com

2016-05-31T14:02:08+00:00

3ebd1b30eb392ff62f08f0755e79a228d61ba7d2

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

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





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

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







Add SKIP LOCKED support for Postgresql, Oracle
2016-06-02T21:46:16+00:00

Jack Zhou
univerio@gmail.com

2016-05-31T14:01:46+00:00

e8f97c9e357ed0793ce11086823f83aa4a8bb4ad

This adds `SELECT ... FOR UPDATE SKIP LOCKED`/
`SELECT ... FOR SHARE SKIP LOCKED` rendering.

Change-Id: Id1dc4f1cafc1de23f397a6f73d54ab2c58d5910d
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/86





This adds `SELECT ... FOR UPDATE SKIP LOCKED`/
`SELECT ... FOR SHARE SKIP LOCKED` rendering.

Change-Id: Id1dc4f1cafc1de23f397a6f73d54ab2c58d5910d
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/86







- Added :meth:`.Select.lateral` and related constructs to allow
2016-03-29T21:56:02+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-03-29T21:56:02+00:00

fb9d481e898b7695de8f75402970f67776fc47e1

for the SQL standard LATERAL keyword, currently only supported
by Postgresql.  fixes #2857





for the SQL standard LATERAL keyword, currently only supported
by Postgresql.  fixes #2857







- Added support for rendering "FULL OUTER JOIN" to both Core and ORM.
2016-03-28T15:50:09+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-03-28T15:50:09+00:00

d61919118072f4c31ba2ee0bd8c4ac22a92e92f4

Pull request courtesy Stefan Urbanek.  fixes #1957





Pull request courtesy Stefan Urbanek.  fixes #1957