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