def create_dataset(request, name, description, in_places, user_id):
try:
# if the dataset already exists
ds = Dataset.objects.get(name=name)
messages.error(request, "שם המאגר קיים במערכת")
return False
except Dataset.DoesNotExist:
pass
ds = Dataset()
ds.owner = User.objects.get(id=user_id)
ds.name = name
ds.description = description
ds.save()
for p in in_places:
place = Place()
try:
place.vendor_id = p["id"]
place.address = p["address"].strip()
place.city = p["city"].strip()
place.title = p["title"].strip()
except KeyError, ex:
print ex
delete_dataset(ds)
messages.error(request, "אחד השדות הדרושים חסר. וודא כי כל הרשומות מכילות את השדות: id, address, city, title")
return False
place.data = json.dumps(p)
place.dataset = ds
place.save()
def handle(self, *args, **options):
if len(args) <= 0:
raise CommandError('please specify file name')
if not os.path.exists(args[0]):
raise CommandError("file %s doesn't exist" % args[0])
with open(args[0], 'r') as f:
result = json.load(f)
for i in result:
try:
place = Place.objects.get(vendor_id=i['id'])
if place.data == json.dumps(i):
print "place id #%s already exist... skipping" % i["id"]
else:
place.data = json.dumps(i)
place.save()
print "place id #%s was update" % i["id"]
except Place.DoesNotExist:
place = Place()
place.vendor_id = i["id"]
place.data = json.dumps(i)
place.save()
print "place id #%s added" % i["id"]
def setUp(self):
User.objects.create_user("segalle", email=None, password="******")
User.objects.create_user("moshe", email=None, password="******")
p = Place()
p.vendor_id = 1000
p.data = {
"city": "\u05d9\u05e8\u05d5\u05e9\u05dc\u05d9\u05dd",
"name": "\u05e9\u05d9\u05da \u05d2'\u05e8\u05d0\u05d7",
"district": "\u05d9\u05e8\u05d5\u05e9\u05dc\u05d9\u05dd",
"phones": "02-5871923",
"notes": "",
"subdistrict": "\u05d9\u05e8\u05d5\u05e9\u05dc\u05d9\u05dd",
"days": [
"8:00-17:00",
"8:00-17:00",
"8:00-17:00",
"8:00-17:00",
"8:00-13:00",
"\u05e1\u05d2\u05d5\u05e8"
],
"address": "\u05de\u05e8\u05db\u05d6 \u05e8\u05e4\u05d5\u05d0\u05d9",
"owner": "\u05e2\u05d9\u05e8\u05d9\u05d9\u05ea \u05d9\u05e8\u05d5\u05e9\u05dc\u05d9\u05dd",
"id": 1000
}
p.save()
self.pm = Placemark()
self.pm.place = p
self.pm.city = "\u05d9\u05e8\u05d5\u05e9\u05dc\u05d9\u05dd"
self.pm.address = "\u05de\u05e8\u05db\u05d6 \u05e8\u05e4\u05d5\u05d0\u05d9"
self.pm.lat = 31.15
self.pm.lng = 32.16
self.pm.save()
self.pm1 = Placemark()
self.pm1.place = p
self.pm1.city = "\u05d9\u05e8\u05d5\u05e9\u05dc\u05d9\u05dd"
self.pm1.address = "\u05de\u05e8\u05db\u05d6 \u05e8\u05e4\u05d5\u05d0\u05d9"
self.pm1.lat = 31.25
self.pm1.lng = 32.26
self.pm1.save()
self.pm2 = Placemark()
self.pm2.place = p
self.pm2.city = "\u05d9\u05e8\u05d5\u05e9\u05dc\u05d9\u05dd"
self.pm2.address = "\u05de\u05e8\u05db\u05d6 \u05e8\u05e4\u05d5\u05d0\u05d9"
self.pm2.lat = 31.35
self.pm2.lng = 32.36
self.pm2.save()
