diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2014-09-09 18:59:59 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2014-09-09 18:59:59 -0400 |
| commit | 706d4fcc4f69b74a502be41f5eea3fedd9413bc7 (patch) | |
| tree | 882b0ceb180ab425fc40b4c58fdecf04296c136d | |
| parent | 48080d88bee0afcf8f1e0e1c89e077abc64c55ad (diff) | |
| download | sqlalchemy-706d4fcc4f69b74a502be41f5eea3fedd9413bc7.tar.gz | |
- for whatever reason, Insert.values() with multi values wasn't
in the 0.8 migration, so let's just add that
| -rw-r--r-- | doc/build/changelog/changelog_08.rst | 4 | ||||
| -rw-r--r-- | doc/build/changelog/migration_08.rst | 24 |
2 files changed, 28 insertions, 0 deletions
diff --git a/doc/build/changelog/changelog_08.rst b/doc/build/changelog/changelog_08.rst index 002eaf704..6515f731d 100644 --- a/doc/build/changelog/changelog_08.rst +++ b/doc/build/changelog/changelog_08.rst @@ -2156,6 +2156,10 @@ Supported by Postgresql, SQLite, and MySQL. Big thanks to Idan Kamara for doing the legwork on this one. + .. seealso:: + + :ref:`feature_2623` + .. change:: :tags: oracle, bug :tickets: 2620 diff --git a/doc/build/changelog/migration_08.rst b/doc/build/changelog/migration_08.rst index 717a24c73..fd153a925 100644 --- a/doc/build/changelog/migration_08.rst +++ b/doc/build/changelog/migration_08.rst @@ -683,6 +683,30 @@ as more string, integer and date operators. :ticket:`2547` +.. _feature_2623: + +Multiple-VALUES support for Insert +----------------------------------- + +The :meth:`.Insert.values` method now supports a list of dictionaries, +which will render a multi-VALUES statement such as +``VALUES (<row1>), (<row2>), ...``. This is only relevant to backends which +support this syntax, including Postgresql, SQLite, and MySQL. It is +not the same thing as the usual ``executemany()`` style of INSERT which +remains unchanged:: + + users.insert().values([ + {"name": "some name"}, + {"name": "some other name"}, + {"name": "yet another name"}, + ]) + +.. seealso:: + + :meth:`.Insert.values` + +:ticket:`2623` + Type Expressions ----------------- |