← Back to branch summary

~ubuntu-branches/debian/jessie/sqlalchemy/jessie

« back to all changes in this revision

Viewing changes to lib/sqlalchemy/testing/suite/test_insert.py

  • Committer: Package Import Robot
  • Author(s): Piotr Ożarowski
  • Date: 2013-10-28 22:29:40 UTC
  • mfrom: (1.4.24)
  • Revision ID: package-import@ubuntu.com-20131028222940-wvyqffl4g617caun
Tags: 0.8.3-1
New upstream release

Show diffs side-by-side

added added

removed removed

Lines of Context:
lib/sqlalchemy/testing/suite/test_insert.py
121
121
 
122
122
        assert len(r.fetchall())
123
123
 
 
124
    @requirements.insert_from_select
 
125
    def test_insert_from_select(self):
 
126
        table = self.tables.autoinc_pk
 
127
        config.db.execute(
 
128
                table.insert(),
 
129
                [
 
130
                    dict(data="data1"),
 
131
                    dict(data="data2"),
 
132
                    dict(data="data3"),
 
133
                ]
 
134
        )
 
135
 
 
136
 
 
137
        config.db.execute(
 
138
                table.insert(inline=True).
 
139
                    from_select(
 
140
                        ("id", "data",), select([table.c.id + 5, table.c.data]).where(
 
141
                                table.c.data.in_(["data2", "data3"]))
 
142
                    ),
 
143
        )
 
144
 
 
145
        eq_(
 
146
            config.db.execute(
 
147
                select([table.c.data]).order_by(table.c.data)
 
148
            ).fetchall(),
 
149
            [("data1", ), ("data2", ), ("data2", ),
 
150
                ("data3", ), ("data3", )]
 
151
        )
124
152
 
125
153
class ReturningTest(fixtures.TablesTest):
126
154
    run_deletes = 'each'