summaryrefslogtreecommitdiff
path: root/test/sql/test_delete.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_delete.py')
-rw-r--r--test/sql/test_delete.py14
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