Ts-slonik-live-server-plugin NPM

ts-slonik-live-server-plugin

Typescript language server plugin for slonik.

This plugin tests slonik sql template tag queries, suggests table & column names and checks it's cost against a live database.

Installation

yarn add -D ts-slonik-live-server-plugin

npm i -D ts-slonik-live-server-plugin

Settings

Add to plugins section in tsconfig.json:

{
  "compilerOptions": {
    ...
    "plugins": [
      {
        "name": "ts-slonik-live-server-plugin",
        "dotEnv": "../.env",
        "pg": {
          "uri": "postgresql://localhost/postgres",
          "defaultSchema": "public",
          "infoTtl": 5000,
          "include": {
            "schema": ["public", "users"],
            "table": ["schema1.table1"]
          },
          "exclude": {
            "table": ["schema1.table1"]
          }
        },
        "cost": {
          "info": true,
          "threshold": {
            "error": 100,
            "warning": 50
          }
        }
      }
    ]
  }
}

VS Code

https://github.com/microsoft/TypeScript/wiki/Writing-a-Language-Service-Plugin#testing-locally

Note: If you're using Visual Studio Code, you'll have to use the first approach above, with a path to the module, or run the "TypeScript: Select TypeScript Version" command and choose "Use Workspace > Version", or click the version number between "TypeScript" and 😃 in the lower-right corner. Otherwise, VS Code will not be able to find your plugin.

Postgres connection

Connection settings can be defined by following options:

pg.uri

If pg.uri is set under plugin setting in tsconfig.json, any .env configuration will be ignored.

.env

The plugin will by default look for .env file in project root. If the file is located elsewhere (e.g. monorepo), you can add it's relative path to the project root with dotEnv setting.

You can use node-postgres environment variables in .env file, or you can define Postgres connection URI with PGURI environment variable. If PGURI is defined, any node-postgres environment variables will be ignored.

Schemas and tables

By default, any tables in public schema will be tested against. You can override this preset with include and exclude rules.

pg.defaultSchema

Default: public

If your default schema is other than public, add it's name to defaultSchema option.

pg.infoTtl

Default: 5000

TTL (in milliseconds) of DB information. The DB information (a.k.a. Database schema in broader RDBMS terminolgy) will be only refetched after the TTL have surpassed from last load time.