def addassessment(request):
username = request.user.username
if request.method == "POST":
form = AssessmentForm(data=request.POST)
if form.is_valid():
form.save()
success = True
successinfo = "添加"
return render_to_response('assessment/assessment.html', {
"title": '互评管理',
'form': form,
'successinfo': successinfo,
'success': success,
'username': username
},
context_instance=RequestContext(request))
else:
print form.errors
return render_to_response('assessment/assessment.html', {
"title": '互评管理',
'form': form,
'username': username
},
context_instance=RequestContext(request))
return HttpResponseRedirect('/manage/assessment/')
def assess():
config['user_action'] = "assess"
print_config("start assess stage")
form = AssessmentForm(assessname=config['assess_name'],
filename=config['input_csv_file'],
outputFolder=config['output_folder'],
reportName=config['output_report_name'],
reportFormat=config['output_report_name'],
assessType=config['assess_type'],
target=config['target_platform'])
if form.validate_on_submit():
flash(f'Start SQL Server Azure migration assessment ...', 'info')
params = f"-AssessName {config['assess_name']} -InputFile {config['input_csv_file']} -OutputFolder {config['output_folder']} \
-ReportName {config['output_report_name']} -AssessType {config['assess_type']} -Target {config['target_platform']}"
result = str(execute_script("catas.ps1", params))
result = 'Success'
if result[0:5] == "Error":
errorMessage = result if len(result) <= 200 else result[0:200]
flash(errorMessage, 'danger')
#raise AssessError('SQL server host connection Assess failed, please check host name and credentials.')
else:
#flash(f"PowerShell script good {result}", 'success')
flash(f'Assessment successful!', 'success')
form = AssessmentForm(assessname=config['assess_name'],
filename=config['input_csv_file'],
outputFolder=config['output_folder'],
reportName=config['output_report_name'],
reportFormat=config['output_report_name'],
assessType=config['assess_type'],
target=config['target_platform'])
return render_template('assess.html', title='Assess', form=form)
def give_assessment():
check_manager()
form = AssessmentForm()
if form.validate_on_submit():
name = str(form.name.data)[11:-1]
print name
employee = Employee.query.filter_by(name=name).first()
print employee
employee.assessment = form.example.data
try:
db.session.commit()
logger.info('assessment given ')
flash('You have successfully submitted the assessment.')
return redirect(url_for('admin.list_employees1'))
except Exception as e:
flash('Please select a value first ')
logger.error('assesment cannot be given')
flash(str(e))
else:
if form.errors:
flash('Please select a value')
return render_template('admin/employees/assessment.html',
form=form,
title='Assessment')
def assessmentview(request, subject_id=None):
assessment_id = None
if assessment_id == None:
assessment = Assessment()
else:
assessment = get_object_or_404(Assessment, pk=assessment_id)
if subject_id != None:
subject = get_object_or_404(Subject, pk=subject_id)
if request.method == 'POST':
form = AssessmentForm(request.POST, instance=assessment)
optional_form = AssessmentOptionalForm(request.POST)
if form.is_valid() and optional_form.is_valid():
#TODO knytte bruker
cleaned_main = form.cleaned_data
cleaned_optional = optional_form.cleaned_data
add_assessment(cleaned_main, cleaned_optional, subject)
return redirect(subject_details, subject_id)
else:
messages.error(request, 'Invalid inputs')
form = AssessmentForm(request.POST, auto_id=True)
else:
form = AssessmentForm(instance=assessment)
optional_form = AssessmentOptionalForm()
return render(request, 'assessmentview.html', {'form' : form, 'optional_form' : optional_form})
def editassessment(request):
username = request.user.username
if request.method == "POST":
form = AssessmentForm(data = request.POST)
if form.is_valid():
form.update()
success = True
successinfo = "修改"
return render(request, 'assessment/assessment.html',{
"title":'互评管理',
'form':form,
'successinfo':successinfo,
'success':success,
'username':username})
else:
return render(request, 'assessment/assessment.html',{
"title":'互评管理',
'form':form,
'username':username})
return HttpResponseRedirect('/manage/assessment/')
def editassessment(request):
username = request.user.username
if request.method == "POST":
form = AssessmentForm(data = request.POST)
if form.is_valid():
form.update()
success = True
successinfo = "修改"
return render_to_response('assessment/assessment.html',{
"title":'互评管理',
'form':form,
'successinfo':successinfo,
'success':success,
'username':username},context_instance = RequestContext(request))
else:
return render_to_response('assessment/assessment.html',{
"title":'互评管理',
'form':form,
'username':username},context_instance = RequestContext(request))
return HttpResponseRedirect('/manage/assessment/')
def manage():
if request.method == 'POST':
if "catas_save" in request.form:
print("saving configuration file.")
result = save_config(request.form['config_file'])
if result:
print('Error during saving configuration file.')
return jsonify({
'result': 'err',
'msg': 'Error during saving configuration file.'
})
else:
print('Configuration saved into the file')
return jsonify({
'result': 'suc',
'msg': 'Successfully saved configuration!'
})
elif "catas_load" in request.form:
print("loading configuration file.")
result = load_config(request.form['config_file'])
if result:
print('Error during loading configuration file.')
return jsonify({
'result':
'err',
'msg':
'Error during loading configuration file.'
})
else:
print('Configuration successfully loaded')
# now redirect to the proper page from loaded configurations
if not config['user_action'] or config['user_action'] == 'home':
#return render_template('home.html', posts=posts)
return jsonify({
'result': 'suc',
'msg': '/' + config['user_action']
})
else:
# form = CollectionForm(assessname=config['assess_name'], filename=config['input_csv_file'],
# validationType=config['validation_type'])
# return render_template('collect.html', title='Collect', form=form, posts=posts, sidebar=False)
# return redirect(url_for('collect'))
return jsonify({
'result': 'suc',
'msg': '/' + config['user_action']
})
else:
print("neither catas_save nor catas_load exists.")
else: # for non-POST
if config['user_action'] == 'assess':
form = AssessmentForm(assessname=config['assess_name'],
filename=config['input_csv_file'],
outputFolder=config['output_folder'],
reportName=config['output_report_name'],
reportFormat=config['output_report_name'],
assessType=config['assess_type'],
target=config['target_platform'])
return render_template(
'assess.html',
title='Assess',
form=form,
sidebar=True,
sidebar_title='Manage',
sidebar_statement='Save or load configurations.',
configFileFullName=config['config_file_full_name'])
elif config['user_action'] == 'collect':
#return redirect(url_for('validate'))
form = CollectionForm(assessname=config['assess_name'],
filename=config['input_csv_file'],
outputFolder=config['output_folder'],
reportFormat=config['output_report_name'],
assessType=config['assess_type'],
dblist=config['db_list'],
collectTime=config['collect_time'],
tenantid=config['tenant_id'],
subid=config['sub_id'],
clientid=config['client_id'])
return render_template(
'collect.html',
title='Collect',
form=form,
posts=posts,
sidebar=True,
sidebar_title='Manage',
sidebar_statement='Save or load configurations.',
configFileFullName=config['config_file_full_name'])
elif config['user_action'] == 'home':
return render_template(
'home.html',
posts=posts,
sidebar=True,
sidebar_title='Manage',
sidebar_statement='Load existing configuration.',
configFileFullName=config['config_file_full_name'])
elif config['user_action'] == 'validate':
#return redirect(url_for('validate'))
form = ValidationForm(assessname=config['assess_name'],
filename=config['input_csv_file'],
validationType=config['validation_type'])
return render_template(
'validate.html',
title='Validate',
form=form,
posts=posts,
sidebar=True,
sidebar_title='Manage',
sidebar_statement='Save or load configurations.',
configFileFullName=config['config_file_full_name'])
else:
print("unknow user action")
return redirect(url_for('home'))