Star every song in a playlist

[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?

[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. :/

[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!

[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/

[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?

[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

[mwpmorris]

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=17096

There'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.

[jeffcdo]

Have a look in the following thread:
http://forum.subsonic.org/forum/viewtopic.php?f=6&t=17096
There'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.

Very useful thread, thank you for sharing!