2008-08-11, 05:38
I just submitted a patch to allow files to be queued using SQL
http://trac.xbmc.org/ticket/4482
From ticket
Reason for the patch is I'm currently writing a iTunes 'Remote' clone iPhone app for XBMC.
It uses the Library exclusively for grabbing the list of albums, artist, songs etc
I wanted to be able to support adding a large number of songs, but also adding them based on genre, composer etc.
Using AddToPlaylist was going to be much too inefficient here, so my preferred way was to have the server add the files based on an SQL statement..
http://trac.xbmc.org/ticket/4482
From ticket
Code:
Added support for adding files from the library to the playlist queue using SQL statements.
QueueMusicDatabase?
* parameter = SQL Statement. Must only return one column, which is the path & filename to queue on the music playlist (0)
Example:
http://127.0.0.1:8080/xbmcCmds/xbmcHttp?command=QueueMusicDatabase¶meter=select%20strPath%20%20strFileName%20from%20songview
QueueVideoDatabase?
* parameter = SQL Statement. Must only return one column, which is the path & filename to queue on the video playlist (1)
Example
http://127.0.0.1:8080/xbmcCmds/xbmcHttp?command=QueueVideoDatabase¶meter=select%20strPath%20%20strFileName%20from%20movieview
Reason for the patch is I'm currently writing a iTunes 'Remote' clone iPhone app for XBMC.
It uses the Library exclusively for grabbing the list of albums, artist, songs etc
I wanted to be able to support adding a large number of songs, but also adding them based on genre, composer etc.
Using AddToPlaylist was going to be much too inefficient here, so my preferred way was to have the server add the files based on an SQL statement..