def test05(self):
return
SERV = self.sess.query(Service)
CUST = self.sess.query(Customer)
PROD = self.sess.query(Product)
ORDERS = self.sess.query(Order)
LINES = self.sess.query(OrderLine)
services.populate(self.sess)
q = LINES.query("order.date order.customer.name", product=PROD[1])
self.assertEquivalent(
q.getSqlSelect(),
"""
SELECT
lead.id, lead.order_id, xorder.id, xorder.customer_id,
xorder_customer.id,
lead.productProducts_id,
lead.productServices_id,
xorder.xdate,
xorder_customer.name
FROM OrderLines AS lead
LEFT JOIN Orders AS xorder
ON (lead.order_id = xorder.id)
LEFT JOIN Customers AS xorder_customer
ON (xorder.customer_id = xorder_customer.id)
WHERE AND product_id ISNULL
AND productProducts_id = 1""",
)
def test05(self):
return
SERV = self.sess.query(Service)
CUST = self.sess.query(Customer)
PROD = self.sess.query(Product)
ORDERS = self.sess.query(Order)
LINES = self.sess.query(OrderLine)
services.populate(self.sess)
q = LINES.query("order.date order.customer.name", product=PROD[1])
self.assertEquivalent(
q.getSqlSelect(), """
SELECT
lead.id, lead.order_id, xorder.id, xorder.customer_id,
xorder_customer.id,
lead.productProducts_id,
lead.productServices_id,
xorder.xdate,
xorder_customer.name
FROM OrderLines AS lead
LEFT JOIN Orders AS xorder
ON (lead.order_id = xorder.id)
LEFT JOIN Customers AS xorder_customer
ON (xorder.customer_id = xorder_customer.id)
WHERE AND product_id ISNULL
AND productProducts_id = 1""")
def setUp(self):
TestCase.setUp(self)
app=services.MyPizzeria()
self.sess=app.createContext()
services.populate(self.sess)
from lino.apps.pizzeria.pizzeria import Product, OrderLine
from lino.apps.pizzeria.services import \
MyPizzeria, populate
app = MyPizzeria()
dbc = app.createContext()
populate(dbc)
p=dbc.query(Product).peek(1)
qry = dbc.query(OrderLine,"order.date order.customer",
product=p)
qry.show(
columnWidths="10 13",
title="Who bought %s (product# %s)?" % (p.name, p.id))
print
print qry.getSqlSelect()
#del qry, dbc, app
dbc.shutdown()
def setUp(self):
TestCase.setUp(self)
app = services.MyPizzeria()
self.sess = app.createContext()
services.populate(self.sess)
from lino.apps.pizzeria.pizzeria import Order
from lino.apps.pizzeria.services import MyPizzeria, populate
app = MyPizzeria() # label="Luc's Pizza Service")
dbc = app.createContext()
populate(dbc)
orders = dbc.query(Order)
o = orders.peek(3)
print "Order #:", o.id
print "Date:", o.date
print "Customer:", o.customer.name
print "-" * 40
for line in o.lines():
print "%-20s %3d %5d" % (line.product.name,
line.qty,
line.product.price*line.qty)
print "-" * 40
print "Total: ", o.totalPrice
#del app, dbc, o, line
dbc.shutdown()
