def existRequestID(self, r_id): temp = Discount() temp.requestID = r_id if self.get(temp) is False: return False else: return True
def get(self,discount): ans = self.database.executeKnowQuery('SELECT * FROM discount WHERE requestId = ?', (discount.requestID,)) if (len(ans) == 0): return False ans=ans[0] ret = Discount() ret.setAll(ans) return ret
def getAll(self): ans = self.database.executeKnowQuery('SELECT * FROM discount') if (len(ans) == 0): return False ret = [] for row in ans: temp = Discount() temp.setAll(row) ret.append(temp) return ret
def get(self, discount): ans = self.database.executeKnowQuery( 'SELECT * FROM discount WHERE requestId = ?', (discount.requestID, )) if (len(ans) == 0): return False ans = ans[0] ret = Discount() ret.setAll(ans) return ret
def getByRequestID(self, r_id): temp = Discount() temp.requestID = r_id return self.get(temp)