<commit_before># Postgres Migrations

The purpose of this library is to provide `liquibase` *like* migration capabilities as a `node` module and command line interface.

## Installation

```
npm install --global pg-migrations
```<commit_msg>Add example to readme file<commit_after># Postgres Migrations

The purpose of this library is to provide `liquibase` *like* migration capabilities as a `node` module and command line interface.

## Installation

```
npm install --global pg-migrations
```

## Usage

```
  Usage: pg-migration <schema file|directory> [options]

  Database migration tool for postgres databases

  Options:

    -h, --help                            output usage information
    -V, --version                         output the version number
    -c, --connection <connection string>  database connection string (required)
    -u, --user <user>                     database user name
    -p, --password <password>             database password
    -P, --prompt-password                 prompt for database password
    -s, --generate-script                 output sql script instead of executing the migration
```

## Example

```
pg-migration database/schema.yml -c postgres://postgres@localhost/postgres -p password
```
{'fraction_non_alphanumeric': 0.09332260659694289, 'fraction_numerical': 0.0, 'mean_word_length': 2.6588235294117646, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6010542', 'n_tokens_mistral': 331, 'n_tokens_neox': 307, 'n_words': 126}