#!/usr/bin/python2.6

import pymssql
from ConfigParser import SafeConfigParser
import sys
import datetime

def __run__(params):
    sys_time = datetime.datetime.now().hour
    global cfg
    cfg = SafeConfigParser()
    cfg.read('/usr/lib/check_mk_agent/config_teleopti_monitor.cfg')
    time=dbconnect()
    check_hour = sys_time - time
    if check_hour >= 1 and check_hour <= 5:
        return[0, "OK - Dados Ok"]  
    else:
        return[2, "Problema no processamento dos dados"]

def dbconnect():
    conn = pymssql.connect(host=cfg.get('database','host'), user=cfg.get('database','user'), password=cfg.get('database','password'), database=cfg.get('database','database'))
    cur = conn.cursor()
    cur.execute('select top 1 SUBSTRING(time,1,2) from t_log_NET_data_teleopti_queue_data order by tstamp desc')
    for row in cur:
        time = row[0]
    return int(time) - 1