summaryrefslogtreecommitdiff
path: root/test/orm/generative.py
diff options
context:
space:
mode:
authorJason Kirtland <jek@discorporate.us>2007-11-05 22:11:30 +0000
committerJason Kirtland <jek@discorporate.us>2007-11-05 22:11:30 +0000
commitbcb586a93c68b4f58ded49b253448f4fe32c558a (patch)
tree91fa5e449e44ef4549c76fa49510cf2e724e921d /test/orm/generative.py
parentd36a3940a0958f444ad9ca9a2e6b5eb54fab9b80 (diff)
downloadsqlalchemy-bcb586a93c68b4f58ded49b253448f4fe32c558a.tar.gz
Migrated maxdb behavioral assumptions from unsupported to fails_on
Diffstat (limited to 'test/orm/generative.py')
-rw-r--r--test/orm/generative.py33
1 files changed, 17 insertions, 16 deletions
diff --git a/test/orm/generative.py b/test/orm/generative.py
index c850069ab..d8fb7a5a6 100644
--- a/test/orm/generative.py
+++ b/test/orm/generative.py
@@ -20,25 +20,26 @@ class GenerativeQueryTest(PersistTest):
Column('id', Integer, Sequence('foo_id_seq'), primary_key=True),
Column('bar', Integer),
Column('range', Integer))
-
+
mapper(Foo, foo)
metadata.create_all()
-
+
sess = create_session(bind=testbase.db)
for i in range(100):
sess.save(Foo(bar=i, range=i%10))
sess.flush()
-
+
def tearDownAll(self):
metadata.drop_all()
clear_mappers()
-
+
def test_selectby(self):
res = create_session(bind=testbase.db).query(Foo).filter_by(range=5)
assert res.order_by([Foo.c.bar])[0].bar == 5
assert res.order_by([desc(Foo.c.bar)])[0].bar == 95
-
+
@testing.unsupported('mssql')
+ @testing.fails_on('maxdb')
def test_slice(self):
sess = create_session(bind=testbase.db)
query = sess.query(Foo)
@@ -90,14 +91,14 @@ class GenerativeQueryTest(PersistTest):
query = create_session(bind=testbase.db).query(Foo)
assert query.filter(foo.c.bar<30).apply_avg(foo.c.bar).first() == 14.5
assert query.filter(foo.c.bar<30).apply_avg(foo.c.bar).one() == 14.5
-
+
def test_filter(self):
query = create_session(bind=testbase.db).query(Foo)
assert query.count() == 100
assert query.filter(Foo.c.bar < 30).count() == 30
res2 = query.filter(Foo.c.bar < 30).filter(Foo.c.bar > 10)
assert res2.count() == 19
-
+
def test_options(self):
query = create_session(bind=testbase.db).query(Foo)
class ext1(MapperExtension):
@@ -105,7 +106,7 @@ class GenerativeQueryTest(PersistTest):
instance.TEST = "hello world"
return EXT_CONTINUE
assert query.options(extension(ext1()))[0].TEST == "hello world"
-
+
def test_order_by(self):
query = create_session(bind=testbase.db).query(Foo)
assert query.order_by([Foo.c.bar])[0].bar == 0
@@ -114,7 +115,7 @@ class GenerativeQueryTest(PersistTest):
def test_offset(self):
query = create_session(bind=testbase.db).query(Foo)
assert list(query.order_by([Foo.c.bar]).offset(10))[0].bar == 10
-
+
def test_offset(self):
query = create_session(bind=testbase.db).query(Foo)
assert len(list(query.limit(10))) == 10
@@ -209,7 +210,7 @@ class RelationsTest(AssertMixin):
filter(or_(tables.Order.c.order_id==None,tables.Item.c.item_id==2))
print x.compile()
self.assert_result(list(x), tables.User, *tables.user_result[1:3])
-
+
class CaseSensitiveTest(PersistTest):
def setUpAll(self):
@@ -232,7 +233,7 @@ class CaseSensitiveTest(PersistTest):
def tearDownAll(self):
metadata.drop_all()
clear_mappers()
-
+
def test_distinctcount(self):
q = create_session(bind=testbase.db).query(Obj1)
assert q.count() == 4
@@ -244,7 +245,7 @@ class CaseSensitiveTest(PersistTest):
class SelfRefTest(ORMTest):
def define_tables(self, metadata):
global t1
- t1 = Table('t1', metadata,
+ t1 = Table('t1', metadata,
Column('id', Integer, primary_key=True),
Column('parent_id', Integer, ForeignKey('t1.id'))
)
@@ -263,8 +264,8 @@ class SelfRefTest(ORMTest):
assert False
except exceptions.InvalidRequestError, e:
assert str(e) == "Self-referential query on 'T.children (T)' property requires create_aliases=True argument.", str(e)
-
-
-
+
+
+
if __name__ == "__main__":
- testbase.main()
+ testbase.main()