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'