Programmatic usage / Use without squid?

[JamesRamm]

Hi,
Looks like a great tool 👍
Is it possible to use programmatically and without squid?

We have a large codebase which uses knex. Changing to use squid is a significant amount of work. However we would love to use this tool to check all possible SQL variations we generate and preferably do it programmatically within our unit tests.
Since knex can generate the plain SQL strings, is there a way to simply pass a SQL string for validation?

[albohlabs]

@JamesRamm Do you found a solution for your use case?

[shellscape]

This is basically all you need to duplicate:

postguard/src/cli.ts

Lines 66 to 77 in e9f6ed3

	const { queries, tableSchemas } = parseSourceFile(loadSourceFile(filePath))
	// TODO: Check that no table is defined twice
	allQueries = [...allQueries, ...queries]
	allTableSchemas = [...allTableSchemas, ...tableSchemas]
	}
	checkSchemasForDuplicates(allTableSchemas)
	for (const query of allQueries) {
	validateQuery(query, allTableSchemas)
	}

As there's no "main" property in package.json, you'll need to specify the path. So

import { loadSourceFile, parseSourceFile } from "./parser"

will become

import { loadSourceFile, parseSourceFile } from "postguard/dist/parser"

You can view the package contents here: https://unpkg.com/browse/postguard@0.2.0/

The package doesn't ship any types either, so you'll have to redefine them in your app: https://github.com/andywer/postguard/blob/e9f6ed36a76c9a706f18b997a9044426831706e5/src/types.ts

I pinged the owner on twitter about updating things to avoid those steps, we'll see if they respond.