diff options
| author | mike bayer <mike_mp@zzzcomputing.com> | 2021-04-14 17:21:36 +0000 |
|---|---|---|
| committer | Gerrit Code Review <gerrit@ci3.zzzcomputing.com> | 2021-04-14 17:21:36 +0000 |
| commit | ccff3a14db356ba435d77f2958e87ca8013f6ce4 (patch) | |
| tree | 04b9c5be595f3ae7a2d47eb6a8fd633471a7fe2f /lib/sqlalchemy/testing/suite/test_insert.py | |
| parent | b26cf96462b195a4c12ccdf8283ef028f91eb872 (diff) | |
| parent | 94a1c523984e2082bb16d784cf8615061ba9d49a (diff) | |
| download | sqlalchemy-ccff3a14db356ba435d77f2958e87ca8013f6ce4.tar.gz | |
Merge "Support DEFAULT VALUES and VALUES(DEFAULT) individually"
Diffstat (limited to 'lib/sqlalchemy/testing/suite/test_insert.py')
| -rw-r--r-- | lib/sqlalchemy/testing/suite/test_insert.py | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/lib/sqlalchemy/testing/suite/test_insert.py b/lib/sqlalchemy/testing/suite/test_insert.py index 35f3315c7..3c033a774 100644 --- a/lib/sqlalchemy/testing/suite/test_insert.py +++ b/lib/sqlalchemy/testing/suite/test_insert.py @@ -167,8 +167,21 @@ class InsertBehaviorTest(fixtures.TablesTest): self.tables.autoinc_pk.c.id != None ) ) + eq_(len(r.all()), 1) - assert len(r.fetchall()) + @requirements.empty_inserts_executemany + def test_empty_insert_multiple(self, connection): + r = connection.execute(self.tables.autoinc_pk.insert(), [{}, {}, {}]) + assert r._soft_closed + assert not r.closed + + r = connection.execute( + self.tables.autoinc_pk.select().where( + self.tables.autoinc_pk.c.id != None + ) + ) + + eq_(len(r.all()), 3) @requirements.insert_from_select def test_insert_from_select_autoinc(self, connection): |