def insertNet(self, id, idsession, ts, type, ret, pid, ppid, scontext,
nameSubject, ipsource, portsource, ipdest, portdest, state,
typeconnect, netsize, proto, data):
try:
tsp = datetime(1601, 1, 1) + timedelta(microseconds=int(ts) / 10)
request = "INSERT INTO tracenet(id,idsession,tstamp,type,returne,pid,ppid,scontext,nameSubject,ipSource,PortSource,ipDest,PortDest,state,typeconnect,netsize,proto,data) VALUES(" + str(
id) + ","
request = request + str(idsession) + ",'"
request = request + str(
DB2.Timestamp(tsp.year, tsp.month, tsp.day, tsp.hour,
tsp.minute, tsp.second)) + "','"
request = request + str(type) + "','" + str(ret) + "'," + str(
pid) + "," + str(ppid) + ",'"
request = request + scontext.replace("'", "''") + "','"
request = request + nameSubject.replace("'", "''").replace(
"\\", "/") + "','"
request = request + ipsource + "'," + portsource + ",'"
request = request + ipdest + "'," + portdest + ",'"
request = request + state + "','" + typeconnect + "'," + netsize + ",'" + proto + "','"
request = request + data.replace("'", "''") + "')"
except:
self.log.debug("db2interface:insertNet:" + request)
return
#self.log.debug("InsertLine: "+request)
cursor = self.conn.cursor()
try:
request = request.decode("unicode", "replace")
except:
try:
request = request.encode('ascii', 'xmlcharrefreplace')
#request.encode("utf8")
except:
request = "%s" % request
try:
try:
request = request.encode("utf8")
except:
print("Error encoding UTF8")
cursor.execute(request)
except:
print("Error DB2: " + request)
request = request.encode('ascii', 'xmlcharrefreplace')
try:
cursor.execute(request)
except:
print("Error DB2 ASCII: " + request)
if self.cpt == 1000:
self.conn.commit()
self.cpt = 0
else:
self.cpt = self.cpt + 1
# self.conn.commit()
cursor.close()
return 1
def insert(self, id, idsession, ts, type, ret, pid, ppid, scontext,
nameSubject, nameObject, tcontext, perms, data):
tsp = datetime(1601, 1, 1) + timedelta(microseconds=int(ts) / 10)
request = "INSERT INTO trace(id,idsession,tstamp,type,returne,pid,ppid,scontext,nameSubject,nameObject,tcontext,perms,data) VALUES(" + str(
id) + ","
request = request + str(idsession) + ",'"
request = request + str(
DB2.Timestamp(tsp.year, tsp.month, tsp.day, tsp.hour, tsp.minute,
tsp.second)) + "','"
request = request + str(type) + "','" + str(ret) + "'," + str(
pid) + "," + str(ppid) + ",'"
request = request + scontext.replace("'", "''") + "','"
request = request + nameSubject.replace("'", "''").replace("\\",
"/") + "','"
request = request + nameObject.replace("'", "''").replace("\\",
"/") + "','"
request = request + tcontext.replace("'", "''") + "','"
request = request + perms + "','"
request = request + data.replace("'", "''") + "')"
#self.log.debug("InsertLine: "+request)
cursor = self.conn.cursor()
try:
request = request.decode("unicode", "replace")
except:
try:
request = request.encode('ascii', 'xmlcharrefreplace')
#request.encode("utf8")
except:
request = "%s" % request
request = request.encode("utf8")
#except:
# print("Error encoding UTF8")
cursor.execute(request)
if self.cpt == 1000:
self.conn.commit()
self.conn.commit()
self.cpt = 0
else:
self.cpt = self.cpt + 1
self.conn.commit()
cursor.close()
return 1
def dbTime(dt):
"""convert datetime.time to MYSQL time"""
import MySQLdb
return MySQLdb.Timestamp(dt.year, dt.month, dt.day, dt.hour, dt.minute,
dt.second)
