diff options
Diffstat (limited to 'test/sql/test_query.py')
| -rw-r--r-- | test/sql/test_query.py | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/test/sql/test_query.py b/test/sql/test_query.py index 95e159316..9da9c2ff9 100644 --- a/test/sql/test_query.py +++ b/test/sql/test_query.py @@ -48,6 +48,17 @@ class QueryTest(fixtures.TestBase): def teardown_class(cls): metadata.drop_all() + def test_multirow_insert(self): + users.insert(values=[{'user_id':7, 'user_name':'jack'}, + {'user_id':8, 'user_name':'ed'}]).execute() + rows = users.select().execute().fetchall() + self.assert_(rows[0] == (7, 'jack')) + self.assert_(rows[1] == (8, 'ed')) + users.insert(values=[(9, 'jack'), (10, 'ed')]).execute() + rows = users.select().execute().fetchall() + self.assert_(rows[2] == (9, 'jack')) + self.assert_(rows[3] == (10, 'ed')) + def test_insert_heterogeneous_params(self): """test that executemany parameters are asserted to match the parameter set of the first.""" |
