iso-postgresql
contains iso data for languages, countries, etc. Date comes from places like https://datahub.io/collections/reference-data.
Introduction
This package contains re-usable Postgresql sql ddl. The package is installed using a traditional node package manager such as npm, yarn or pnpm. Applying the sql located in the package to a Postgresql database instance can be done by using Sql Package Manager or a migration tool of your choosing.
This package has:
- definitions - Sql is stored within the package.
-
Testing, BDD/TDD - Testing is done using the jest testing framework but the tests are written in Sql. True behavior driven development is supported via
yarn test:postgresql:watch. - versioned - Versioning is used and supported via lerna.
- dependencies - The dependency features of the javascript package manager are leveraged. Sql Package Manager projects can depend on other projects.
Usage
// TODO
Generated
This package was generated form the root of this repository as follows:
yarn sqlpm generate '{"packageName": "iso", "databaseSystem": "postgresql", "description": "contains iso data for languages, countries, etc. Date comes from places like https://datahub.io/collections/reference-data.", "author": "...", "email": "...", "purposes": ["readwrite"], "actions": ["run", "test", "reset"]}'
yarn lerna add @sqlpm/sqlpm-lib-ts --scope=@sqlpm/iso-postgresql
# Add the universal schema dependency
yarn lerna add @sqlpm/universal-postgresql --scope=@sqlpm/iso-postgresql