def dumpToImpala(self, pcap_data, src='/tmp/test.pcap'):
print 'dumpToImpala'
sm = StoreManager('ast12.recerca.intranet.urv.es',
21050,
'lab144',
'lab144')
sm.connect()
sm.execute('use benchbox')
for idx, data in pcap_data:
ts = '{},{}'.format(idx.getts()[0], idx.getts()[1] )
ether = dpkt.ethernet.Ethernet(data)
if ether.type != dpkt.ethernet.ETH_TYPE_IP: raise
ip = ether.data
#print ip.data
dst = socket.inet_ntoa(ip.dst)
src = socket.inet_ntoa(ip.src)
udp = ip.data
line = (ts, src, udp.sport, dst, udp.dport, ip.v, ip.len)
insert_into_logger = "insert into logger_pcap values ('{}', '{}', '{}', {}, {}, {}, {})".format(ts,
src,
dst,
udp.sport,
udp.dport,
ip.v,
ip.len)
sm.execute(insert_into_logger)
sm.quit()
def setLoggerId(self, dummy_hostname, pc_server_name, profile, test_definition):
self.logger_id = time()
self.hostname = dummy_hostname
sm = StoreManager('ast12.recerca.intranet.urv.es',
21050,
'lab144',
'lab144')
sm.connect()
sm.execute('use benchbox')
insert_into_logger = "insert into logger_id values ('{}', '{}', '{}', '{}', '{}')" \
.format(self.logger_id, dummy_hostname, pc_server_name, profile, test_definition)
sm.execute(insert_into_logger)
sm.quit()
def pushToLogger(self):
print 'Store to impala'
sm = StoreManager('ast12.recerca.intranet.urv.es',
21050,
'lab144',
'lab144')
sm.connect()
sm.execute('use benchbox')
for value in enumerate(self.diskValues):
print value
items = value[1].split(' ')
insert_into_logger = "insert into logger_hdd values ('{}', {}, {}, '{}', '{}')" \
.format(items[0], items[1], items[2], self.loggerId, self.hostname)
sm.execute(insert_into_logger)
sm.quit()
