def populate(dbc):
pizzeria.populate(dbc)
SERV = dbc.query(Service)
CUST = dbc.query(pizzeria.Customer)
ORDERS = dbc.query(pizzeria.Order)
PROD = dbc.query(pizzeria.Product)
s1 = SERV.appendRow(name="bring home",price=1)
s2 = SERV.appendRow(name="organize party",price=100)
c3 = CUST.appendRow(name="Bernard")
o1 = ORDERS.appendRow(customer=c3,date=itod(20040318))
q = o1.lines()
q.appendRow(product=PROD.peek(1),qty=1)
q.appendRow(product=s1,qty=1)
o2 = ORDERS.appendRow(customer=CUST.peek(1),date=itod(20040319))
q = o2.lines()
q.appendRow(product=PROD.peek(1),qty=2)
q.appendRow(product=PROD.peek(2),qty=3)
o1.register()
o2.register()
def test04(self):
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)
#db = self.db
pizzeria.populate(self.sess)
s1 = SERV.appendRow(name="bring home",price=1)
s2 = SERV.appendRow(name="organize party",price=100)
c3 = CUST.appendRow(name="Bernard")
p1 = PROD.peek(1)
p2 = PROD.peek(2)
o1 = ORDERS.appendRow(customer=c3,date=itod(20040318))
q = o1.lines()
q.appendRow(product=s1,qty=1)
q.appendRow(product=p1,qty=1)
o2 = ORDERS.appendRow(customer=CUST[1],
date=itod(20040319))
q = o2.lines()
q.appendRow(product=p1,qty=2)
q.appendRow(product=p2,qty=3)
#LINES.appendRow(order=o1,product=s2,qty=1)
#db.commit()
q = o1.lines("product qty")
totalPrice = 0
for line in q:
#print line.product.name, line.qty
totalPrice += (line.qty * line.product.price)
o1.register()
o2.register()
self.sess.commit()
def test04(self):
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)
#db = self.db
pizzeria.populate(self.sess)
s1 = SERV.appendRow(name="bring home", price=1)
s2 = SERV.appendRow(name="organize party", price=100)
c3 = CUST.appendRow(name="Bernard")
p1 = PROD.peek(1)
p2 = PROD.peek(2)
o1 = ORDERS.appendRow(customer=c3, date=itod(20040318))
q = o1.lines()
q.appendRow(product=s1, qty=1)
q.appendRow(product=p1, qty=1)
o2 = ORDERS.appendRow(customer=CUST[1], date=itod(20040319))
q = o2.lines()
q.appendRow(product=p1, qty=2)
q.appendRow(product=p2, qty=3)
#LINES.appendRow(order=o1,product=s2,qty=1)
#db.commit()
q = o1.lines("product qty")
totalPrice = 0
for line in q:
#print line.product.name, line.qty
totalPrice += (line.qty * line.product.price)
o1.register()
o2.register()
self.sess.commit()
from lino.apps.pizzeria.pizzeria import Pizzeria, populate, Order
app = Pizzeria()
dbc = app.createContext()
populate(dbc)
orders = dbc.query(Order,"customer totalPrice")
for o in orders:
print "%s must pay %d EUR" % (o.customer.name, o.totalPrice)
del app, dbc, orders, o
from lino.apps.pizzeria.pizzeria import Pizzeria, populate, Order
app = Pizzeria()
dbc = app.createContext()
populate(dbc)
orders = dbc.query(Order,"customer totalPrice")
for o in orders:
print "%s must pay %d EUR" % (o.customer.name, o.totalPrice)
del app, dbc, orders, o