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")
