#!/usr/bin/python import os, sys, time import commands, re import glob from pysqllib import MySqlAccess if __name__ == '__main__': mySqlHdlr = MySqlAccess('10.6.3.5','root','','flowmon') fileList = glob.glob("/home/ryu/csvfiles/flow*.Pending") for file in fileList: print "loading file %s \n" % (file) mySqlHdlr.load_file(file,'flow_table') os.system('\\rm "%s"' % file) fileList = glob.glob("/home/ryu/csvfiles/total*.Pending") for file in fileList: print "loading file %s \n" % (file) mySqlHdlr.load_file(file,'total_stats_table', ignoreHeader=False) os.system('\\rm "%s"' % file)
sorted_dict_txbytes = sorted(dictTable.items(), key = lambda x: x[1]['tx_bytes'], reverse=True) # print "avg_tx_rate=%u bps, avg_rx_rate=%u bps\n" % (value['tx_bytes']*8/timeInterval, value['rx_bytes']*8/timeInterval) # print "avg_tx_pkt_rate=%u, avg_rx_pkt_rate=%u\n" % (value['tx_pkts']/timeInterval, value['rx_pkts']/timeInterval) if __name__ == "__main__": # read the records of all subscribers in the last 300 secs # aggregate the records based on subscriber ( 2 dictionaries one for tx and another of rx # sort the subscriber list based on tx and rx bytes usage # take the last 10 top subs print "loading the users config" policy = PolicyUser('/home/mravi/dbloader/tf_users.csv') pollInterval = 300; # 120 secs print "connecting to database" mySqlHandler = MySqlAccess('10.6.3.5', 'root','','flowmon') print "connected to database" currTimeStamp = time.time() sqlFetch = "select * from flow_table where LastSeen > %s" args = (currTimeStamp - pollInterval) print "fetch records from database" records = mySqlHandler.get_records(sqlFetch,args) print "Processing all records...., pl wait", len(records) time1 = time.time() currCnt = 0 for record in records: Process_Sub_record(policy,record)