DJanGo wrote:
> @dolo:
> i am old & rusty.
> please open another thread (in the german section?)
>
> https://www.youtube.com/watch?v=YP5fkvNCeXw
Sind wir das nicht alle? :D
''
(https://forums.slimdevices.com/showthread.php?109913-Virtual-Libraries-Views-Was-ist-m%F6glich)
QLMS
erland wrote:
> I think the information mentioned on the page you refer to are still
> accurate, at least that's what all my plugins (Custom Scan, Multi
> Library, Custom Browse, SQL Playlist, TrackStat, Database Query, Dynamic
> Playlist) are based on.
> Possibly LMS 7.9 might have added some
erland wrote:
> You can do it with exists directive and an inner select, something like
> this:
>
> >
Code:
> > -- PlaylistName:Random temp
> -- PlaylistGroups:
> select tracks.url from tracks
> join genre_track on
> tracks.id=genre_track.track
RobbH wrote:
> Speaking of complicated, if I attempt to conquer SQL, I will also need
> to familiarize myself with the database schema. Where can I find that
> documented? This 'page'
> (http://wiki.slimdevices.com/index.php/SlimServerDatabaseStructure)
> seems not have been updated since 2010,
RobbH wrote:
> My goal is to set up a playlist that only plays files that have both
> 'Jazz' and 'Holiday' tags. All attempts so far have failed miserably.
>
You can do it with exists directive and an inner select, something like
this:
Code:
-- PlaylistName:Random
DJanGo wrote:
> Take a look at http://lms.ip:9000/settings/server/performance.html?
> and change 100 to whatever
>
> And as dolodobendan stated:
> you can also use non std. genres like *F*&*D* for *F*unk and *D*ance.
> Thats the way i am using as well.
>
> That using a special genre is really
RobbH wrote:
> Unfortunately, Random Mix seems not to create playlists longer than 100
> tracks.
Take a look at http://lms.ip:9000/settings/server/performance.html?
and change 100 to whatever
And as dolodobendan stated:
you can also use non std. genres like *F*&*D* for *F*unk and *D*ance.
dolodobendan wrote:
> That depends.
>
> My approach lets me:
>
> + use my own tags that would not be scanned otherwise (like WORK,
> RECORDING etc.)
> + use mixed tags like "Classical;Piano Concertos"
> + create a library "Classical" that contains all classical genres
> + create my own browse
DJanGo wrote:
> In Theorie you build a library only with Tracks that have eg. Country.
> Whenever you now search for eg. Instrumental you're shure its country
> AND Instrumental.
> But you didnt need the plugin, with advanced search you can build your
> own virt. library by mouse klicking...
>
bradcook wrote:
> I dont have the SQL schema to hand - but how are the genres stored for
> each track ?
like this:
> .schema genre_track
> CREATE TABLE genre_track (
> genre int(10),
> track int(10),
> *PRIMARY KEY (genre,track),*
> FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE
I dont have the SQL schema to hand - but how are the genres stored for
each track ?
If I was writing such a query where I needed to check multiple items I
would join the table to itself on its primary key
So something like
select item from track1
join track2
on track1.key = track2.key
and
@dolo:
i am old & rusty.
please open another thread (in the german section?)
https://www.youtube.com/watch?v=YP5fkvNCeXw
DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516
View this thread:
mea culpa,
i am rusty and old and i am not using Earlands plugin - just sqlite.
How to find a match between FUNK and Dance?
Code:
sqlite> select id from genres where name like 'Funk' or name like 'Dance';
18
28
In this case Funk is 18
DJanGo wrote:
> In Theorie you build a library only with Tracks that have eg. Country.
> Whenever you now search for eg. Instrumental you're shure its country
> AND Instrumental.
> But you didnt need the plugin, with advanced search you can build your
> own virt. library by mouse klicking...
>
RobbH wrote:
> One more question for you! I do not understand the advantage of using
> the Library Demo plugin, instead of the plugins you use. Would it make
> sense to consider using those three plugins?
That depends.
My approach lets me:
+ use my own tags that would not be scanned
RobbH wrote:
> If I understand what you're saying, and I may not, doing what I want
> with SQL would require at least two steps: first, select for files where
> genre="Country", then select from files selected the first time for
> files where genre="Instrumental". I think I've seem some
RobbH wrote:
> One more question for you! I do not understand the advantage of using
> the Library Demo plugin, instead of the plugins you use. Would it make
> sense to consider using those three plugins?
In Theorie you build a library only with Tracks that have eg. Country.
Whenever you now
dolodobendan wrote:
> Don't overthink it.
>
> While I do follow a different approach (Custom Scan, Custom Browse &
> Multi Library), I think what you're trying to achieve might be possible
> with the '\"Sub-Library Demo\" Plugin and some tinkering'
>
DJanGo wrote:
> Thats a really hard one...
> Because of the DB schema you cant (IMHO) search for a track with two
> genres...
> In (my) Theorie you need a temp. table filled with Country and that
> temp. Table must be checked for a match Genre like Instrumental to get
> to your selection.
>
>
RobbH wrote:
>
> Does anyone know if this sort of selection is possible?
Thats a really hard one...
Because of the DB schema you cant (IMHO) search for a track with two
genres...
In (my) Theorie you need a temp. table filled with Country and that
temp. Table must be checked for a match Genre
dolodobendan wrote:
> Don't overthink it.
>
> While I do follow a different approach (Custom Scan, Custom Browse &
> Multi Library), I think what you're trying to achieve might be possible
> with the '\"Sub-Library Demo\" Plugin and some tinkering'
>
RobbH wrote:
> Thanks to all who have read my post! With well over a hundred views and
> no responses, I suspect my question is just too obscure. Maybe nobody
> has tried to do this before.
>
> But it has occurred to me that there might be other reasons for the lack
> of response:
>
> 1.
Thanks to all who have read my post! With well over a hundred views and
no responses, I suspect my question is just too obscure. Maybe nobody
has tried to do this before.
But it has occurred to me that there might be other reasons for the lack
of response:
1. Maybe I did not describe the
Running LMS 7.9.1 - 1522157629 on Debian 8 X86_64, and I have recently
discovered SQL Playlist. I see some references in the forum saying that
it does not work well with recent versions of LMS. So far it is working
well for me, but I am struggling to get it to do some things.
I do not know SQL,
24 matches
Mail list logo
