如何使用robot框架进行价值验证?

2024-04-26 22:15:20 发布

您现在位置:Python中文网/ 问答频道 /正文

新的机器人框架世界。我已经编写了一个ppython程序来比较使用pandas的CSV文件的三个comuln的值。到现在为止,一直都还不错。程序运行成功。然而,我需要使用robot框架来创建测试用例,并将结果显示为通过或失败。下面是python程序:

import pandas as pd

# Reading the CSV file

df = pd.read_csv(r'xl1.csv', skipinitialspace=True, sep=',')

# Summation pf the two columns and giving results

sum1 = df['Gross_Salary'].sum()
sum2 = df['Deduction'].sum()
diff = sum1 - sum2

if diff == df['Net_Salary'].sum():
    print("Pass")
else:
    print("Fail")

上面的代码正在读取一个CSV文件,并添加两列,然后将该值与第三列进行比较。如果匹配,则为“通过”,否则为“失败”

CSV文件:

Gross_Salary Deduction Net_Salary
100             20         80
2000            200       1500
300             0          300

以下是机器人代码:

*** Settings ***
Library     SeleniumLibrary
Library     Process
Library     BuiltIn

*** Test Cases ***
PandaTest
    ${result}=      run process     python  <path_to_xl_parse.py>
    BuiltIn.Should Be Equal As Strings       ${result.rc}  PASS

我得到以下错误:

PandaTest                                                             | FAIL |
2 != PASS
------------------------------------------------------------------------------
Pan                                                                   | FAIL |
1 critical test, 0 passed, 1 failed
1 test total, 0 passed, 1 failed

请帮忙, 多谢各位


Tags: 文件csvthe程序框架pandasdflibrary