def get(self):
self.write(
self.render_string("bare_header.html", title="Adding Groups"))
self.write("<h2>Associating Groups</h2>")
self.write("<h3>These Songs:</h3><ul>")
songs = cache.get_user(self.user, "admin_associate_groups_songs") or []
for song_id in songs:
song = Song.load_from_id(song_id)
self.write("<li>%s</li>" % song.data['title'])
self.write("</ul><h3>Songs In These Albums:</h3><ul>")
albums = cache.get_user(self.user,
"admin_associate_groups_albums") or []
for album_set in albums:
album = Album.load_from_id(album_set[0])
self.write(
"<li>%s (%s)</li>" %
(album.data['name'], config.station_id_friendly[album_set[1]]))
self.write("</ul><select id='associate_group_id'>")
for row in db.c.fetch_all(
"SELECT group_id, group_name FROM r4_groups ORDER BY group_name"
):
self.write("<option value='%s'>%s</option>" %
(row['group_id'], row['group_name']))
self.write("</select><br />")
self.write(
"<button onclick=\"window.location.href='/admin/tools/associate_groups_finish/' + document.getElementById('associate_group_id').value\">Associate</button>"
)
self.write(
"<br /><br /><a href='/admin/tools/associate_groups_cache_reset'>Reset the list above.</a>"
)
self.write(self.render_string("basic_footer.html"))
def get(self):
self.write(self.render_string("bare_header.html", title="Adding Groups"))
self.write("<h2>Associating Groups</h2>")
self.write("<h3>These Songs:</h3><ul>")
songs = cache.get_user(self.user, "admin_associate_groups_songs") or []
for song_id in songs:
song = Song.load_from_id(song_id)
self.write("<li>%s</li>" % song.data['title'])
self.write("</ul><h3>Songs In These Albums:</h3><ul>")
albums = cache.get_user(self.user, "admin_associate_groups_albums") or []
for album_set in albums:
album = Album.load_from_id(album_set[0])
self.write("<li>%s (%s)</li>" % (album.data['name'], config.station_id_friendly[album_set[1]]))
self.write("</ul><select id='associate_group_id'>")
for row in db.c.fetch_all("SELECT group_id, group_name FROM r4_groups ORDER BY group_name"):
self.write("<option value='%s'>%s</option>" % (row['group_id'], row['group_name']))
self.write("</select><br />")
self.write("<button onclick=\"window.location.href='/admin/tools/associate_groups_finish/' + document.getElementById('associate_group_id').value\">Associate</button>")
self.write("<br /><br /><a href='/admin/tools/associate_groups_cache_reset'>Reset the list above.</a>")
self.write(self.render_string("basic_footer.html"))
import argparse
from libs import config
from libs import db
from rainwave.playlist import Album
if __name__ == "__main__":
parser = argparse.ArgumentParser(description="Rainwave API server.")
parser.add_argument("--config", default=None)
args = parser.parse_args()
config.load(args.config)
db.connect()
albums = db.c.fetch_list("SELECT album_id FROM r4_albums")
i = 0
for album_id in albums:
txt = "Album %s / %s" % (i, len(albums))
txt += " " * (80 - len(txt))
print "\r" + txt,
i += 1
a = Album.load_from_id(album_id)
a.reconcile_sids()
a.update_all_user_ratings()
a.update_rating()
#!/usr/bin/env python
import argparse
from libs import config
from libs import db
from rainwave.playlist import Album
if __name__ == "__main__":
parser = argparse.ArgumentParser(
description="Recalculates all album ratings, both global ratings and for every user. Takes a while."
)
parser.add_argument("--config", default=None)
args = parser.parse_args()
config.load(args.config)
db.connect()
albums = db.c.fetch_list("SELECT album_id FROM r4_albums")
i = 0
for album_id in albums:
txt = "Album %s / %s" % (i, len(albums))
txt += " " * (80 - len(txt))
print("\r" + txt, end="")
i += 1
a = Album.load_from_id(album_id)
a.reconcile_sids()
a.update_all_user_ratings()
a.update_rating()