diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2013-07-05 15:51:24 -0400 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2013-07-05 15:51:24 -0400 |
commit | cec89cae156903c9a77dff29a1213e70fa915b52 (patch) | |
tree | 672e7cd1adf0642688251a02f420085cef48ebfe /lib/sqlalchemy/ext/compiler.py | |
parent | 29ce6db26dea9d59df9769be51e84fe5a646c555 (diff) | |
download | sqlalchemy-cec89cae156903c9a77dff29a1213e70fa915b52.tar.gz |
- Added new method to the :func:`.insert` construct
:meth:`.Insert.from_select`. Given a list of columns and
a selectable, renders ``INSERT INTO (table) (columns) SELECT ..``.
While this feature is highlighted as part of 0.9 it is also
backported to 0.8.3. [ticket:722]
- The :func:`.update`, :func:`.insert`, and :func:`.delete` constructs
will now interpret ORM entities as FROM clauses to be operated upon,
in the same way that select() already does. Also in 0.8.3.
Diffstat (limited to 'lib/sqlalchemy/ext/compiler.py')
-rw-r--r-- | lib/sqlalchemy/ext/compiler.py | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/lib/sqlalchemy/ext/compiler.py b/lib/sqlalchemy/ext/compiler.py index 002b2c037..703475de7 100644 --- a/lib/sqlalchemy/ext/compiler.py +++ b/lib/sqlalchemy/ext/compiler.py @@ -96,6 +96,12 @@ Produces:: .. note:: + The above ``InsertFromSelect`` construct is only an example, this actual + functionality is already available using the + :meth:`.Insert.from_select` method. + +.. note:: + The above ``InsertFromSelect`` construct probably wants to have "autocommit" enabled. See :ref:`enabling_compiled_autocommit` for this step. |