From 1a840730c20feb9444f665d73a29b3ac25edc0e7 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 15 Jul 2007 00:25:18 +0000 Subject: [PATCH] added some text tests --- test/orm/query.py | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/test/orm/query.py b/test/orm/query.py index c0b0c8f84b..286e31305d 100644 --- a/test/orm/query.py +++ b/test/orm/query.py @@ -111,6 +111,19 @@ class SliceTest(QueryTest): assert create_session().query(User).filter(users.c.id==27).first() is None + # more slice tests are available in test/orm/generative.py + +class TextTest(QueryTest): + def test_fulltext(self): + assert [User(id=7), User(id=8), User(id=9),User(id=10)] == create_session().query(User).from_statement("select * from users").all() + + def test_fragment(self): + assert [User(id=8), User(id=9)] == create_session().query(User).filter("id in (8, 9)").all() + + assert [User(id=9)] == create_session().query(User).filter("name='fred'").filter("id=9").all() + + assert [User(id=9)] == create_session().query(User).filter("name='fred'").filter(users.c.id==9).all() + class FilterTest(QueryTest): def test_basic(self): assert [User(id=7), User(id=8), User(id=9),User(id=10)] == create_session().query(User).all() -- 2.47.3