def MyfastSQL_result(request):
if request.method=='GET':
id = request.GET['id']
Myfastsql = MysqlFastSQL.objects.get(id=id)
sql = request.GET['sql']
cluster = MySQLCluster.objects.get(id=request.GET['mysqlcluster_id'])
if Myfastsql.exec_posi == u'从库':
pass
else:
try:
ip = cluster.foreign_ip
port = cluster.foreign_port
user = cluster.plat_user
arch = cluster.arch
passwd = cluster.plat_user_pass
conn = MySQL(ip=ip, port=port, user=user, passwd=passwd)
count, datalist, colName = conn.execute(sql=sql)
return render(request, 'dbops/mysql/MysqlfastSQL_result.html', locals())
except Exception as e:
colName=[u'报错']
datalist=[[u'请检查sql语句的错误，查不出来']]
return render(request, 'dbops/mysql/MysqlfastSQL_result.html', locals())
