From 37ced0946c4717422f8a4cc6ce4de1bd78ee942e Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Mon, 23 Jul 2012 20:59:46 -0400 Subject: - some more interpret_as_froms --- test/orm/test_query.py | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'test/orm/test_query.py') diff --git a/test/orm/test_query.py b/test/orm/test_query.py index b80db67eb..44e016c86 100644 --- a/test/orm/test_query.py +++ b/test/orm/test_query.py @@ -130,6 +130,14 @@ class RawSelectTest(QueryTest, AssertsCompiledSQL): "SELECT * FROM users" ) + def test_inline_select_from_entity(self): + User = self.classes.User + + self.assert_compile( + select(['*'], from_obj=User), + "SELECT * FROM users" + ) + def test_select_from_aliased_entity(self): User = self.classes.User ua = aliased(User, name="ua") @@ -193,6 +201,16 @@ class RawSelectTest(QueryTest, AssertsCompiledSQL): "SELECT ua.id, ua.name FROM users AS ua" ) + def test_core_join(self): + User = self.classes.User + Address = self.classes.Address + from sqlalchemy.sql import join + self.assert_compile( + select([User]).select_from(join(User, Address)), + "SELECT users.id, users.name FROM users " + "JOIN addresses ON users.id = addresses.user_id" + ) + class GetTest(QueryTest): def test_get(self): User = self.classes.User -- cgit v1.2.1