def handle(self,*args,**options):
dataReader = csv.reader(open(csv_filepathname), delimiter=',', quotechar='"')
category_list = list(Category.objects.all())
print "category_list: " + str(category_list)
for row in dataReader:
if row[0] == "id":
print row;
else:
print "Catrow= " + str(row)
cat = row[9]
if cat not in category_list:
print "Cat= " + cat
category_list.append(cat)
category = Category()
category.name = cat
category.save()
dataReader = csv.reader(open(csv_filepathname), delimiter=',', quotechar='"')
fields = ['id_2', 'latitude', 'longitude', 'address', 'created', 'district', 'name', 'neighborhood', 'postal_code']
for row in dataReader:
#treiem la primera linia
if row[0] == "id":
print row;
else:
#comprovem si l'hotel ja hi es
if not Apartment.objects.filter(id_2=row[0]).exists():
print "aptrow " + str(row)
cat = Category.objects.get(name=row[9])
row[9] = cat
row[0] = int(row[0])
row[1] = float(row[1])
row[2] = float(row[2])
if row[8]=='None':
row[8] = 0
else:
#we need to put an extra 0 on postal_code
row[8] = 0+int(row[8])
apt = Apartment.objects.create(**dict(zip(fields, row)))
apt.cats.add(row[9])
print "Apartment added" + apt.name
else :
apt = Apartment.objects.get(id_2=row[0])
print apt
cat = Category.objects.get(name=row[9])
apt.cats.add(cat)
apt.save()
print "Apartment added " + str(apt)
dataReader = csv.reader(open(csv_filepathname), delimiter=",", quotechar='"')
category_list = list(Category.objects.all())
print "category_list: " + str(category_list)
for row in dataReader:
if row[0] == "id":
print row
else:
print "Catrow= " + str(row)
cat = row[9]
if cat not in category_list:
print "Cat= " + cat
category_list.append(cat)
category = Category()
category.name = cat
category.save()
dataReader = csv.reader(open(csv_filepathname), delimiter=",", quotechar='"')
fields = [
"id_2",
"latitude",
"longitude",
"address",
"created",
"district",
"name",
"neighborhood",
"postal_code",
"cats",
]