def f_ip2num(ip):
return IpTool.ip2num(ip)
def add(request):
params = {}
####################################################################
# GET 请求
####################################################################
if request.method == 'GET':
form = AddForm()
params['form'] = form
return render(request, 'dbmp_mysql_instance/add.html', params)
####################################################################
# POST 请求
####################################################################
if request.method == 'POST':
form = AddForm(request.POST)
params['form'] = form
# 验证表单
if form.is_valid():
os_id = form.cleaned_data['os_id']
host = form.cleaned_data['host']
port = form.cleaned_data['port']
username = form.cleaned_data['username']
password = form.cleaned_data['password']
remark = form.cleaned_data['remark']
my_cnf_path = form.cleaned_data['my_cnf_path']
base_dir = form.cleaned_data['base_dir']
start_cmd = form.cleaned_data['start_cmd']
host = IpTool.ip2num(host)
run_status = 3 # 未知
try:
with transaction.atomic():
# 更新DbmpMysqlInstance
dbmp_mysql_instance = DbmpMysqlInstance(
os_id=os_id,
host=host,
port=port,
username=username,
password=password,
run_status=run_status,
remark=remark)
dbmp_mysql_instance.save()
# 插入数据 dbmp_mysql_instance_info
DbmpMysqlInstanceInfo.objects.create(
mysql_instance_id=dbmp_mysql_instance.
mysql_instance_id,
my_cnf_path=my_cnf_path,
base_dir=base_dir,
start_cmd=start_cmd)
# 保存成功转跳到View页面
request.session['success_msg'].append('添加成功')
view_url = '{base_url}/view/?mysql_instance_id={id}'.format(
base_url=ViewUrlPath.path_dbmp_mysql_instance(),
id=dbmp_mysql_instance.mysql_instance_id)
return HttpResponseRedirect(view_url)
except IntegrityError, e:
logger.info(traceback.format_exc())
request.session['danger_msg'].append('添加失败')
if e.args[0] == 1062:
request.session['alert_message_now']['danger_msg'].append(
'需要添加的相关信息重复')
request.session['alert_message_now']['danger_msg'].append(
e.args)
return render(request, 'dbmp_mysql_instance/add.html', params)
except Exception, e:
logger.info(traceback.format_exc())
# 保存失败转跳会原页面
request.session['alert_message_now']['danger_msg'].append(
'添加失败, 保存数据库错误')
return render(request, 'dbmp_mysql_instance/add.html', params)
def f_ip2num(ip):
return IpTool.ip2num(ip)
def edit(request):
params = {}
####################################################################
# GET 请求
####################################################################
# 点击链接转跳到编辑页面
if request.method == 'GET':
# 获取MySQL实例ID
mysql_instance_id = int(request.GET.get('mysql_instance_id', '0'))
if mysql_instance_id:
try:
# 1.获取MySQL实例
dbmp_mysql_instance = DbmpMysqlInstance.objects.get(
mysql_instance_id=mysql_instance_id)
params['dbmp_mysql_instance'] = dbmp_mysql_instance
# 2.获得MySQL实例额外信息
try:
dbmp_mysql_instance_info = DbmpMysqlInstanceInfo.objects.get(
mysql_instance_id=dbmp_mysql_instance.mysql_instance_id
)
params[
'dbmp_mysql_instance_info'] = dbmp_mysql_instance_info
except DbmpMysqlInstanceInfo.DoesNotExist:
request.session['alert_message_now']['warning_msg'].append(
'该MySQL实例信息设置不完整, 请进行编辑')
# 3.获得操作系统
try:
cmdb_os = CmdbOs.objects.get(
os_id=dbmp_mysql_instance.os_id)
params['cmdb_os'] = cmdb_os
except CmdbOs.DoesNotExist:
logger.info(traceback.format_exc())
# 如果MySQL实例没有指定OS则告警
request.session['alert_message_now']['wraning_msg'].append(
'该MySQL实例没有指定一个OS')
return render(request, 'dbmp_mysql_instance/edit.html', params)
except DbmpMysqlInstance.DoesNotExist:
logger.info(traceback.format_exc())
# 返回点击编辑页面
request.session['danger_msg'].append('对不起! 找不到指定的MySQL实例')
return HttpResponseRedirect(request.environ['HTTP_REFERER'])
else:
request.session['danger_msg'] = '对不起! 找不到指定的MySQL实例!'
# 返回点击编辑页面
return HttpResponseRedirect(request.environ['HTTP_REFERER'])
####################################################################
# POST 请求
####################################################################
# 修改操作
if request.method == 'POST':
form = EditForm(request.POST)
# 验证表单
if form.is_valid():
mysql_instance_id = form.cleaned_data['mysql_instance_id']
mysql_instance_info_id = form.cleaned_data[
'mysql_instance_info_id']
os_id = form.cleaned_data['os_id']
host = form.cleaned_data['host']
port = form.cleaned_data['port']
username = form.cleaned_data['username']
password = form.cleaned_data['password']
remark = form.cleaned_data['remark']
my_cnf_path = form.cleaned_data['my_cnf_path']
base_dir = form.cleaned_data['base_dir']
start_cmd = form.cleaned_data['start_cmd']
host = IpTool.ip2num(host)
try:
with transaction.atomic():
# 更新DbmpMysqlInstance
DbmpMysqlInstance.objects.filter(
mysql_instance_id=mysql_instance_id).update(
os_id=os_id,
host=host,
port=port,
username=username,
password=password,
remark=remark)
if mysql_instance_info_id:
# 更新 dbmp_mysql_instance_info
DbmpMysqlInstanceInfo.objects.filter(
mysql_instance_info_id=mysql_instance_info_id
).update(my_cnf_path=my_cnf_path,
base_dir=base_dir,
start_cmd=start_cmd)
else:
# 插入数据 dbmp_mysql_instance_info
DbmpMysqlInstanceInfo.objects.create(
mysql_instance_id=mysql_instance_id,
my_cnf_path=my_cnf_path,
base_dir=base_dir,
start_cmd=start_cmd)
# 保存成功转跳到View页面
request.session['success_msg'].append('修改成功')
view_url = '{base_url}/view/?mysql_instance_id={id}'.format(
base_url=ViewUrlPath.path_dbmp_mysql_instance(),
id=mysql_instance_id)
return HttpResponseRedirect(view_url)
except IntegrityError, e:
logger.info(traceback.format_exc())
request.session['danger_msg'].append('编辑失败')
if e.args[0] == 1062:
request.session['danger_msg'].append('需要修改的相关信息重复')
request.session['danger_msg'].append(e.args)
return HttpResponseRedirect(request.environ['HTTP_REFERER'])
except Exception, e:
logger.info(traceback.format_exc())
# 保存失败转跳会原页面
request.session['danger_msg'].append('编辑失败, 保存数据库错误')
return HttpResponseRedirect(request.environ['HTTP_REFERER'])