def post(self): logger = logging.getLogger("nc") req = self.request reqbody = self.request.body logger.info(' -- %s -- "%s %s %s" - "%s" -- MSM request data: %s --' % (req.remote_ip, req.method, req.version, req.uri, req.headers["User-Agent"], reqbody)) reqbody = json.loads(self.request.body) account = reqbody["account"] lr_ip = reqbody["lr_ip"] lr_port = reqbody["lr_port"] lr = "%s:%s" % (lr_ip, lr_port) sqls = """select * from `force_route` where `account`='%s'""" % account res = db.execOnly(sqls) if res > 0: self.write({"code": 400}) else: sqls_id = """select `lr_id` from `lr_node` where ip='%s' and port='%s'""" % ( lr_ip, lr_port) res_id = db.execFetch(sqls_id) if len(res_id) == 0: self.write({"code": 404}) else: lr_id = res_id[0][0] sqli = """insert into `force_route` (`account`, `lr`, `lr_id`) values ('%s', '%s', '%s')""" % ( account, lr, lr_id) db.execOnly(sqli) self.write({"code": 200})
def delete(self, account=''): logger = logging.getLogger("nc") req = self.request reqbody = self.request.body logger.info(' -- %s -- "%s %s %s" - "%s" -- MSM request data: %s --' % (req.remote_ip, req.method, req.version, req.uri, req.headers["User-Agent"], reqbody)) sqld = """truncate table `force_route`""" db.execOnly(sqld) self.write("ok")
def post(self, account): logger = logging.getLogger("nc") req = self.request reqbody = self.request.body logger.info(' -- %s -- "%s %s %s" - "%s" -- MSM request data: %s --' % (req.remote_ip, req.method, req.version, req.uri, req.headers["User-Agent"], reqbody)) reqbody = json.loads(self.request.body) account = reqbody["account"] sqld = """delete from `force_route` where `account`='%s'""" % account db.execOnly(sqld) self.write("ok")
def delete(self, epid): sqld = """delete from `adjacency` where `ep_id`='%s'""" % epid rows = db.execOnly(sqld) if rows == 0: self.write({ "code": 400, "status": "error", "msg": "User not found." }) else: redis_client.delete("user:%s" % epid) self.write({"code": 200, "status": "success"})
def post(self): reqbody = json.loads(self.request.body) account = reqbody["account"] lr_ip = reqbody["lr_ip"] lr_port = reqbody["lr_port"] lr = "%s:%s" % (lr_ip, lr_port) sqls = """select * from `force_route` where `account`='%s'""" % account res = db.execOnly(sqls) if res > 0: self.write({"code": 400}) else: sqls_id = """select `lr_id` from `lr_node` where ip='%s' and port='%s'""" % ( lr_ip, lr_port) res_id = db.execFetch(sqls_id) if len(res_id) == 0: self.write({"code": 404}) else: lr_id = res_id[0][0] sqli = """insert into `force_route` (`account`, `lr`, `lr_id`) values ('%s', '%s', '%s')""" % ( account, lr, lr_id) db.execOnly(sqli) self.write({"code": 200})
def put(self, epid): # reqbody = json.loads(self.request.body) reqbody = eval(self.request.body) act = reqbody["account"] level = reqbody['node_level'] vsp = reqbody["vsp_id"] sqlu = """update `adjacency` set `account`="%s", `level_id`="%s" , `vsp_id`="%s" where `ep_id`='%s'""" % ( act, level, vsp, epid) rows = db.execOnly(sqlu) if rows: redis_client.hmset("user:%s" % epid, { "level_id": level, "vsp_id": vsp }) self.write({"code": 200, "status": "success"}) else: self.write({"code": 400, "status": "error"})
def delete(self, epid): logger = logging.getLogger("nc") req = self.request reqbody = self.request.body logger.info(' -- %s -- "%s %s %s" - "%s" -- MSM request data: %s --' % (req.remote_ip, req.method, req.version, req.uri, req.headers["User-Agent"], reqbody)) sqld = """delete from `adjacency` where `ep_id`='%s'""" % epid rows = db.execOnly(sqld) if rows == 0: self.write({ "code": 400, "status": "error", "msg": "User not found." }) else: redis_client.delete("user:%s" % epid) self.write({"code": 200, "status": "success"})
def post(self, epid=None): # reqbody = json.loads(self.request.body) reqbody = eval(self.request.body) act = reqbody["account"] ep = reqbody["userid"] ep_user = "******" % (ep, act) level = reqbody["node_level"] vsp_id = reqbody["vsp_id"] sqli = """insert into `adjacency` (`account`, `ep_id`, `level_id`, `vsp_id`) values ("%s", "%s", "%s", "%s")""" % ( act, ep_user, level, vsp_id) rows = db.execOnly(sqli) if rows == 1: redis_client.hmset("user:%s" % ep_user, { "level_id": level, "vsp_id": vsp_id }) self.write({"code": 200, "status": "success"}) else: self.write({"code": 404, "status": "error"})
def put(self, epid): logger = logging.getLogger("nc") req = self.request reqbody = self.request.body logger.info(' -- %s -- "%s %s %s" - "%s" -- MSM request data: %s --' % (req.remote_ip, req.method, req.version, req.uri, req.headers["User-Agent"], reqbody)) reqbody = json.loads(self.request.body) # reqbody = eval(self.request.body) act = reqbody["account"] level = reqbody["node_level"] vsp = reqbody["vsp_id"] sqlu = """update `adjacency` set `account`="%s", `level_id`="%s" , `vsp_id`="%s" where `ep_id`='%s'""" % ( act, level, vsp, epid) rows = db.execOnly(sqlu) if rows: redis_client.set("user:%s" % epid, level) self.write({"code": 200, "status": "success"}) else: self.write({"code": 400, "status": "error"})
def post(self, epid=None): logger = logging.getLogger("nc") req = self.request reqbody = self.request.body logger.info(' -- %s -- "%s %s %s" - "%s" -- MSM request data: %s --' % (req.remote_ip, req.method, req.version, req.uri, req.headers["User-Agent"], reqbody)) reqbody = json.loads(self.request.body) act = reqbody["account"] ep = reqbody["userid"] ep_user = "******" % (ep, act) level = reqbody["node_level"] vsp_id = reqbody["vsp_id"] sqli = """insert into `adjacency` (`account`, `ep_id`, `level_id`, `vsp_id`) values ("%s", "%s", "%s", "%s")""" % ( act, ep_user, level, vsp_id) rows = db.execOnly(sqli) if rows == 1: redis_client.set("user:%s" % ep_user, level) self.write({"code": 200, "status": "success"}) else: self.write({"code": 404, "status": "error"})
def post(self, account): reqbody = json.loads(self.request.body) account = reqbody["account"] sqld = """delete from `force_route` where `account`='%s'""" % account db.execOnly(sqld) self.write("ok")
def delete(self, account=''): sqld = """truncate table `force_route`""" db.execOnly(sqld) self.write("ok")