delta/python-packages/sqlalchemy.git/lib/sqlalchemy/sql/compiler.py, branch pr/317 github.com: zzzeek/sqlalchemy.git Propagate execution_options at compile stage 2016-10-05T20:47:31+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-10-05T17:59:58+00:00 71030d67bd7c7948ef4a4d868821703ef5a57476 Compiler can now set up execution options and additionally will propagate autocommit from embedded CTEs. Change-Id: I19db7b8fe4d84549ea95342e8d2040189fed1bbe Fixes: #3805 
Compiler can now set up execution options and additionally
will propagate autocommit from embedded CTEs.

Change-Id: I19db7b8fe4d84549ea95342e8d2040189fed1bbe
Fixes: #3805
Add "eager_parenthesis" late-compilation rule, use w/ PG JSON/HSTORE 2016-10-01T13:46:11+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-09-30T14:09:56+00:00 333414fe94941a6a58e7d8e45042548eb2d58119 Added compiler-level flags used by Postgresql to place additional parenthesis than would normally be generated by precedence rules around operations involving JSON, HSTORE indexing operators as well as within their operands since it has been observed that Postgresql's precedence rules for at least the HSTORE indexing operator is not consistent between 9.4 and 9.5. Fixes: #3806 Change-Id: I5899677b330595264543b055abd54f3c76bfabf2 
Added compiler-level flags used by Postgresql to place additional
parenthesis than would normally be generated by precedence rules
around operations involving JSON, HSTORE indexing operators as well as
within their operands since it has been observed that Postgresql's
precedence rules for at least the HSTORE indexing operator is not
consistent between 9.4 and 9.5.

Fixes: #3806
Change-Id: I5899677b330595264543b055abd54f3c76bfabf2
Escape literal string values passed to server_default 2016-09-30T13:23:50+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-09-30T13:23:50+00:00 079df65dc0f71ea4d1771b6ae17e13242c766517 A string sent as a column default via the :paramref:`.Column.server_default` parameter is now escaped for quotes. This change is backwards compatible with code that may have been working around this previously. Change-Id: I341298a76cc67bc0a53df4ab51ab9379f2294cdd Fixes: #3809 
A string sent as a column default via the
:paramref:`.Column.server_default` parameter is now escaped for quotes.

This change is backwards compatible with code that may have been
working around this previously.

Change-Id: I341298a76cc67bc0a53df4ab51ab9379f2294cdd
Fixes: #3809
Allow stringify compiler to render unnamed column 2016-09-02T15:48:15+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-09-02T15:48:15+00:00 9a6947427af58eeb6ebf09ec6de2a1b7ec12d828 Stringify of expression with unnamed :class:`.Column` objects, as occurs in lots of situations including ORM error reporting, will now render the name in string context as "<name unknown>" rather than raising a compile error. Change-Id: I76f637c5eb4cfdb1b526964cb001565b97e296da Fixes: #3789 
Stringify of expression with unnamed :class:`.Column` objects, as
occurs in lots of situations including ORM error reporting,
will now render the name in string context as "<name unknown>"
rather than raising a compile error.

Change-Id: I76f637c5eb4cfdb1b526964cb001565b97e296da
Fixes: #3789
Check for supports_execution at ClauseElement base 2016-08-31T21:04:35+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-08-31T18:34:54+00:00 c7b9c84312b6b252e68ea704670d0ea7fc0042f0 Raise a more descriptive exception / message when ClauseElement or non-SQLAlchemy objects that are not "executable" are erroneously passed to ``.execute()``; a new exception ObjectNotExecutableError is raised consistently in all cases. Change-Id: I2dd393121e2c7e5b6b9e40286a2f25670876e8e4 Fixes: #3786 
Raise a more descriptive exception / message when ClauseElement
or non-SQLAlchemy objects that are not "executable" are erroneously
passed to ``.execute()``; a new exception ObjectNotExecutableError
is raised consistently in all cases.

Change-Id: I2dd393121e2c7e5b6b9e40286a2f25670876e8e4
Fixes: #3786
Work w/ prefetch even for selects, if present 2016-07-12T20:43:49+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-07-12T20:38:22+00:00 e486ef666f39f136c770c68db28f475d68e0173f Fixed bug in new CTE feature for update/insert/delete stated as a CTE inside of an enclosing statement (typically SELECT) whereby oninsert and onupdate values weren't called upon for the embedded statement. This is accomplished by consulting prefetch for all statements. The collection is also broken into separate insert/update collections so that we don't need to consult toplevel self.isinsert to determine if the prefetch is for an insert or an update. What we don't yet test for are CTE combinations that have both insert/update in one statement, though these should now work in theory provided the underlying database supports such a statement. Change-Id: I3b6a860e22c86743c91c56a7ec751ff706f66f64 Fixes: #3745 
Fixed bug in new CTE feature for update/insert/delete stated
as a CTE inside of an enclosing statement (typically SELECT) whereby
oninsert and onupdate values weren't called upon for the embedded
statement.

This is accomplished by consulting prefetch
for all statements.  The collection is also broken into
separate insert/update collections so that we don't need to
consult toplevel self.isinsert to determine if the prefetch
is for an insert or an update.  What we don't yet test for
are CTE combinations that have both insert/update in one
statement, though these should now work in theory provided
the underlying database supports such a statement.

Change-Id: I3b6a860e22c86743c91c56a7ec751ff706f66f64
Fixes: #3745
Don't reorder PrimaryKeyConstraint columns if explicit 2016-06-20T16:52:31+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-06-20T15:39:01+00:00 bf03d4332ae35e2087b175f8a2e0291d2f4c9aa0 Dialed back the "order the primary key columns per auto-increment" described in :ref:`change_mysql_3216` a bit, so that if the :class:`.PrimaryKeyConstraint` is explicitly defined, the order of columns is maintained exactly, allowing control of this behavior when necessary. Change-Id: I9e7902c57a96c15968a6abf53e319acf15680da0 Fixes: #3726 
Dialed back the "order the primary key columns per auto-increment"
described in :ref:`change_mysql_3216` a bit, so that if the
:class:`.PrimaryKeyConstraint` is explicitly defined, the order
of columns is maintained exactly, allowing control of this behavior
when necessary.

Change-Id: I9e7902c57a96c15968a6abf53e319acf15680da0
Fixes: #3726
Add DDLCompiler.create_table_suffix() 2016-06-16T15:43:02+00:00 Mark Sandan msandan@utexas.edu 2016-05-24T00:08:36+00:00 d7b8b475f8a5c0ddf955157f89db3d44d0dc0d9a Allows custom dialects to add keywords after the CREATE TABLE section. Change-Id: I6fa66dfcf00ef95122f491a9115410df2746cf88 
Allows custom dialects to add keywords after the
CREATE TABLE section.

Change-Id: I6fa66dfcf00ef95122f491a9115410df2746cf88
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
Add ON CONFLICT support for Postgresql 2016-06-14T19:03:14+00:00 Robin Thomas robin.thomas@livestream.com 2016-04-14T16:57:15+00:00 4e9ab7a72f0ad506cf519069fd67127f63e5f2aa Fixes: #3529 Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com> Change-Id: Ie3bf6ad70d9be9f0e44938830e922db03573991a Pull-request: https://github.com/zzzeek/sqlalchemy/pull/258 
Fixes: #3529
Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
Change-Id: Ie3bf6ad70d9be9f0e44938830e922db03573991a
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/258