def one_collection_delete(collection_id): collection = Collection.query.get_or_404(collection_id) ids = split_reasonable(request.form.get('songs', None), ',') ids_as_ints = map(lambda s: int(s), ids) for id_as_int in ids_as_ints: SongCollection.query.filter_by(collectionId=collection_id, songId=id_as_int).delete() db.session.commit() return 'ok'
def one_collection_put(collection_id): collection = Collection.query.get_or_404(collection_id) ids = split_reasonable(request.form.get('songs', None), ',') ids_as_ints = map(lambda s: int(s), ids) for id_as_int in ids_as_ints: #app.logger.error('Trying to add %s to album %s', str(id_as_int), str(album_id)) relation = SongCollection.query.filter_by(collectionId=collection_id, songId=id_as_int).first() song = Song.query.get(id_as_int) if relation == None and song != None: relation = SongCollection(collection_id, id_as_int) db.session.add(relation) db.session.commit() return 'ok'
def one_playlist_put(playlist_id): ps = Playlist.query.get_or_404(playlist_id) ids = split_reasonable(request.form.get('songs', None), ',') ids_as_ints = map(lambda s: int(s), ids) ps_count = SongPlaylist.query.filter_by(playlistId=playlist_id).count() for id_as_int in ids_as_ints: song = Song.query.get(id_as_int) if song != None: relation = SongPlaylist(playlist_id, id_as_int, ps_count) db.session.add(relation) ps_count += 1 db.session.commit() return 'ok'
def songs_with_collections(artist_id, album_id, order, asc, start, length, collection_ids): ids = split_reasonable(collection_ids, '/') ids_as_ints = map(lambda s: int(s), ids) return songs_get(artist_id, album_id, order, asc, start, length, ids_as_ints)
def artists_with_colls(asc, start, length, collection_ids): ids = split_reasonable(collection_ids, '/') ids_as_ints = map(lambda s: int(s), ids) return artists_get(asc, start, length, ids_as_ints)