diff options
Diffstat (limited to 'test/sql/test_delete.py')
-rw-r--r-- | test/sql/test_delete.py | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/test/sql/test_delete.py b/test/sql/test_delete.py index b56731515..64173bb00 100644 --- a/test/sql/test_delete.py +++ b/test/sql/test_delete.py @@ -1,6 +1,6 @@ #! coding:utf-8 -from sqlalchemy import Column, Integer, String, Table, delete, select +from sqlalchemy import Column, Integer, String, Table, delete, select, and_, or_ from sqlalchemy.dialects import mysql from sqlalchemy.testing import AssertsCompiledSQL, fixtures @@ -39,6 +39,18 @@ class DeleteTest(_DeleteTestBase, fixtures.TablesTest, AssertsCompiledSQL): 'WHERE mytable.myid = :myid_1 ' 'AND mytable.name = :name_1') + def test_where_empty(self): + table1 = self.tables.mytable + + self.assert_compile( + table1.delete().where(and_()), + "DELETE FROM mytable" + ) + self.assert_compile( + table1.delete().where(or_()), + "DELETE FROM mytable" + ) + def test_prefix_with(self): table1 = self.tables.mytable |