def update(self,cspOrderItems=[]): dao = CspOrderDao() values = [(co.id,co.csp_id,co.csp_accounts_payable_contact_id,co.owner_id,co.owner_contact_id,co.owner_invoice_number,co.owner_invoice_date) for co in cspOrderItems] dao.update(values) ids = [(co.id) for co in cspOrderItems] updatedCspOrders = self.get(ids) return updatedCspOrders
def get(self,ids=[]): dao = CspOrderDao() rows = dao.get(ids) cspOrders = [] for row in rows: cspOrders.append(CspOrder(row[0],row[1],row[2],row[3],row[4],row[5],row[6])) self.decorate(cspOrders) return cspOrders
def insert(self,cspOrderItems=[]): dao = CspOrderDao() values = [(co.csp_id,co.csp_accounts_payable_contact_id,co.owner_id,co.owner_contact_id,co.owner_invoice_number,co.owner_invoice_date) for co in cspOrderItems] ids = dao.insert(values) newCspOrders = self.get(ids) #set the default phone and email types return newCspOrders
def addOrderItem(self,co,oi): dao = CspOrderDao() dao.joinOrderItem(co.id,oi.id) co.items.append(oi) return (self.get([co.id]))