GitHub - valoricDe/postgres-schema-updater: This npm cli module will detect changes in your schema, and apply them to your database

valoricDe / postgres-schema-updater Public

Notifications You must be signed in to change notification settings
Fork 0
Star 5

This npm cli module will detect changes in your schema, and apply them to your database

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 11 Commits
.idea		.idea
bin		bin
lib		lib
vendor/apgdiff-2.4		vendor/apgdiff-2.4
.babelrc		.babelrc
.gitignore		.gitignore
.npmignore		.npmignore
LICENSE		LICENSE
README		README
package-lock.json		package-lock.json
package.json		package.json
tsconfig.json		tsconfig.json

Repository files navigation

### How to use

you can configure parameters with a .env file or via env variable.

The .env file could have contents like:
```
CONNECTION_STRING=postgres://admin:1234@localhost:5432/apidb
SOURCE=sql/src/**/*sql
TMP_FILE=sql/development.sql
COMPARE_FILE=sql/staging.sql
```

```
cd  example
node ../bin/stage.js -v -c "postgres://postgres@localhost:5432/YOUR_DB"
```

or add "my-stage": "stage" to your scripts section of the package.json file and call stage like:

```
npm run my-stage -- -v -c "postgres://postgres@localhost:5432/YOUR_DB
```

You will be asked before anything is performed on the database.