Method assertResult

compat/src/test/nodejs-postgres/runner.js:207–239

(expect, actual)

    }

    assertResult(expect, actual) {
        const normalizedActual = this.convertResult(actual);

        if (expect.result !== undefined) {
            const expectedResult = expect.result;
            if (Array.isArray(expectedResult)) {
                if (typeof normalizedActual === 'string') {
                    throw new Error(`Expected result ${JSON.stringify(expectedResult)}, got status '${normalizedActual}'`);
                }
                const actualStr = JSON.stringify(normalizedActual);
                const expectedStr = JSON.stringify(expectedResult);
                if (actualStr !== expectedStr) {
                    throw new Error(`Expected result ${expectedStr}, got ${actualStr}`);
                }
            } else {
                if (String(normalizedActual) !== String(expectedResult)) {
                    throw new Error(`Expected result '${expectedResult}', got '${normalizedActual}'`);
                }
            }
        } else if (expect.result_contains) {
            if (typeof normalizedActual === 'string') {
                throw new Error(`Expected result containing ${JSON.stringify(expect.result_contains)}, got status '${normalizedActual}'`);
            }
            for (const expectedRow of expect.result_contains) {
                const found = normalizedActual.some(actualRow =>
                    JSON.stringify(actualRow) === JSON.stringify(expectedRow)
                );
                if (!found) {
                    throw new Error(`Expected row ${JSON.stringify(expectedRow)} not found in actual results.`);
                }
            }
        }
    }

    async executeLoop(loopDef, variables, sql) {
        const loopVarName = loopDef.as;