# core/parsers/tool.sqlfluff.parser.ts

> 22 lines of code and 2 definitions.

Tree: GovLab Quality
Language: typescript
Layer: processing
Canonical: https://banes-lab.com/anatomy/quality#file-quality-core-parsers-tool-sqlfluff-parser-ts
Source text: https://banes-lab.com/source/quality/core/parsers/tool.sqlfluff.parser.ts.txt

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

## Definitions

- `parseSqlfluffOutput` (lexical_declaration, line 9, exported)
- `TOOL` (lexical_declaration, line 7)

## Contained in

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

## Uses

- [core/factories/finding.factory.ts](https://banes-lab.com/source/quality/core/factories/finding.factory.ts.md)
- [core/parsers/record.parser.ts](https://banes-lab.com/source/quality/core/parsers/record.parser.ts.md)
- [core/selectors/record.selector.ts](https://banes-lab.com/source/quality/core/selectors/record.selector.ts.md)

## Used by

- [core/adapters/tool.sqlfluff.adapter.ts](https://banes-lab.com/source/quality/core/adapters/tool.sqlfluff.adapter.ts.md)

## Linked from

- [core/adapters](https://banes-lab.com/anatomy/quality/folder-quality-core-adapters.md)
- [core/factories](https://banes-lab.com/anatomy/quality/folder-quality-core-factories.md)
- [core/parsers](https://banes-lab.com/anatomy/quality/folder-quality-core-parsers.md)
- [core/selectors](https://banes-lab.com/anatomy/quality/folder-quality-core-selectors.md)

## Source

```typescript
import { arrayField, numberField, recordsAt, stringField } from "#core/selectors/record.selector";
import type { Finding } from "#types/finding.types";
import { POSITION } from "#configuration/constants/tool.constants";
import { parseJsonRecords } from "#core/parsers/record.parser";
import { toolFinding } from "#core/factories/finding.factory";

const TOOL = "sqlfluff";

export const parseSqlfluffOutput = function parseSqlfluffOutput(stdout: string, ecosystem: string): Finding[] {
    return parseJsonRecords(stdout || "[]").flatMap((file) =>
        recordsAt(file, "violations").map((violation) =>
            toolFinding({
                column: numberField(violation, "start_line_pos", POSITION),
                ecosystem,
                file: stringField(file, "filepath"),
                fixable: arrayField(violation, "fixes").length > 0,
                line: numberField(violation, "start_line_no", POSITION),
                message: stringField(violation, "description"),
                ruleId: stringField(violation, "code", TOOL),
                tool: TOOL,
            }),
        ),
    );
};
```