#!/usr/bin/python2.6
import yaml
import subprocess
import MySQLdb as mdb
import sys
    
def __run__(params):

    ddd = int(params.get('ddd'))
    warning = int(params.get('warning'))
    critical = int(params.get('critical'))

    con = mdb.connect('db1.locawebtelecom.com.br','nagioscheck','nagioscheck6969','pabxmanagement');

    with con:

        cur=con.cursor()
        cur.execute("select count(*) from voipregistration where ddd=%s and companyname is null and proprietary is false and unavailable is false;",(ddd))
        data = cur.fetchall()

        for row in data:
            result = row[0]

        if result > warning :
            return [0, '%s disponiveis DDRs para o DDD %s' % (result,ddd)]
        elif  warning >= result >= critical :
            return [1, '%s disponiveis DDRs para o DDD %s' % (result,ddd)]
        else :
            return [2, '%s disponiveis DDRs para o DDD %s' % (result,ddd)]