Page 1 of 1
Star every song in a playlist

Posted:
Thu Mar 29, 2018 8:06 pm
by jeffcdo
I have a playlist of "top rated" songs brought in from another application. I'd like to star every one of these songs, is there a way to do this all at once?
Re: Star every song in a playlist

Posted:
Fri Mar 30, 2018 4:38 am
by acroyear
not at present with the main app. it is something I'm considering with the playlist editor tool i'm writing, but i'm still a few weeks away from release. slow going given the day job. :/
Re: Star every song in a playlist

Posted:
Fri Mar 30, 2018 9:03 am
by jeffcdo
I came up with a crude old-fashioned solution..I recorded a macro of a mouse click starring an item then scrolling to the next star on the playlist, then set the macro to play 2000 times overnight (the number of items in my playlist). Clunky but it worked.
I’ll be looking forward to that playlist editor though!
Re: Star every song in a playlist

Posted:
Sun Sep 09, 2018 5:25 pm
by Jägs
An "easier" way to do this would be to write a SQL query to do so and use the db.view page to do this. That page is located at the URL you access Subsonic with /db.view at the end of it.
Here's the Subsonic DB schema:
https://www.reddit.com/r/subsonic/comme ... le_schema/
Re: Star every song in a playlist

Posted:
Sat Jan 12, 2019 8:53 pm
by jeffcdo
I was never able to get this to work as expected. Can somebody provide an example of a SQL query that would star every song in a playlist?
Re: Star every song in a playlist

Posted:
Sun Feb 17, 2019 2:24 pm
by CasN
depends a bit on the database you are using.
For each song in thy playlist_file table and entry must be created in the starred_media_file_table.
So reate an insert statemnet based upon querying the playlist table
Re: Star every song in a playlist

Posted:
Wed Feb 20, 2019 4:29 pm
by mwpmorris
jeffcdo wrote:I was never able to get this to work as expected. Can somebody provide an example of a SQL query that would star every song in a playlist?
Have a look in the following thread:
http://forum.subsonic.org/forum/viewtopic.php?f=6&t=17096There's a post in there that details the SQL query to issue whereby you can take an existing playlist and star every item within it.
Re: Star every song in a playlist

Posted:
Fri Feb 22, 2019 6:55 am
by jeffcdo
Very useful thread, thank you for sharing!