SUBNET = '192.168.2.' logPath = '/home/trafdata/net-acct.log' #*************************************************** db = DATABASES['default'] conn = psycopg2.connect(('dbname = %s user = %s password = %s host = %s') % \ (db['NAME'], db['USER'], db['PASSWORD'], db['HOST'])) cur = conn.cursor() if os.access(logPath, os.F_OK): os.rename(logPath, logPath + '.work') wfHandler = open(logPath + '.work', 'r') for line in wfHandler: line = line.split('\t') date = timestampFromDate(dateFromTimestamp(int(line[0]))) srcIp = line[2] srcPort = int(line[3]) dstIp = line[4] dstPort = int(line[5]) byte = int(line[6]) inByte = outByte = 0 if SUBNET in srcIp: inByte = byte ip = srcIp port = dstPort flag = True elif SUBNET in dstIp: outByte = byte ip = dstIp port = srcPort
def __transformDateInRec(self, rec): rec['_date'] = utils.dateFromTimestamp(rec['_date'], False, 'mm/dd/yyyy') return rec