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