def __init__(self,phone,first_name='',last_name='',dob=''): self.table='person' self.phone = phone if first_name: self.first_name = first_name if last_name: self.last_name = last_name if dob: self.dob = dob c = DBConnector(db_name='vet') result = c.getResults(self.table,phone=self.phone) print(result.message)
def getUser(self): c = DBConnector() result = c.getResults('users',Name=self.name) return result
def getGame(self): c = DBConnector() result = c.getResults('games',Game=self.game) return result
from DBConnector import DBConnector import json #tup = (('1001', 'Andy', 'Depczynski', '3 Woodridge Ave.', 'Cheektowaga', 'NY', '14225', 'datetime.date(1989, 9, 6)'),) c = DBConnector(db_name='vet') result = c.getResults('person') #print(result.message) dict = dict() count = 1 for i in result.message: for j in i: key = 'id'+str(count) dict[key] = {count,j} count+=1 #jsonObj = json.loads(dict) #print(jsonObj) print(dict) for i in dict: print(i)