mherger wrote:
> > I wonder if there is a possibilty to use the queries I've built from
> > outside the LMS UI via a bash script.
>
> Are the queries SQL?
Yes sure. They're just wrapped inside the XML that is stored by the
Database Query plugin, looks like that:
Code:
--------------------
<?xml version="1.0" encoding="utf-8"?>
<databasequery>
<template>
<id>sqlquery.xml</id>
<parameter type="text"
id="queryname"><value>01-testTrackPaths</value></parameter>
<parameter type="text" id="querydescription"></parameter>
<parameter type="text" id="querysql" rawvalue="1"><value>--
URLs ausgeben, von Zufallsmix ausgeschlossene Genres
--
select distinct url
from genre_track
inner join tracks on
(
genre_track.track = tracks.id
)
inner join genres on
(
genre_track.genre = genres.id
)
where
genres.name not in
(
"Giftschrank",
"Werbung"
)
--LIMIT 20
;;
</value></parameter>
</template>
</databasequery>
--------------------
AND: Good question, I have an idea where you are pointing me to: Avoid
the overhead of the Database Query plugin completely and query against
the database directly via SQLite client, right?
Is there a good starting point in the Wiki somewhere for that approach?
------------------------------------------------------------------------
tuxEvangelist's Profile: http://forums.slimdevices.com/member.php?userid=72340
View this thread: http://forums.slimdevices.com/showthread.php?t=115525
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
