#!/bin/sh

. ./paths

# print headers
echo 'Content-Type: text/xml'
echo 'Cache-control: no-cache'
echo 'Cache-control: no-store'
echo 'Pragma: no-cache'
echo 'Expires: 0'
echo ''


# ARGUMENTS:
# db_sql  = sql-query to be executed in advance (used for including a second db-file)
# sql = sql-query to execute 

db_short=`echo $QUERY_STRING |  awk -F '&' '{print $1}' `
query=`echo $QUERY_STRING |  awk -F '&' '{print $2}' `

if [ "$db_short" = "epg" ]; then
 db_sql="ATTACH  DATABASE \"$PATH_DBEPG_DAT\" AS epg ;"
fi

# print XML
echo '<?xml version="1.0" encoding="UTF-8"?>'
echo '<result>'
sqlite3 -separator "=" -header $PATH_DB_DAT "$db_sql $query" | awk -F '=' -f toxml.awk
echo '</result>'
