def testconnect(): arg = request.json if 'data' not in arg or 'key' not in arg: return json.dumps({ "result": 'data or key is None', "status": False }) try: dsn = json.loads(decrypt(arg['data'],arg['key']))['dsn'] except Exception as e: return json.dumps({ "result": str(e), "status": False }) try: res = parse_dsn(dsn) pymysql.connect( host = res['host'], port = int(res['port']), user = res['user'], passwd = res['pwd'], db = res['db'], ) status = True result = '连接成功' except Exception as e: status = False result = str(e) return json.dumps({'result':result, 'status':status})
def testconnect(): dsn = request.values.get('dsn') try: res = parse_dsn(dsn) pymysql.connect( host=res['host'], port=int(res['port']), user=res['user'], passwd=res['pwd'], db=res['db'], ) status = True result = '连接成功' except Exception as e: status = False result = str(e) return json.dumps({'result': result, 'status': status})