def add(self):
new_record = (self.stars, self.title, self.commentary, self.id_product,
self.id_user)
print(new_record)
addToTable('review (stars, title, commentary, id_product,id_user)',
new_record, '(%s,%s,%s,%s,%s)')
def add(self):
new_record = (self.dni, self.name, self.surname, self.genre,
self.c_size, self.shoe_size, self.phone_no, self.id_user)
addToTable(
'customers (dni,name,surname,genre,c_size,shoe_size,phone_no,id_user)',
new_record, '(%s,%s,%s,%s,%s,%s,%s,%s)')
def add(self):
new_record = (self.id_purchase, self.id_color_size, self.stock)
addToTable('purchxitem (id_purchase, id_color_size, stock)',
new_record, '(%s,%s,%s)')
def add(self):
new_record = (self.id_user, self.id_prod, self.date)
addToTable('wishlist (id_user, id_prod, date)', new_record,
'(%s,%s,%s)')
def add(self):
new_record = (self.id, self.address, self.zip, self.name, self.surname,
self.dni, self.track_code, self.province)
addToTable(
'shipping (id,address, zip, name, surname, dni, track_code, province)',
new_record, '(%s,%s,%s,%s,%s,%s,%s,%s)')
def add(self):
new_record = (self.id_user, self.id_coupon, self.state)
addToTable('purchase (id_user, id_coupon, state)', new_record,
'(%s,%s,%s)')
def add(self):
new_record = (self.color, self.size, self.stock, self.prod_id)
addToTable('color_size (color, size, stock, prod_id)', new_record,
'(%s,%s,%s,%s)')
def add(self):
new_record = (self.pc, self.cad_date, self.used)
addToTable('coupon (pc, cad_date, used)', new_record, '(%s,%s,%s)')
def add(self):
new_record = (self.msg, self.id_user, self.id_chat, self.read)
addToTable('message (msg, id_user, id_chat, read)', new_record,
'(%s,%s,%s,%s)')
def register2(self):
new_record = (self.e_mail, self.external_id, self.id_role, self.active)
addToTable('users (e_mail,external_id,id_role,active)', new_record,
'(%s,%s,%s,%s)')
def add(self):
new_record = (self.id_user, self.id_admin)
addToTable('chat (id_user,id_admin)', new_record, '(%s,%s)')
def add(self):
new_record = (self.name, )
addToTable('roles (name)', new_record, '(%s)')
def register(self):
new_record = (self.e_mail, self.psw, self.id_role, self.active)
addToTable('users (e_mail,psw,id_role,active)', new_record,
'(%s,%s,%s,%s)')