def getByID(self, id):
ans = self.database.executeKnowQuery('SELECT * FROM client WHERE id = ?', (id,))
if (len(ans) == 0):
return False
ans = ans[0]
ret = Client()
ret.setAll(ans)
return ret
def get(self,client):
ans = self.database.executeKnowQuery('SELECT * FROM client WHERE email = ?', (client.getEmail(),))
if (len(ans) == 0):
return False
ans = ans[0]
ret = Client()
ret.setAll(ans)
return ret
def getByID(self, id):
ans = self.database.executeKnowQuery(
'SELECT * FROM client WHERE id = ?', (id, ))
if (len(ans) == 0):
return False
ans = ans[0]
ret = Client()
ret.setAll(ans)
return ret
def get(self, client):
ans = self.database.executeKnowQuery(
'SELECT * FROM client WHERE email = ?', (client.getEmail(), ))
if (len(ans) == 0):
return False
ans = ans[0]
ret = Client()
ret.setAll(ans)
return ret
def getAll(self):
ans = self.database.executeKnowQuery('SELECT * FROM client')
if (len(ans) == 0):
return False
ret = []
for row in ans:
temp = Client()
temp.setAll(row)
ret.append(temp)
return ret
def getAll(self):
ans = self.database.executeKnowQuery('SELECT * FROM client')
if (len(ans) == 0):
return False
ret = []
for row in ans:
temp = Client()
temp.setAll(row)
ret.append(temp)
return ret
def getByName(self, name):
ans = self.database.executeKnowQuery('SELECT * FROM client ')
if (ans == False):
return False
ret = []
for row in ans:
if (name not in row[2]): continue
temp = Client()
temp.setAll(row)
ret.append(temp)
return ret
def getByName(self,name):
ans = self.database.executeKnowQuery('SELECT * FROM client ')
if (ans== False):
return False
ret = []
for row in ans:
if (name not in row[2]) : continue
temp = Client()
temp.setAll(row)
ret.append(temp)
return ret
