def sql_input(request): db_configs = DbConfig.objects.all() # if request.method == "GET": # pass try: sql = request.GET["context"] ID = request.GET["db_config"] the_db_config = DbConfig.objects.get(id=ID) the_auth = Auth.objects.get(id=the_db_config.auth) sql = "%s %s %s" % ("select", sql, "limit 100;") # print sql # mysql_cmd_task.delay(the_db_config.address, # the_auth.username, # the_auth.password, # sql, # request.user.username, # u'SQL语句执行') result = mysql_cmd(the_db_config.address, the_auth.username, the_auth.password, sql) if not result: result = ({'result': 'success'}, ) r = SQLResult(content=sql, result=str(result), user=request.user.username, sql_name=u'SQL语句') r.save() return http_success(request, u'操作成功,请等待执行结果,在SQL执行结果查看.') except: return render_to_response('database/sql_input.html', locals(), RequestContext(request))
def sql_input(request): db_configs = DbConfig.objects.all() # if request.method == "GET": # pass try: sql = request.GET["context"] ID = request.GET["db_config"] the_db_config = DbConfig.objects.get(id=ID) the_auth = Auth.objects.get(id=the_db_config.auth) sql = "%s %s %s" % ("select", sql, "limit 100;") # print sql # mysql_cmd_task.delay(the_db_config.address, # the_auth.username, # the_auth.password, # sql, # request.user.username, # u'SQL语句执行') result = mysql_cmd(the_db_config.address, the_auth.username, the_auth.password, sql) if not result: result = ({'result': 'success'},) r = SQLResult(content=sql, result=str(result), user=request.user.username, sql_name=u'SQL语句') r.save() return http_success(request, u'操作成功,请等待执行结果,在SQL执行结果查看.') except: return render_to_response('database/sql_input.html', locals(), RequestContext(request))
def mysql_cmd_task(host, username, password, sql, user, sql_name): # return mysql_cmd(host, username, password, sql) result = mysql_cmd(host, username, password, sql) if not result: result = ({'result': 'success'},) r = SQLResult(content=sql, result=str(result), user=user, sql_name=sql_name) r.save()
def mysql_cmd_task(host, username, password, sql, user, sql_name): # return mysql_cmd(host, username, password, sql) result = mysql_cmd(host, username, password, sql) if not result: result = ({'result': 'success'}, ) r = SQLResult(content=sql, result=str(result), user=user, sql_name=sql_name) r.save()