Exemple #1
0
def xls_worksheet_compare():
    if request.method == 'GET':
        return render_template(
            'xls_worksheet_compare.html',
            header_tab_classes={'xls-worksheet-compare': 'active'})

    worksheet_results_file = request.files['worksheet_file']
    if worksheet_results_file and allowed_file(
            worksheet_results_file.filename):
        filename = secure_filename(worksheet_results_file.filename)
        file_location = os.path.join(app.config['UPLOAD_FOLDER'], filename)
        worksheet_results_file.save(file_location)

        expected_worksheet_name = "Reference"
        actual_worksheet_name = "Actual"

        expected_results_table = td_parsers.load_table_from_xls(
            file_location, expected_worksheet_name)
        actual_results_table = td_parsers.load_table_from_xls(
            file_location, actual_worksheet_name)

        comparison = compare_data.compare_tables(expected_results_table,
                                                 actual_results_table,
                                                 td_comparison.COMPARE_RE_SKIP)
        comparison_id = td_persist.store_new_comparison(comparison)
        td_thumbnail.create_comparison_image(comparison, comparison_id)

        redirect_url = url_for('show_new_results', comparison_id=comparison_id)
        return redirect(redirect_url)

    return redirect(url_for('xls_worksheet_compare'))
Exemple #2
0
def compare_baseline():
    if request.method == 'GET':
        return compare_baseline_view(None)

    baseline = models.Baseline.get(
        models.Baseline.id == request.form['baseline_id'])
    baseline_path = get_excel_file_path(baseline.file)

    actual_file = save_excel_file(request.files['compare_file'], 'actual')

    expected_results_table = td_parsers.load_table_from_xls(baseline_path)
    actual_results_table = td_parsers.load_table_from_xls(
        get_excel_file_path(actual_file.id))

    # Note: Could we join here using the ORM instead?
    comparison_record = models.ComparisonType.get(
        models.ComparisonType.id == baseline.comparison)
    comparison = compare_data.compare_tables(expected_results_table,
                                             actual_results_table,
                                             comparison_record.name)
    comparison_id = td_persist.store_new_comparison(comparison)
    td_thumbnail.create_comparison_image(comparison, comparison_id)

    redirect_url = url_for('show_new_results', comparison_id=comparison_id)
    return redirect(redirect_url)
Exemple #3
0
def quick_compare():
    if request.method == 'GET':
        comparison_types = models.ComparisonType.select()
        return render_template('quick_compare.html',
                               header_tab_classes={'quick-compare': 'active'},
                               comparison_types=comparison_types)

    baseline_file = save_excel_file(request.files['baseline_file'], 'actual')
    actual_file = save_excel_file(request.files['comparison_file'], 'actual')

    expected_results_table = td_parsers.load_table_from_xls(
        get_excel_file_path(baseline_file.id))
    actual_results_table = td_parsers.load_table_from_xls(
        get_excel_file_path(actual_file.id))

    comparison_record = models.ComparisonType.get(
        models.ComparisonType.id == request.form['comparison_type'])
    comparison = compare_data.compare_tables(expected_results_table,
                                             actual_results_table,
                                             comparison_record.name)
    comparison_id = td_persist.store_new_comparison(comparison)
    td_thumbnail.create_comparison_image(comparison, comparison_id)

    # Note: We could delete the files once we're done with a quick comparison.

    redirect_url = url_for('show_new_results', comparison_id=comparison_id)
    return redirect(redirect_url)
Exemple #4
0
def xls_worksheet_compare():
    if request.method == 'GET':
        return render_template('xls_worksheet_compare.html',
                               header_tab_classes={'xls-worksheet-compare': 'active'})

    worksheet_results_file = request.files['worksheet_file']
    if worksheet_results_file and allowed_file(worksheet_results_file.filename):
        filename = secure_filename(worksheet_results_file.filename)
        file_location = os.path.join(app.config['UPLOAD_FOLDER'], filename)
        worksheet_results_file.save(file_location)

        expected_worksheet_name = "Reference"
        actual_worksheet_name = "Actual"

        expected_results_table = td_parsers.load_table_from_xls(file_location, expected_worksheet_name)
        actual_results_table = td_parsers.load_table_from_xls(file_location, actual_worksheet_name)

        comparison = compare_data.compare_tables(expected_results_table, actual_results_table, td_comparison.COMPARE_RE_SKIP)
        comparison_id = td_persist.store_new_comparison(comparison)
        td_thumbnail.create_comparison_image(comparison, comparison_id)

        redirect_url = url_for('show_new_results', comparison_id=comparison_id)
        return redirect(redirect_url)

    return redirect(url_for('xls_worksheet_compare'))
Exemple #5
0
def copy_paste_compare():
    if request.method == 'GET':
        return render_template('new_tables_input.html',
                               header_tab_classes={'copy-paste-compare': 'active'})

    table1 = td_parsers.load_table_from_handson_json(request.json['dataTable1'])
    table2 = td_parsers.load_table_from_handson_json(request.json['dataTable2'])

    comparison = compare_data.compare_tables(table1, table2, td_comparison.COMPARE_LITERAL)
    comparison_id = td_persist.store_new_comparison(comparison)
    td_thumbnail.create_comparison_image(comparison, comparison_id)

    redirect_url = url_for('show_new_results', comparison_id=comparison_id)
    return flask.jsonify(redirect_url=redirect_url)
Exemple #6
0
def copy_paste_compare():
    if request.method == 'GET':
        return render_template(
            'new_tables_input.html',
            header_tab_classes={'copy-paste-compare': 'active'})

    table1 = td_parsers.load_table_from_handson_json(
        request.json['dataTable1'])
    table2 = td_parsers.load_table_from_handson_json(
        request.json['dataTable2'])

    comparison = compare_data.compare_tables(table1, table2,
                                             td_comparison.COMPARE_LITERAL)
    comparison_id = td_persist.store_new_comparison(comparison)
    td_thumbnail.create_comparison_image(comparison, comparison_id)

    redirect_url = url_for('show_new_results', comparison_id=comparison_id)
    return flask.jsonify(redirect_url=redirect_url)
Exemple #7
0
def compare_baseline():
    if request.method == 'GET':
        return compare_baseline_view(None)

    baseline = models.Baseline.get(models.Baseline.id == request.form['baseline_id'])
    baseline_path = get_excel_file_path(baseline.file)

    actual_file = save_excel_file(request.files['compare_file'], 'actual')

    expected_results_table = td_parsers.load_table_from_xls(baseline_path)
    actual_results_table = td_parsers.load_table_from_xls(get_excel_file_path(actual_file.id))

    # Note: Could we join here using the ORM instead?
    comparison_record = models.ComparisonType.get(models.ComparisonType.id == baseline.comparison)
    comparison = compare_data.compare_tables(expected_results_table, actual_results_table, comparison_record.name)
    comparison_id = td_persist.store_new_comparison(comparison)
    td_thumbnail.create_comparison_image(comparison, comparison_id)

    redirect_url = url_for('show_new_results', comparison_id=comparison_id)
    return redirect(redirect_url)
Exemple #8
0
def quick_compare():
    if request.method == 'GET':
        comparison_types = models.ComparisonType.select()
        return render_template('quick_compare.html',
            header_tab_classes={'quick-compare': 'active'}, comparison_types=comparison_types)

    baseline_file = save_excel_file(request.files['baseline_file'], 'actual')
    actual_file = save_excel_file(request.files['comparison_file'], 'actual')

    expected_results_table = td_parsers.load_table_from_xls(get_excel_file_path(baseline_file.id))
    actual_results_table = td_parsers.load_table_from_xls(get_excel_file_path(actual_file.id))

    comparison_record = models.ComparisonType.get(models.ComparisonType.id == request.form['comparison_type'])
    comparison = compare_data.compare_tables(expected_results_table, actual_results_table, comparison_record.name)
    comparison_id = td_persist.store_new_comparison(comparison)
    td_thumbnail.create_comparison_image(comparison, comparison_id)

    # Note: We could delete the files once we're done with a quick comparison.

    redirect_url = url_for('show_new_results', comparison_id=comparison_id)
    return redirect(redirect_url)