def tag(name=None):
sort_by = request.args.get('sort_by')
if sort_by == 'play_count':
sort_by = [Artist.playcount.desc()]
elif sort_by == 'local_play_count':
sort_by = [Artist.local_playcount.desc()]
elif sort_by == 'tag_strength':
sort_by = [desc('strength')]
else:
sort_by = [desc('strength'), Artist.local_playcount.desc()]
name = name.lower()
top_artists = (
db.session.query(Artist.name, Artist.tags[name].cast(Integer).label('strength'), Artist.local_playcount, Artist.playcount)
.filter(Artist.tags.has_key(name))
.order_by(*sort_by)
.all()
)
top_artists = enumerate(top_artists, start=1)
return render_template(
'meta/tag.html',
tag=tag,
top_artists=top_artists,
)
评论列表
文章目录