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
