@forrestjs/service-pg-schema NPM | npm.io

5.2.2 • Published 1 year ago

Install

Weekly downloads

-

License

MIT

Repository

Last release

1 year ago

pgSchema

Facilitates the maintenance of a simple PostgreSQL schema by running queries at boot time or in case of a TDD reset event.

This service depends on pg-service.

Configuration

pgSchema.build

Default: {}

Provide configuration to the build extension.

pgSchema.seed

Default: {}

Provide configuration to the seed extension.

pgSchema.reset

Default: {}

Provide configuration to the reset extension.

Extensions

$PG_SCHEMA_BUILD

const f1 = {
  target: "$PG_SCHEMA_BUILD",
  handler: async ({ query, config }) => {
    await query("CREATE TABLE ...");
    await query("CREATE TABLE ...");
  }
};

$PG_SCHEMA_SEED

const f1 = {
  target: "$PG_SCHEMA_SEED",
  handler: async ({ query, config }) => {
    await query("INSERT INTO ... ON CONFLICT DO NOTHING");
    await query("INSERT INTO ... ON CONFLICT DO NOTHING");
  }
};

$PG_SCHEMA_RESET

const f1 = {
  target: "$PG_SCHEMA_RESET",
  handler: async ({ query, config }) => {
    await query("DROP TABLE ...");
    await query("DROP TABLE ...");
  }
};

forrestjs service database postgres postgresql pg schema seed migration

@forrestjs/core

@infinitebrahmanuniverse/nolb-_forr @everything-registry/sub-chunk-338 @zalastax/nolb-_forr

1 year ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago