#!/usr/bin/python

import os
import MySQLdb
import cgi, cgitb

DB_HOST = 'localhost'
DB_USERNAME = 'vuadserver'
DB_PASSWORD = 'vubites'
DB_NAME = 'ADSERVER'

form = cgi.FieldStorage()
channel_id  = form.getvalue('channel')

cursor = ''

dbQuery = "SELECT DISTINCT ONAIR_REFERENCE FROM ADSERVER.INSERTIONJOB WHERE SERVICE_FK_ID IN(SELECT ID FROM ADSERVER.SERVICE WHERE CHANNEL_FK_ID='%s') AND ONAIR_REFERENCE != 'NOREF';"

try:
    db = MySQLdb.connect(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME)
except MySQLdb.Error, error:
    print "==> Could not connect to database: %s" % str(error)
else:
    cursor = db.cursor()

tapeIdList = []
if cursor:
    try:
        cursor.execute(dbQuery % channel_id)
    except MySQLdb.Error, error:
        print "==> Could not execute db read query: %s" % str(error)
    else:
        tapeIdList = [item[0] for item in cursor.fetchall()]
print "Content-type:text/html\r\n"
print ','.join(tapeIdList)