def modify_db(request, db_id):
if request.method == 'POST':
create_db_form = CreateDbForm(request.POST)
db_cfg_detail = get_object_or_404(DbCfgDetail, pk=db_id)
#print(create_db_form.data['name'])
#print(get_object_or_404(DbCfgDetail, pk=db_id).name)
if create_db_form.data['name'] == get_object_or_404(DbCfgDetail,
pk=db_id).name:
db_cfg_detail.name = create_db_form.data['name']
db_cfg_detail.ip_address = create_db_form.data['ip']
db_cfg_detail.port = create_db_form.data['port']
db_cfg_detail.db_type = get_object_or_404(
DbCfgType, pk=create_db_form.data['db_type'])
db_cfg_detail.db_cfg = create_db_form.data['db_cfg']
db_cfg_detail.user_name = create_db_form.data['username']
pass_word = create_db_form.data['pass_wd']
pass_word = PasswdUtil.encrypt(pass_word)
db_cfg_detail.pass_word = pass_word
# 创建数据库配置
db_cfg_detail.save()
return redirect(reverse('get_db_cfg_list'))
if create_db_form.is_valid():
db_cfg_detail.name = create_db_form.cleaned_data['name']
db_cfg_detail.ip_address = create_db_form.cleaned_data['ip']
db_cfg_detail.port = create_db_form.cleaned_data['port']
db_cfg_detail.db_type = get_object_or_404(
DbCfgType, pk=create_db_form.cleaned_data['db_type'])
print(create_db_form.cleaned_data['db_type'])
db_cfg_detail.db_cfg = create_db_form.cleaned_data['db_cfg']
db_cfg_detail.user_name = create_db_form.cleaned_data['username']
pass_word = create_db_form.cleaned_data['pass_wd']
pass_word = PasswdUtil.encrypt(pass_word)
db_cfg_detail.pass_word = pass_word
# 创建数据库配置
db_cfg_detail.save()
return redirect(reverse('get_db_cfg_list'))
else:
datas = get_object_or_404(DbCfgDetail, pk=db_id)
data_set = {}
data_set['name'] = datas.name
data_set['ip'] = datas.ip_address
data_set['port'] = datas.port
data_set['username'] = datas.user_name
data_set['pass_wd'] = datas.pass_word
data_set['db_cfg'] = datas.db_cfg
data_set['db_type'] = datas.db_type
create_db_form = CreateDbForm(initial=data_set)
context = {'create_db_form': create_db_form}
return render(request, 'db_modify.html', context)
def create_db(request):
if request.method == 'POST':
create_db_form = CreateDbForm(request.POST)
db_cfg_detail = DbCfgDetail()
if create_db_form.is_valid():
db_cfg_detail.name = create_db_form.cleaned_data['name']
db_cfg_detail.ip_address = create_db_form.cleaned_data['ip']
db_cfg_detail.port = create_db_form.cleaned_data['port']
db_cfg_detail.db_type = create_db_form.cleaned_data['db_type']
db_cfg_detail.db_cfg = create_db_form.cleaned_data['db_cfg']
db_cfg_detail.user_name = create_db_form.cleaned_data['username']
pass_word = create_db_form.cleaned_data['pass_wd']
pass_word = PasswdUtil.encrypt(pass_word)
db_cfg_detail.pass_word = pass_word
# 创建数据库配置
db_cfg_detail.save()
return redirect(reverse('get_db_cfg_list'))
else:
create_db_form = CreateDbForm()
context = {'create_db_form': create_db_form}
return render(request, 'db_create.html', context)
