我正在运行一个SQL查询,并以空手道的数组形式返回对象。一世 知道如何读取返回的第一条记录/行。我需要知道如何 创建一个循环以一次读取所有记录。
这是调用SQL查询的开始,我正在分配对象 变量。
Scenario Outline: Premium-IC or IR Invoice Type
* def op_ic_ir_query = karate.readAsString('classpath:Payments/
CSC_Payments_API/Queries/qry_Get_Overpayment_IC_IR.txt')
* def OP1 = Stardb.readRows(op_ic_ir_query)
* def OP_cpid = OP1[0].CONTRact_PAYMENT_ID
* def OP_cid = OP1[0].CONTRact_ID
* def OP_iid = OP1[0].INVOICE_ID
* def OP_Idate = OP1[0].INVOICE_DATE
* def OP_dtp = OP1[0].DATE_TO_PROCESS
* def transactionAmt = OP1[0].TRANSactION_AMOUNT
* def invoiceAmt = OP1[0].INVOICE_AMOUNT
* def taxAmt = OP1[0].TAX_AMOUNT
* def paidAmt = OP1[0].PAID_AMOUNT
下一步是计算多付款项。
# Calculate overpayment_amount - need to keep rolling total for
overpayment amount.
* def overpaymentAmt1 = (transactionAmt - ((invoiceAmt + taxAmt) -
paidAmt))