Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if resource == "adds":
- try:
- lastid = request.GET['lastid']
- except KeyError:
- lastid = 0
- if not lastid: lastid = 0
- adds = PlaylistEntry.objects.extra(select={"user_vote": "SELECT ROUND(score, 0) FROM playlist_rating WHERE playlist_rating.user_id = \
- %s AND playlist_rating.song_id = playlist_playlistentry.song_id", "avg_score": "SELECT AVG(playlist_rating.score) FROM playlist_rating WHERE playlist_rating.song_id = pl
- aylist_playlistentry.song_id", "vote_count": "SELECT COUNT(*) FROM playlist_rating WHERE playlist_rating.song_id = playlist_playlistentry.song_id"},
- select_params=[request.user.id]).select_related("song__artist", "song__album", "song__uploader", "adder").order_by('addtime').filter(id__gt=lastid)
- data = serialize("json", adds, relations={'song':{'relations':('artist'), 'fields':('title', 'length', 'artist', 'avgscore')}, 'adder':{'fields':('username')}})
- return HttpResponse(data)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement