def get(self,ids=[]): dao = OrderItemDao() rows = dao.get(ids) orderItems = [] for row in rows: orderItems.append(OrderItem(row[0],row[1],row[2],row[3],row[4],row[5],row[6],row[7],row[8],row[9],row[10],row[11],row[12],row[13],row[14],row[15],row[16])) return orderItems
def insert(self , orderItems): dao = OrderItemDao() values = [(oi.supplier_id,oi.csp_id,oi.csp_contact_id,oi.owner_id,oi.airline_id, oi.csp_po_number,oi.supplier_invoice_number, # oi.owner_po_number, oi.title,oi.comments,oi.start_date,oi.end_date,oi.unit_price, oi.units, oi.delivery_format, oi.total_price,oi.delivery_date) for oi in orderItems] ids = dao.insert(values) newOrderItems = self.get(ids) #set the default phone and email types return newOrderItems
def update(self, orderItems): dao = OrderItemDao() values = [(oi.id, oi.supplier_id,oi.csp_id,oi.csp_contact_id,oi.owner_id,oi.airline_id, oi.csp_po_number,oi.supplier_invoice_number, #oi.owner_po_number, oi.title,oi.comments,oi.start_date,oi.end_date,oi.unit_price, oi.units, oi.delivery_format, oi.total_price,oi.delivery_date) for oi in orderItems] dao.update(values) ids = [(oi.id) for oi in orderItems] updatedOrderItems = self.get(ids) return updatedOrderItems