Hi, where does prof.xml_ky comes from ?
Le mercredi 12 juin 2019 18:22:01 UTC+2, Nuno Vieira a écrit :
>
> Hi there.
>
> I´m having some problems on parsing a real estate xml to database.
> The user profile have url field to import properties automatically from
> xml feed (url). The user can insert mannually or automatically, if the user
> insert the url feed then it should be able to get the objects and save them
> to mysql database automatically.
> The function is not working and i do not know why, gives no error but
> don´t populate the database.
>
> Models.py:
> class Listing(models.Model):
> '''Create table listing in db '''
> realtor = models.ForeignKey(User, on_delete=models.CASCADE)
> title = models.CharField(max_length=200)
> address = models.CharField(max_length=200)
> city = models.CharField(max_length=100)
> state = models.CharField(max_length=100)
> zipcode = models.CharField(max_length=20)
> longitude = models.DecimalField(max_digits=9, decimal_places=6,default=0)
> latitude = models.DecimalField(max_digits=9, decimal_places=6, default=0)
> description = models.TextField(blank=True)
> price = models.IntegerField()
> bedrooms = models.IntegerField()
> bathrooms = models.DecimalField(max_digits=2, decimal_places=1)
> garage = models.IntegerField(default=0)
> sqmt = models.IntegerField(blank=True)
> lot_size = models.DecimalField(max_digits=5, decimal_places=1,blank=True)
> On_Processing = 'On Processing'
> AMais = 'A+'
> A = 'A'
> B = 'B'
> BMenos = 'B-'
> C = 'C'
> D = 'D'
> E = 'E'
> F = 'F'
> ENERGY_RATE_CHOICES = [
> (On_Processing, 'On Processing'),
> (AMais, 'A+'),
> (A, 'A'),
> (B, 'B'),
> (BMenos, 'B-'),
> (C, 'C'),
> (D, 'D'),
> (E, 'E'),
> (F, 'F'),
> ]
> energy_rate = models.CharField(
> max_length=12,
> choices=ENERGY_RATE_CHOICES,
> default=On_Processing,
> )
> photo_main = models.ImageField(upload_to='photos/%Y/%m/%d/', default=
> 'default.jpg')
> photo_main_url = models.URLField(blank = True)
> is_published = models.BooleanField(default=True)
> list_date = models.DateTimeField(default=datetime.now, blank=True)
> video_url = models.CharField(max_length=100, blank=True)
> virtual_tour = models.URLField(blank=True)
> visit_num = models.PositiveIntegerField(default=0)
>
> def __str__(self):
> return self.title
>
> def get_absolute_url(self):
> return reverse('listing-detail', kwargs={'pk': self.pk})
>
> Function on xml_parse.py:
> ...
> import xml.etree.ElementTree as ET
> import requests
> from users.models import Profile
>
>
> def xml_parse(self):
> prof_list = Profile.objects.all()
> for prof in prof_list:
> if prof.xml_ky is not None:
> url = xml_ky
> response = request.get(url)
> with open('xml/%s' % self.id + '/feed.xml', 'wb') as file:
> file.write(response.content)
>
> tree = ET.parse('xml/%s' % self.id + '/feed.xml')
> root = tree.getroot()
> for props in root.iter('property'):
> listing, created = Listing.object.create(
> title = props.find('type').text + ' ' + props.find('town').text,
> address = props.find('location_detail').text,
> city = props.find('town').text,
> state = props.find('province').text,
> zipcode = props.find('zipcode').text,
> loc = props.find('location'),
> longitude = loc.find('longitude').text,
> latitude = loc.find('latitude').text,
> desc = props.find('desc'),
> description = desc.find('en').text,
> price = props.find('price').text,
> bedrooms = props.find('beds').text,
> bathrooms = props.find('baths').text,
> garage = props.find('garage').text,
> area = props.find('surface_area'),
> sqmt = area.find('built').text,
> energy_rate = props.find('energy_rate').text,
> realtor = self.request.user,
> img = props.find('images'),
> image = img.get('id=1'),
> image_url = image.find('url').text,
> photo_main_url = image_url,
> video_url = props.find('video_url').text,
> virtual_tour = props.find('virtual_tour').text,
> )
> if created:
> return listing.save()
>
>
>
> If you could help me and point me in the right direction it would be great.
>
> Thanks and sorry for the black background!
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/20aa727c-d1e8-4d5f-a17d-ac17947ba5f3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
