#!/usr/bin/python
import os
import MySQLdb
import yaml

def __run__(params):
    try:
        conn_m = MySQLdb.connect('10.50.0.51', 'isr', 'frcds345mkj')
        conn_m.select_db('locamail')

        conn    = MySQLdb.connect('nelson0019.email.locaweb.com.br', 'isr', 'frcds345mkj')
        conn.select_db('locamail')
        cursor  = conn.cursor()
        query = "select count(email.username) from servidores,email join dominio using (id_dominio) where dominio.servidor = servidores.servidor and email.status=5 group by email.username"
        resultado=  cursor.execute(query)
        cursor_m  = conn_m.cursor()
        conn.close()
        accounts_deleted_warning  = int(params.get('accounts_deleted_warning',20))
        accounts_deleted_critical = int(params.get('accounts_deleted_critical',40))

        if resultado >= accounts_deleted_warning:
            if resultado >= accounts_deleted_critical:
                return [2,"Critical %s contas para deletar" % (resultado)]
            else:
                return [1,"warning %s contas para deletar" % (resultado)]
        else:
            return [0,"OK %s contas para deletar" % (resultado)]

    except Exception, e:
        return [2, e]