Class SQLValidatorOracle

Example

const oracle = new SQLValidatorOracle();
const result = await oracle.evaluate({
    expectedOutput: {
        sqlValidations: [
            {
                sql: "SELECT COUNT(*) FROM Reports WHERE Name LIKE '%Sales%'",
                expectedResult: { count: 1 },
                description: "Sales report was created"
            },
            {
                sql: "SELECT Status FROM Reports WHERE ID = @ReportID",
                expectedResult: { status: 'Published' },
                description: "Report status is Published"
            }
        ]
    },
    actualOutput: {
        reportId: 'abc-123'
    },
    contextUser
}, {});
Copy