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