def createNewService(self,service_idf,max_devices,max_traffic,expire_timestamp,service_type):
try:
add_str = "INSERT INTO service_info (service_idf,max_devices,max_traffic,expire_time,service_type) VALUES (%s,%s,%s,%s,%s)"
c = self.cursor
expire_str = timeUtil.getReadableTime(int(expire_timestamp),0)
c.execute(add_str,[service_idf,int(max_devices),float(max_traffic),expire_str,service_type])
self.connection.commit()
return self.rtn.success(200)
except Exception as e:
traceback.print_exc()
def updateExpireTimestamp(self,service_idf,expire_timestamp):
try:
c = self.cursor
expire_time = timeUtil.getReadableTime(expire_timestamp,0)
update_str = "UPDATE service_info SET expire_time = %s WHERE service_idf = %s"
c.execute(update_str,[expire_time,service_idf])
self.connection.commit()
return self.rtn.success(200)
except Exception as e:
traceback.print_exc()