summaryrefslogtreecommitdiff
path: root/test/sql/test_utils.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_utils.py')
-rw-r--r--test/sql/test_utils.py98
1 files changed, 0 insertions, 98 deletions
diff --git a/test/sql/test_utils.py b/test/sql/test_utils.py
index 023c483fc..988d5331e 100644
--- a/test/sql/test_utils.py
+++ b/test/sql/test_utils.py
@@ -1,105 +1,7 @@
-from sqlalchemy import and_
-from sqlalchemy import bindparam
-from sqlalchemy import Column
-from sqlalchemy import Integer
-from sqlalchemy import MetaData
-from sqlalchemy import or_
-from sqlalchemy import String
-from sqlalchemy import Table
-from sqlalchemy.sql import operators
from sqlalchemy.sql import util as sql_util
-from sqlalchemy.sql.elements import ClauseList
from sqlalchemy.sql.elements import ColumnElement
from sqlalchemy.testing import eq_
from sqlalchemy.testing import fixtures
-from sqlalchemy.testing import is_false
-from sqlalchemy.testing import is_true
-
-
-class CompareClausesTest(fixtures.TestBase):
- def setup(self):
- m = MetaData()
- self.a = Table("a", m, Column("x", Integer), Column("y", Integer))
-
- self.b = Table("b", m, Column("y", Integer), Column("z", Integer))
-
- def test_compare_clauselist_associative(self):
-
- l1 = and_(self.a.c.x == self.b.c.y, self.a.c.y == self.b.c.z)
-
- l2 = and_(self.a.c.y == self.b.c.z, self.a.c.x == self.b.c.y)
-
- l3 = and_(self.a.c.x == self.b.c.z, self.a.c.y == self.b.c.y)
-
- is_true(l1.compare(l1))
- is_true(l1.compare(l2))
- is_false(l1.compare(l3))
-
- def test_compare_clauselist_not_associative(self):
-
- l1 = ClauseList(
- self.a.c.x, self.a.c.y, self.b.c.y, operator=operators.sub
- )
-
- l2 = ClauseList(
- self.b.c.y, self.a.c.x, self.a.c.y, operator=operators.sub
- )
-
- is_true(l1.compare(l1))
- is_false(l1.compare(l2))
-
- def test_compare_clauselist_assoc_different_operator(self):
-
- l1 = and_(self.a.c.x == self.b.c.y, self.a.c.y == self.b.c.z)
-
- l2 = or_(self.a.c.y == self.b.c.z, self.a.c.x == self.b.c.y)
-
- is_false(l1.compare(l2))
-
- def test_compare_clauselist_not_assoc_different_operator(self):
-
- l1 = ClauseList(
- self.a.c.x, self.a.c.y, self.b.c.y, operator=operators.sub
- )
-
- l2 = ClauseList(
- self.a.c.x, self.a.c.y, self.b.c.y, operator=operators.div
- )
-
- is_false(l1.compare(l2))
-
- def test_compare_binds(self):
- b1 = bindparam("foo", type_=Integer())
- b2 = bindparam("foo", type_=Integer())
- b3 = bindparam("bar", type_=Integer())
- b4 = bindparam("foo", type_=String())
-
- def c1():
- return 5
-
- def c2():
- return 6
-
- b5 = bindparam("foo", type_=Integer(), callable_=c1)
- b6 = bindparam("foo", type_=Integer(), callable_=c2)
- b7 = bindparam("foo", type_=Integer(), callable_=c1)
-
- b8 = bindparam("foo", type_=Integer, value=5)
- b9 = bindparam("foo", type_=Integer, value=6)
-
- is_false(b1.compare(b5))
- is_true(b5.compare(b7))
- is_false(b5.compare(b6))
- is_true(b1.compare(b2))
-
- # currently not comparing "key", as we often have to compare
- # anonymous names. however we should really check for that
- is_true(b1.compare(b3))
-
- is_false(b1.compare(b4))
- is_false(b1.compare(b8))
- is_false(b8.compare(b9))
- is_true(b8.compare(b8))
class MiscTest(fixtures.TestBase):