#!/usr/bin/python
import cElementTree as ET
import urllib2
import MySQLdb
print "Content-type: text/html\n"
class xml:
    @staticmethod
 
    def find_text(element):
        if element.text:
            yield element
            for subelement in element:
                for txt in find_text(subelement):
                    yield txt
 
    def read_xml():
        # connect
        db = MySQLdb.connect(host = "localhost", user = "adamplo1", passwd = "U7RJM5HQ", db = "adamplo1_UniProject")
 
        # create a database cursor
        cursor = db.cursor(MySQLdb.cursors.DictCursor)
 
        # execute SQL select statement
        cursor.execute("SELECT * FROM Threshold")
 
        Results = cursor.fetchall()
        error = " "
        feed = urllib2.urlopen("http://server-up.theatticnetwork.net/demo/")
        try:
            tree = ET.parse(feed)
 
        except Exception, inst:
            print "Unexpected error opening %s: %s" % (tree, inst)
 
        root= tree.getroot()
        text = root.getchildren()
 
        for item in text:
            if item.tag =="Memory":
                extra = "Memory"
            elif item.tag == "Network":
                extra = "Network"
            elif item.tag == "Vitals":
                extra = "Vitals"
            elif item.tag == "Hardware":
                extra = "Hardware"
            elif item.tag == "Swap":
                extra = "Swap"
            elif item.tag == "Swapdevices":
                extra = "Swapdevices"
            elif item.tag == "FileSystem":
                extra = "FileSystem"
            else:    
                extra = "Other"
            for element in find_text(item):
                if extra+element.tag.replace(' ','') in Results[0].keys():
                    if element.text >= Results[0][extra+element.tag.replace(' ','')]:
                        error = error + "Error with "+item.tag+" "+element.tag+" value = "+element.text +" \n"
 
                else:
                    continue
        return error
 
 
a = xml()
problem = a.read_xml()
print problem

for element in find_text(item):
    if extra+element.tag.replace(' ','') in Results[0].keys():
        if element.text >= Results[0][extra+element.tag.replace(' ','')]:
            error = error + "Error with "+item.tag+" "+element.tag+" value = "+element.text +" \n"
 
    else:
        continue