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')