#!/usr/bin/env python # import sys import os import re import time import datetime import pprint dbuser="root" dbpass="" dbhost="localhost" dbname="stats" os.environ['PYTHON_EGG_CACHE'] = '/tmp' import MySQLdb db=MySQLdb.connect(host=dbhost, user=dbuser, passwd=dbpass, db=dbname, port=int(3306)) cursor = db.cursor() def process_cgi_request(): """ When calling from CGI """ output = "Content-type:text/html\r\n\r\n" print output def generate(nodes, data): today = datetime.datetime.today() now = int(time.time())/86400 tmp="" """ Main overview page """ items = {'root' : "." } output = """
""" for i in range(0, 8): yesterday = today - datetime.timedelta(days=i) output += " | %i | " % yesterday.day for node in nodes: if tmp != node[0]: output += "|
%s | " % node[0] tmp = node[0] for i in reversed(range(now-7,now+1)): try: dhcp = data[0][node[0]][i] except: dhcp = 0 try: captive = data[1][node[0]][i] except: captive = 0 try: proxy = data[2][node[0]][i] except: proxy = 0 if dhcp or captive or proxy: output += "%s / %s / %s | " % (dhcp, captive,proxy) else: output += "" output += " |