[HOW TO] Library Node Examples
First, thx @the_other_guy , but I have to tell that your posts often are hard to understand Wink
(2019-12-09, 15:37)the_other_guy Wrote: <path>musicdb://genres/?sourceid=5</path>  change sourceid to genreid
open genres add to favourites open C:\Users\*****\AppData\Roaming\Kodi\userdata\favourites.xml
<favourite name="Comedy">ActivateWindow(10502,&quot;musicdb://genres/4/&quot;,return)</favourite>

musicdb://genres/4
<?xml version='1.0' encoding='UTF-8'?>
<node type="folder">
    <label>test</label>
    <path>musicdb://genres/?genreid=4</path>
</node>

Yes, that would help show a specific genre, but I would like to have all genres for a specific path or source. A node like this:
Code:
<?xml version='1.0' encoding='UTF-8'?>
<node type="filter">
<label>Genre-test</label>
<content>artists</content>
<group>genres</group>
<rule field="path" operator="contains">
<value>/media/audioplay/</value></rule>
</node>
Takes 7 minutes and it results in a mostly empty genres not appearing on /media/audioplay/ ;(
Even running the query on the DB-host itself (MariaDB, core i5-8400, SSD) gives:
Code:
MariaDB [headlesstest-audio72]> SELECT genre.* FROM genre JOIN song_genre ON song_genre.idGenre = genre.idGenre JOIN songview ON songview.idSong = song_genre.idSong JOIN song_artist ON song_artist.idSong = songview.idSong JOIN artistview ON artistv
iew.idArtist = song_artist.idArtist WHERE ((( (EXISTS (SELECT DISTINCT song_artist.idArtist FROM song_artist JOIN song ON song.idSong = song_artist.idSong JOIN path ON song.idpath = path.idpath WHERE song_artist.idArtist = artistview.idArtist AND p
ath.strPath LIKE '%/media/audioplay/%'))))) AND (genre.strGenre != '') GROUP BY genre.idGenre;
....
308 rows in set (7 min 33.934 sec)
Reply
 
Thread Rating:
  • 5 Vote(s) - 3.8 Average


Messages In This Thread
[HOW TO] Library Node Examples - by zag - 2016-01-22, 11:47
RE: Library Node Examples - by DaveBlake - 2016-01-22, 13:13
RE: Library Node Examples - by zag - 2016-01-22, 15:13
RE: Library Node Examples - by DaveBlake - 2016-01-24, 11:36
RE: Library Node Examples - by tkgafs - 2016-01-26, 11:21
RE: Library Node Examples - by DarkHelmet - 2016-01-26, 13:09
RE: Library Node Examples - by zag - 2016-01-26, 13:14
RE: Library Node Examples - by DarkHelmet - 2016-01-26, 14:42
RE: Library Node Examples - by zag - 2016-01-26, 14:52
RE: Library Node Examples - by annejones101 - 2020-02-15, 11:03
RE: Library Node Examples - by tkgafs - 2016-01-31, 12:06
RE: Library Node Examples - by DaveBlake - 2016-01-31, 12:34
RE: Library Node Examples - by DarkHelmet - 2016-01-31, 14:38
RE: Library Node Examples - by DaveBlake - 2016-01-31, 14:43
RE: Library Node Examples - by DaveBlake - 2016-01-31, 14:45
RE: Library Node Examples - by zag - 2016-01-31, 14:49
RE: Library Node Examples - by YamYam - 2020-03-10, 11:08
RE: [HOW TO] Library Node Examples - by zag - 2016-01-31, 15:33
RE: [HOW TO] Library Node Examples - by zag - 2016-01-31, 16:08
RE: [HOW TO] Library Node Examples - by zag - 2016-02-03, 10:45
RE: [HOW TO] Library Node Examples - by zag - 2016-02-24, 13:43
RE: [HOW TO] Library Node Examples - by zag - 2016-02-26, 17:36
RE: [HOW TO] Library Node Examples - by zag - 2016-02-27, 15:41
RE: [HOW TO] Library Node Examples - by zag - 2016-03-30, 22:12
RE: [HOW TO] Library Node Examples - by zag - 2016-03-31, 11:04
RE: [HOW TO] Library Node Examples - by zag - 2016-05-23, 21:29
RE: [HOW TO] Library Node Examples - by zag - 2016-05-23, 22:07
RE: [HOW TO] Library Node Examples - by Zani - 2017-10-25, 14:45
RE: [HOW TO] Library Node Examples - by Zani - 2017-10-30, 14:38
RE: [HOW TO] Library Node Examples - by Zani - 2017-10-31, 15:56
RE: [HOW TO] Library Node Examples - by Er1c - 2018-05-12, 07:02
RE: [HOW TO] Library Node Examples - by DaVu - 2018-11-06, 15:53
RE: [HOW TO] Library Node Examples - by Alion - 2018-11-06, 18:09
RE: [HOW TO] Library Node Examples - by ronie - 2019-02-08, 12:20
RE: [HOW TO] Library Node Examples - by ronie - 2019-02-08, 13:19
RE: [HOW TO] Library Node Examples - by PatK - 2019-06-13, 19:49
RE: [HOW TO] Library Node Examples - by PatK - 2019-06-16, 05:31
RE: [HOW TO] Library Node Examples - by PatK - 2019-06-17, 16:40
[HOW TO] Library Node Examples - by Finchy - 2019-06-21, 10:34
[HOW TO] Library Node Examples - by Finchy - 2019-06-21, 20:46
RE: [HOW TO] Library Node Examples - by PatK - 2019-06-23, 04:51
RE: [HOW TO] Library Node Examples - by PatK - 2019-06-24, 00:04
RE: [HOW TO] Library Node Examples - by PatK - 2019-06-24, 18:38
RE: [HOW TO] Library Node Examples - by TimoJ - 2020-01-01, 19:58
RE: [HOW TO] Library Node Examples - by PatK - 2019-12-08, 22:38
RE: [HOW TO] Library Node Examples - by Uatschitchun - 2019-12-09, 18:16
RE: [HOW TO] Library Node Examples - by TimoJ - 2020-01-05, 15:21


Logout Mark Read Team Forum Stats Members Help
[HOW TO] Library Node Examples3.85
This forum uses Lukasz Tkacz MyBB addons.