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