def getByID(self,id): ans = self.database.executeKnowQuery('SELECT * FROM request WHERE id = ?', (id,)) if (len(ans) == 0): return False ans=ans[0] ret = Request() ret.setAll(ans) return ret
def getByID(self, id): ans = self.database.executeKnowQuery( 'SELECT * FROM request WHERE id = ?', (id, )) if (len(ans) == 0): return False ans = ans[0] ret = Request() ret.setAll(ans) return ret
def getAll(self): ans = self.database.executeKnowQuery('SELECT * from request') if (len(ans) == 0): return False ret = [] for r in ans: temp = Request() temp.setAll(r) ret.append(temp) return ret
def getByStatus(self, status): ans = self.database.executeKnowQuery('SELECT * FROM request WHERE status = ?', (status,)) if (len(ans) == 0): return [] ret = [] for r in ans: temp = Request() temp.setAll(r) ret.append(temp) return ret
def getAll(self): ans= self.database.executeKnowQuery('SELECT * from request') if (len(ans)==0): return False ret=[] for r in ans: temp = Request() temp.setAll(r) ret.append(temp) return ret
def get(self,request): ans = self.database.executeKnowQuery('SELECT * FROM request WHERE clientID = ?', (request.getClientID(),)) if (len(ans) == 0): return False ret = [] for row in ans: req = Request() req.setAll(row) ret.append(req) return ret
def getByStatus(self, status): ans = self.database.executeKnowQuery( 'SELECT * FROM request WHERE status = ?', (status, )) if (len(ans) == 0): return [] ret = [] for r in ans: temp = Request() temp.setAll(r) ret.append(temp) return ret
def get(self, request): ans = self.database.executeKnowQuery( 'SELECT * FROM request WHERE clientID = ?', (request.getClientID(), )) if (len(ans) == 0): return False ret = [] for row in ans: req = Request() req.setAll(row) ret.append(req) return ret