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 script_mysql_task(host, username, password, sql, file_name, user): file_path = os.path.join(SQL_DIRS, file_name) cmd = "php %s/saplatform/scripts/SchemaTool.php %s %s %s %s" % ( BASE_DIR, host, username, password, file_path) result = local_cmd(cmd) r = SQLResult(sql_name=file_name, content=sql, result=result, user=user) 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()
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 script_mysql_task(host, username, password, sql, file_name, user): file_path = os.path.join(SQL_DIRS, file_name) cmd = "php %s/saplatform/scripts/SchemaTool.php %s %s %s %s" % (BASE_DIR, host, username, password, file_path) result = local_cmd(cmd) r = SQLResult(sql_name=file_name, content=sql, result=result, user=user) r.save()