def get(self):
res = searchID('purchase', self.id)
self.price = res[1]
self.date = res[2]
self.state = res[3]
self.id_user = res[4]
self.id_coupon = res[5]
def get(self):
res = searchID('color_size', self.id)
self.id = res[0]
self.color = res[1]
self.size = res[2]
self.stock = res[3]
self.prod_id = res[4]
def get(self, _id):
res = searchID('reservations', _id)
self.id = res[0]
self.date = res[1]
self.stock = res[2]
self.id_user = res[3]
self.id_color_size = res[4]
self.state = res[5]
def get(self):
res = searchID('users', self.id)
self.id = res[0]
self.e_mail = res[1]
self.psw = res[2]
self.external_id = res[3]
self.id_role = res[4]
self.active = res[5]
def get(self, _id):
res = searchID('message', _id)
self.id = res[0]
self.msg = res[1]
self.date = res[2]
self.id_user = res[3]
self.id_chat = res[4]
self.read = res[6]
def get(self):
res = searchID('review', self.id)
self.id = res[0]
self.date = res[1]
self.stars = res[2]
self.title = res[3]
self.commentary = res[4]
self.id_product = res[5]
self.id_user = res[6]
def get(self, _id):
res = searchID('products', _id)
self.id = res[0]
self.name = res[1]
self.dsc = res[2]
self.material = res[3]
self.genre = res[4]
self.brand = res[5]
self.type = res[6]
self.discount = res[7]
self.price = res[8]
self.active = res[9]
def get(self):
res = searchID('shipping', self.id)
if (res == None):
self.id = None
else:
self.id = res[0]
self.address = res[1]
self.zip = res[2]
self.name = res[3]
self.surname = res[4]
self.dni = res[5]
self.track_code = res[6]
self.province = res[7]
def get(self):
res = searchID('customers', self.id)
if (res == None):
self.id = None
else:
self.id = res[0]
self.dni = res[1]
self.name = res[2]
self.surname = res[3]
self.genre = res[4]
self.c_size = res[5]
self.shoe_size = res[6]
self.phone_no = res[7]
self.id_user = res[8]
def getAll(self, _id):
res = searchID('wishlist', _id)
self.id_user = res[0]
self.id_prod = res[1]
self.date = res[2]
def get(self):
res = searchID('coupon', self.id)
self.id = res[0]
self.pc = res[1]
self.cad_date = res[2]
self.used = res[3]
def get(self, _id):
res = searchID('roles', _id)
self.id = res[0]
self.name = res[1]
def get(self, _id):
res = searchID('type', _id)
self.id = res[0]
self.name = res[1]
