pg_migrate 0.1.1

Database migration tool for PostgreSQL
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

# PG Migrate

## About
Database migration tool for PostgreSQL written in Rust.

## Features
- Create migration
- Upgrade / Downgrade database
- Get current migration
- Get head migration
- Get migrations history

## Installation

```bash
cargo install pg_migrate
```

Set up the database URL in the environment variable `DATABASE_URL`.

```bash
DATABASE_URL=postgresql://username:password@localhost/dbname
```

## CLI Usage

- Create migration:
```bash
cargo run --bin pg_migrate_cli -- new <migration name>
```

- Upgrade / Downgrade:
There is multiple options to upgrade or downgrade the database:
  - Upgrade to the latest migration:
    ```bash
    cargo run --bin pg_migrate_cli -- upgrade head
    ```
  - Upgrade / Downgrade to a specific migration by migration id:
    ```bash
    cargo run --bin pg_migrate_cli -- upgrade/downgrade migration-id <migration-id>
    ```
  - Upgrade / Downgrade by number of migrations:
    ```bash
    cargo run --bin pg_migrate_cli -- upgrade/downgrade number <number>
    ```

- Get head:
```bash
cargo run --bin pg_migrate_cli -- head
```

- Get current migration:
```bash
cargo run --bin pg_migrate_cli -- current
```

- Get migrations history
```bash
cargo run --bin pg_migrate_cli -- history
```