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