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()