Star every song in a playlist

General discussions.

Moderator: moderators

Star every song in a playlist

Postby jeffcdo » Thu Mar 29, 2018 8:06 pm

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?
User avatar
jeffcdo
 
Posts: 5
Joined: Thu Mar 29, 2018 7:41 pm

Re: Star every song in a playlist

Postby acroyear » Fri Mar 30, 2018 4:38 am

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. :/
--
Joe Shelby
http://subfiresuite.com/
http://subfireplayer.net/
User avatar
acroyear
 
Posts: 779
Joined: Wed Mar 27, 2013 8:05 pm
Location: Northern, VA

Re: Star every song in a playlist

Postby jeffcdo » Fri Mar 30, 2018 9:03 am

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!
User avatar
jeffcdo
 
Posts: 5
Joined: Thu Mar 29, 2018 7:41 pm

Re: Star every song in a playlist

Postby Jägs » Sun Sep 09, 2018 5:25 pm

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/
Jägs
 
Posts: 109
Joined: Wed Apr 06, 2011 9:52 pm

Re: Star every song in a playlist

Postby jeffcdo » Sat Jan 12, 2019 8:53 pm

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?
User avatar
jeffcdo
 
Posts: 5
Joined: Thu Mar 29, 2018 7:41 pm

Re: Star every song in a playlist

Postby CasN » Sun Feb 17, 2019 2:24 pm

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
CasN
 
Posts: 35
Joined: Wed Jan 12, 2011 2:24 pm

Re: Star every song in a playlist

Postby mwpmorris » Wed Feb 20, 2019 4:29 pm

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.
mwpmorris
 
Posts: 12
Joined: Tue Jan 03, 2017 2:21 pm

Re: Star every song in a playlist

Postby jeffcdo » Fri Feb 22, 2019 6:55 am

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!
User avatar
jeffcdo
 
Posts: 5
Joined: Thu Mar 29, 2018 7:41 pm


Return to General

Who is online

Users browsing this forum: No registered users and 8 guests