Page 1 of 1

Star every song in a playlist

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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=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.

Re: Star every song in a playlist

PostPosted: Fri Feb 22, 2019 6:55 am
by jeffcdo
mwpmorris wrote: 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!