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)