def insertMsg(self, clientIp, processingData, type):
cnt = self.db.insert(self.__tableName, \
clientIp = clientIp, \
processingData = mysql.connector.Binary(processingData),\
flag=0,\
type=type,\
createdBy=hostname() + '_py')
return cnt > 0
def updateFenceInnerRadius(self, id, innerRadius):
sql_update = "id=%s"
cnt = self.db.update(self.__masterTableName,\
sql_update,\
id, \
inside_radius=innerRadius,\
update_time = time.strftime('%Y-%m-%d %X', time.localtime()),\
update_by = hostname() + '_py')
return cnt > 0
def updateCollectTime(self,id, s_time, e_time):
sql_update = "id=%s"
cnt = self.db.update(self.__tableName,\
sql_update,\
id, \
TestDriveBeginTime = s_time, \
TestDriveEndTime = e_time, \
update_time = time.strftime('%Y-%m-%d %X', time.localtime()),\
update_by = hostname() + '_py')
return cnt > 0
def insertReserveTime(self, car_id, obd_id, s_time, e_time):
cnt = self.db.insert(self.__tableName,\
id = str(uuid.uuid1()),\
car_id = car_id, \
type = 3,\
explains = 'py',\
task_status = 2,\
auditing_result = 2,\
start_time = s_time, \
end_time = e_time, \
operator = hostname() + '_py',\
action_name = '通过审核')
return cnt > 0
