def batch_report(begin_day, end_day, non_parallel): """Print a report for each day starting from begin_day to end_day.""" do_batch_alarm_report(eval_datetime(begin_day), eval_datetime(end_day), host_info.address, host_info.database, host_info.description, parallel=not non_parallel)
def operator_messages(begin_time, end_time, text, utc, show): """Query db for operator messages.""" query = om_query_builder(eval_datetime(begin_time), eval_datetime(end_time), text, utc) if show: print(query) return try: toc = tic() w = wincc(host_info.address, host_info.database) w.connect() w.execute(query) w.print_operator_messages() print("Fetched data in {time}.".format(time=round(toc(), 3))) except WinCCException as e: print(e) print(traceback.format_exc()) finally: w.close()
def alarms(begin_time, end_time, text, utc, show, state, priority, priority2, report, report_hostname): """Read alarms from given host in given time.""" query = alarm_query_builder(eval_datetime(begin_time), eval_datetime(end_time), text, utc, state, priority, priority2) if show: print(query) return try: toc = tic() w = wincc(host_info.address, host_info.database) w.connect() w.execute(query) if report: alarms = w.create_alarm_record() if report_hostname: host_description = report_hostname else: host_description = host_info.description if not end_time: end_time = datetime_to_str_without_ms(datetime.now()) generate_alarms_report(alarms, begin_time, end_time, host_description, text) print(unicode(alarms)) else: w.print_alarms() print("Fetched data in {time}.".format(time=round(toc(), 3))) except WinCCException as e: print(e) print(traceback.format_exc()) finally: w.close()
def alarm_report2(begin_day, end_day, timestep): """Generate report(s) for known host.""" do_batch_alarm_report(eval_datetime(begin_day), eval_datetime(end_day), host_info.address, host_info.database, host_info.description, timestep)
def operator_messages_report(begin_time, end_time, cache, use_cached): """Print report of operator messages for given host in given time.""" do_operator_messages_report(eval_datetime(begin_time), eval_datetime(end_time), host_info.address, host_info.database, cache, use_cached)
def alarm_report(begin_time, end_time, cache, use_cached): """Print report of alarms for given host in given time.""" do_alarm_report(eval_datetime(begin_time), eval_datetime(end_time), host_info.address, host_info.database, cache, use_cached)