<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/sqlalchemy.git/test/sql/test_insert.py, branch pr/99</title>
<subtitle>github.com: zzzeek/sqlalchemy.git
</subtitle>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/'/>
<entry>
<title>- Fixed bug in INSERT..FROM SELECT construct where selecting from a</title>
<updated>2014-05-25T18:08:41+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-05-25T18:08:41+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=482a67e1c68d3123ab91f8141ae58c7daa88e6db'/>
<id>482a67e1c68d3123ab91f8141ae58c7daa88e6db</id>
<content type='text'>
UNION would wrap the union in an anonymous (e.g. unlabled) subquery.
fixes #3044
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
UNION would wrap the union in an anonymous (e.g. unlabled) subquery.
fixes #3044
</pre>
</div>
</content>
</entry>
<entry>
<title>- Fixed bug where calling :meth:`.Insert.values` with an empty list</title>
<updated>2014-02-19T20:18:22+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2014-02-19T20:18:22+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=77ed03652580c5db925729c573b76ca32393dc67'/>
<id>77ed03652580c5db925729c573b76ca32393dc67</id>
<content type='text'>
or tuple would raise an IndexError.   It now produces an empty
insert construct as would be the case with an empty dictionary.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
or tuple would raise an IndexError.   It now produces an empty
insert construct as would be the case with an empty dictionary.
</pre>
</div>
</content>
</entry>
<entry>
<title>- Fixed bug with :meth:`.Insert.from_select` method where the order</title>
<updated>2013-12-19T21:02:14+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-12-19T21:02:14+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=5f76f29c15b7a23cfe29c5fbd22ad02452b6a2c0'/>
<id>5f76f29c15b7a23cfe29c5fbd22ad02452b6a2c0</id>
<content type='text'>
of the given names would not be taken into account when generating
the INSERT statement, thus producing a mismatch versus the column
names in the given SELECT statement.  Also noted that
:meth:`.Insert.from_select` implies that Python-side insert defaults
cannot be used, since the statement has no VALUES clause. [ticket:2895]
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
of the given names would not be taken into account when generating
the INSERT statement, thus producing a mismatch versus the column
names in the given SELECT statement.  Also noted that
:meth:`.Insert.from_select` implies that Python-side insert defaults
cannot be used, since the statement has no VALUES clause. [ticket:2895]
</pre>
</div>
</content>
</entry>
<entry>
<title>- Added new method to the :func:`.insert` construct</title>
<updated>2013-07-05T19:51:24+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-07-05T19:51:24+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=cec89cae156903c9a77dff29a1213e70fa915b52'/>
<id>cec89cae156903c9a77dff29a1213e70fa915b52</id>
<content type='text'>
: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.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
: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.
</pre>
</div>
</content>
</entry>
<entry>
<title>- reinstate insert returning back into test_insert.py; defaultdialect</title>
<updated>2013-04-01T19:41:57+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-04-01T19:41:57+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=6bdd3bb93fd18a4aec54ee2a836875a922dcaab3'/>
<id>6bdd3bb93fd18a4aec54ee2a836875a922dcaab3</id>
<content type='text'>
needs to be explicit here since tablestest sticks testing.db onto metadata.bind
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
needs to be explicit here since tablestest sticks testing.db onto metadata.bind
</pre>
</div>
</content>
</entry>
<entry>
<title>moving insert returning test back into CRUD test class until I figure out why moving it broke the oracle/postgres builds</title>
<updated>2013-03-30T13:30:58+00:00</updated>
<author>
<name>Diana Clarke</name>
<email>diana.joan.clarke@gmail.com</email>
</author>
<published>2013-03-30T13:30:58+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=25c6732019550e6f26ae4da58084b939e04cffa1'/>
<id>25c6732019550e6f26ae4da58084b939e04cffa1</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>fixing tests for --db=mysql: VARCHAR requires a length on dialect mysql</title>
<updated>2013-03-30T05:01:59+00:00</updated>
<author>
<name>Diana Clarke</name>
<email>diana.joan.clarke@gmail.com</email>
</author>
<published>2013-03-30T05:01:59+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=e6d6cfbf6b3921d5addc52dff0a8c1aafffb37d6'/>
<id>e6d6cfbf6b3921d5addc52dff0a8c1aafffb37d6</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>move the insert tests from CRUDTest into sql/test_insert.py (see #2630)</title>
<updated>2013-03-29T23:10:01+00:00</updated>
<author>
<name>Diana Clarke</name>
<email>diana.joan.clarke@gmail.com</email>
</author>
<published>2013-03-29T23:10:01+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=17487a0db7759b0414e73fc3b9e61672e1da7658'/>
<id>17487a0db7759b0414e73fc3b9e61672e1da7658</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
