def test_load_collection_mixed(self):
Customer = self.classes.Customer
Order = self.classes.Order
s = Session()
n = orm_nested(s.query(Order.id, Order).filter(Customer.orders))
q = s.query(Customer, n).filter(Customer.id == 1)
with self.assert_statement_count(1):
eq_(
q.all(),
[
(Customer(id=1, name='David McFarlane'),
[
(101, Order(customer_id=1, id=101,
order_info='apple related')),
(102, Order(customer_id=1, id=102,
order_info='apple related')),
(103, Order(customer_id=1, id=103,
order_info='apple related'))
]
)
]
)
def test_render_query_nested_alone(self):
Customer = self.classes.Customer
Order = self.classes.Order
s = Session()
n = orm_nested(s.query(Order).filter(Customer.orders))
self.assert_compile(
n, '(SELECT "order".id, "order".customer_id, "order".order_info '
'FROM "order", customer WHERE customer.id = "order".customer_id)')
def test_render_query_nested_alone(self):
Customer = self.classes.Customer
Order = self.classes.Order
s = Session()
n = orm_nested(s.query(Order).filter(Customer.orders))
self.assert_compile(
n,
'(SELECT "order".id, "order".customer_id, "order".order_info '
'FROM "order", customer WHERE customer.id = "order".customer_id)'
)
def test_load_collection_entity(self):
Customer = self.classes.Customer
Order = self.classes.Order
s = Session()
n = orm_nested(s.query(Order).filter(Customer.orders))
q = s.query(Customer, n).filter(Customer.id == 1)
with self.assert_statement_count(1):
eq_(q.all(), self._orm_fixture(orders=True))
def test_render_query_basic_nested(self):
Customer = self.classes.Customer
Order = self.classes.Order
s = Session()
n = orm_nested(s.query(Order).filter(Customer.orders))
q = s.query(Customer, n)
self.assert_compile(
q, 'SELECT customer.id AS customer_id, '
'customer.name AS customer_name, (SELECT "order".id, '
'"order".customer_id, "order".order_info FROM "order" '
'WHERE customer.id = "order".customer_id) AS anon_1 '
'FROM customer')
def test_render_query_basic_nested(self):
Customer = self.classes.Customer
Order = self.classes.Order
s = Session()
n = orm_nested(s.query(Order).filter(Customer.orders))
q = s.query(Customer, n)
self.assert_compile(
q,
'SELECT customer.id AS customer_id, '
'customer.name AS customer_name, (SELECT "order".id, '
'"order".customer_id, "order".order_info FROM "order" '
'WHERE customer.id = "order".customer_id) AS anon_1 '
'FROM customer'
)
def test_load_collection_entity(self):
Customer = self.classes.Customer
Order = self.classes.Order
s = Session()
n = orm_nested(s.query(Order).filter(Customer.orders))
q = s.query(Customer, n).filter(Customer.id == 1)
with self.assert_statement_count(1):
eq_(
q.all(),
self._orm_fixture(orders=True)
)
def test_load_collection_mixed(self):
Customer = self.classes.Customer
Order = self.classes.Order
s = Session()
n = orm_nested(s.query(Order.id, Order).filter(Customer.orders))
q = s.query(Customer, n).filter(Customer.id == 1)
with self.assert_statement_count(1):
eq_(q.all(), [(Customer(id=1, name='David McFarlane'), [
(101, Order(customer_id=1, id=101,
order_info='apple related')),
(102, Order(customer_id=1, id=102,
order_info='apple related')),
(103, Order(customer_id=1, id=103, order_info='apple related'))
])])
