#!/usr/bin/python
# MythTVDB.py: Class to connect to MythTV database

# Imports
import os, sys
from xml.dom import minidom
import MySQLdb

class MythTVDB:
    def getText(self, nodelist):
        rc = ""
        for node in nodelist:
            if node.nodeType == node.TEXT_NODE:
                rc = rc + node.data
        return rc

    def OpenConnection(self):
        """OpenConnection -- parse the MythTV config file and open a connection to the MySQL database"""
        # Load the text configuration file
        self.config_values = {}
        home = os.environ.get('HOME')
        try:
            filen = open(home + '/.mythtv/config.xml')
            xmlobj = minidom.parse(filen).documentElement
        except:
            print "Could not read MythTV configuration %s" % filen
            sys.exit(1)

        configtags = xmlobj.getElementsByTagName('DefaultBackend')
        for node in configtags:
            hostname = node.getElementsByTagName('DBHostName')
            for hn in hostname:
                self.config_values['DBHostName'] = self.getText(hn.childNodes)
            username = node.getElementsByTagName('DBUserName')
            for un in username:
                self.config_values['DBUserName'] = self.getText(un.childNodes)
            password = node.getElementsByTagName('DBPassword')
            for pw in password:
                self.config_values['DBPassword'] = self.getText(pw.childNodes)
            dbname = node.getElementsByTagName('DBName')
            for db in dbname:
                self.config_values['DBName'] = self.getText(db.childNodes)
       
        # Open the DB connection
        try:
            self.db_connection = MySQLdb.connect(
            host = self.config_values['DBHostName'],
            user = self.config_values['DBUserName'],
            passwd = self.config_values['DBPassword'],
            db = self.config_values['DBName'])
        except:
            print "Could not connect to database"
            sys.exit(1)
        return self.db_connection

from MythTVDB import *

db = MythTVDB()
db_connection = db.OpenConnection()
the_query = "select data from settings where value='VideoDefaultPlayer';"
cursor = db_connection.cursor()
cursor.execute(the_query)
row = cursor.fetchone()
player = row[0]
cursor.close()