# test.govlab/quality/core/parsers/tool.sqlfluff.parser.test.ts

> 51 lines of code and 0 definitions.

Tree: Codebase Testing
Language: typescript
Canonical: https://banes-lab.com/anatomy/testing#file-testing-test-govlab-quality-core-parsers-tool-sqlfluff-parser-test-ts
Source text: https://banes-lab.com/source/testing/test.govlab/quality/core/parsers/tool.sqlfluff.parser.test.ts.txt

Listed in [test.govlab/quality/core/parsers](https://banes-lab.com/api/source/testing/test.govlab/quality/core/parsers.md), after [test.govlab/quality/core/parsers/tool.slither.parser.test.ts](https://banes-lab.com/source/testing/test.govlab/quality/core/parsers/tool.slither.parser.test.ts.md) and before [test.govlab/quality/core/parsers/tool.staticcheck.parser.test.ts](https://banes-lab.com/source/testing/test.govlab/quality/core/parsers/tool.staticcheck.parser.test.ts.md).

## Contained in

- [test.govlab/quality/core/parsers](https://banes-lab.com/anatomy/testing/folder-testing-test-govlab-quality-core-parsers.md)

## Source

```typescript
import { describe, expect, it } from "vitest";
import { parseSqlfluffOutput } from "@govlab/quality/core/parsers/tool.sqlfluff.parser.ts";

const EXPECTED_COUNT = 2;

const RECORDED = JSON.stringify([
    {
        filepath: "q.sql",
        violations: [
            {
                code: "LT01",
                description: "Expected single whitespace between comma ',' and naked identifier.",
                fixes: [{ edit: " ", type: "create_after" }],
                name: "layout.spacing",
                start_line_no: 1,
                start_line_pos: 10,
                warning: false,
            },
            {
                code: "LT09",
                description: "Select targets should be on a new line unless there is only one select target.",
                fixes: [],
                name: "layout.select_targets",
                start_line_no: 1,
                start_line_pos: 1,
                warning: false,
            },
        ],
    },
]);

describe("parseSqlfluffOutput", () => {
    it("maps violations to gating (error, advisory:false) Findings", () => {
        const findings = parseSqlfluffOutput(RECORDED, "sql");
        expect(findings).toHaveLength(EXPECTED_COUNT);
        expect(findings[0]).toMatchObject({
            advisory: false,
            column: 10,
            ecosystem: "sql",
            file: "q.sql",
            fixable: true,
            line: 1,
            ruleId: "LT01",
            severity: "error",
            tool: "sqlfluff",
        });
        expect(findings[1]).toMatchObject({ column: 1, fixable: false, ruleId: "LT09" });
    });

    it("returns [] on empty, no-violations, or non-JSON output", () => {
        expect(parseSqlfluffOutput("", "sql")).toEqual([]);
        expect(parseSqlfluffOutput("[]", "sql")).toEqual([]);
        expect(parseSqlfluffOutput("not json", "sql")).toEqual([]);
    });
});
```