def add_site(self):
now = datetime.now()
respuesta = conexion.Add(
"insert into places (name,type,date,img,imgc1,imgc2,imgc3,category,locate,description) values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",
[
self.name, self.type, now, self.img, self.imgc1, self.imgc2,
self.imgc3, self.category, self.locate, self.description
])
return respuesta
def add_site(self):
respuesta = conexion.Add(
"insert into places (name,type,date,img,imgc1,imgc2,imgc3,prices,category,locate,description) values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",
[
self.name, self.type, "2021-03-02", self.img, self.imgc1,
self.imgc2, self.imgc3, self.prices, self.category,
self.locate, self.description
])
return respuesta
def send_email(self):
respuesta = conexion.search('select name,email from users where email = %s',[self.email])
if respuesta:
for i in respuesta:
now = datetime.now() + timedelta(hours=24)
resp = conexion.Add('update users set code=%s, recovery_date= %s where email = %s',[self.code,now,self.email])
return i[0]
else:
return None
def update(self):
now = datetime.now()
respuesta = conexion.Add(
"update places set name=%s,type=%s,date=%s,img=%s,imgc1=%s,imgc2=%s,imgc3=%s,category=%s,locate=%s,description=%s where id = %s",
[
self.name, self.type, now, self.img, self.imgc1, self.imgc2,
self.imgc3, self.category, self.locate, self.description,
self.id
])
return respuesta
def Purchase(self):
now = datetime.now()
now2 = now + timedelta(days=15)
respuesta = conexion.Add("insert into record (email,ticket,date_ex,date_com,amount,price,name_place) values (%s,%s,%s,%s,%s,%s,%s)",[self.email,self.ticket,now2,now,self.amount,self.price,self.name])
def delete_price(self):
respuesta = conexion.Add('delete from prices where id = %s', [self.id])
def set_price(self):
respuesta = conexion.Add(
"insert into prices (id_place, price) values (%s,%s)",
[self.id, self.prices])
def delete(self):
for i in self.datos:
respuesta = conexion.Add('delete from places where id = %s', [i])
return respuesta
def modification_pass(self):
now = datetime.now()
respuesta = conexion.Add('update users set indentify = %s, recovery_date = %s where code = %s',[self.password,now,self.code])
if respuesta:
return 'Ok'