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: https://github.com/andywer/postguard/blob/e9f6ed36a76c9a706f18b997a9044426831706e5/src/cli.ts#L66-L77

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/[email protected]/

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.