diff options
Diffstat (limited to 'test/sql/test_delete.py')
| -rw-r--r-- | test/sql/test_delete.py | 41 |
1 files changed, 22 insertions, 19 deletions
diff --git a/test/sql/test_delete.py b/test/sql/test_delete.py index 64173bb00..904dcee3f 100644 --- a/test/sql/test_delete.py +++ b/test/sql/test_delete.py @@ -1,11 +1,13 @@ #! coding:utf-8 -from sqlalchemy import Column, Integer, String, Table, delete, select, and_, or_ +from sqlalchemy import Column, Integer, String, Table, delete, select, and_, \ + or_ from sqlalchemy.dialects import mysql from sqlalchemy.testing import AssertsCompiledSQL, fixtures class _DeleteTestBase(object): + @classmethod def define_tables(cls, metadata): Table('mytable', metadata, @@ -33,8 +35,8 @@ class DeleteTest(_DeleteTestBase, fixtures.TablesTest, AssertsCompiledSQL): self.assert_compile( table1.delete(). - where(table1.c.myid == 7). - where(table1.c.name == 'somename'), + where(table1.c.myid == 7). + where(table1.c.name == 'somename'), 'DELETE FROM mytable ' 'WHERE mytable.myid = :myid_1 ' 'AND mytable.name = :name_1') @@ -59,11 +61,11 @@ class DeleteTest(_DeleteTestBase, fixtures.TablesTest, AssertsCompiledSQL): prefix_with('C', 'D') self.assert_compile(stmt, - 'DELETE C D FROM mytable') + 'DELETE C D FROM mytable') self.assert_compile(stmt, - 'DELETE A B C D FROM mytable', - dialect=mysql.dialect()) + 'DELETE A B C D FROM mytable', + dialect=mysql.dialect()) def test_alias(self): table1 = self.tables.mytable @@ -71,7 +73,8 @@ class DeleteTest(_DeleteTestBase, fixtures.TablesTest, AssertsCompiledSQL): talias1 = table1.alias('t1') stmt = delete(talias1).where(talias1.c.myid == 7) - self.assert_compile(stmt, + self.assert_compile( + stmt, 'DELETE FROM mytable AS t1 WHERE t1.myid = :myid_1') def test_correlated(self): @@ -80,19 +83,19 @@ class DeleteTest(_DeleteTestBase, fixtures.TablesTest, AssertsCompiledSQL): # test a non-correlated WHERE clause s = select([table2.c.othername], table2.c.otherid == 7) self.assert_compile(delete(table1, table1.c.name == s), - 'DELETE FROM mytable ' - 'WHERE mytable.name = (' - 'SELECT myothertable.othername ' - 'FROM myothertable ' - 'WHERE myothertable.otherid = :otherid_1' - ')') + 'DELETE FROM mytable ' + 'WHERE mytable.name = (' + 'SELECT myothertable.othername ' + 'FROM myothertable ' + 'WHERE myothertable.otherid = :otherid_1' + ')') # test one that is actually correlated... s = select([table2.c.othername], table2.c.otherid == table1.c.myid) self.assert_compile(table1.delete(table1.c.name == s), - 'DELETE FROM mytable ' - 'WHERE mytable.name = (' - 'SELECT myothertable.othername ' - 'FROM myothertable ' - 'WHERE myothertable.otherid = mytable.myid' - ')') + 'DELETE FROM mytable ' + 'WHERE mytable.name = (' + 'SELECT myothertable.othername ' + 'FROM myothertable ' + 'WHERE myothertable.otherid = mytable.myid' + ')') |