def save_item(request, item_id, position): if request.user.is_authenticated(): user = request.user url = 'http://api.deezer.com/2.0/%s/%s' % ('track', item_id) json = simplejson.load(urlopen(url)) item = SongLocation(item_type="track", item_id=item_id, position=position, user=user, json=json) item.save() rendered = render_to_string('item.html', {'item': item}) json_serializer = serializers.get_serializer("json")() #item.html = rendered item.json = simplejson.dumps(item.json) item_js = json_serializer.serialize([item,], ensure_ascii=False) return simplejson.dumps({'html':rendered, 'item_js':item_js})
def handle(self, *args, **options): f = open('/Users/goldszmidt/sam/perso/transit/fr.txt', 'r') reader = csv.DictReader(f, delimiter="\t", fieldnames=fieldnames) user = User.objects.get(id=1) root_items = SongLocation.objects.filter(user=user) root_items.delete() for row in reader: url = 'http://api.deezer.com/2.0/search/track/?q=%s' % (row['FULL_NAME_ND_RG']) json = simplejson.load(urlopen(url)) try: for obj in json['data']: if row['FULL_NAME_ND_RO'] in obj['title']: print row['FULL_NAME_ND_RG'] position = GEOSGeometry('POINT(%s %s)' % (row['LONG'], row['LAT'])) print position item = SongLocation(user=user, position=position, item_id=obj['id'], json=obj) item.save() except KeyError: # json has no data key pass