def post(self):
ret = {
"code":200,
"msg":"",
"data":[],
}
body = self.request.body
params = json.loads(body)
dbType = params.get("dbType")
dbName = params.get("dbName")
dbHost = params.get("dbHost")
dbUsername = params.get("dbUsername")
dbPassword = params.get("dbPassword")
dbPort = params.get("dbPort")
db = DBUtil()
sql = """SELECT 1 FROM rq_db_configs WHERE cname = '%s' AND host = '%s' AND port = '%s' AND dbname = '%s' """ % (dbType, dbHost, dbPort, dbName)
res = db.fetch_all(sql)
if res:
ret["code"] = 400
ret["msg"] = "数据源已经存在"
else:
sql = """INSERT INTO rq_db_configs(`cname`, `host`, `port`, `dbname`, `username`, `password`) VALUES('%s', '%s', '%s', '%s', '%s', '%s')""" % (dbType, dbHost, dbPort, dbName, dbUsername, dbPassword)
db.execute(sql)
self.write(json.dumps(ret))
def get(self):
db = DBUtil()
sql = """select id, cname from rq_db_configs"""
data = db.fetch_all(sql)
ret = {
"code":200,
"msg":"",
"data":data,
}
self.write(json.dumps(ret))
