sqlx-simple-migrator 0.0.5

A very simple migration framework for sqlx and postgres
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

use super::Migration;

pub const NAME: &str = "initial";

pub fn migration() -> Migration {
    Migration::new(NAME)
        .with_up(
            r#"
        CREATE TABLE migrations (
            name TEXT NOT NULL PRIMARY KEY,
            executed_at TIMESTAMPTZ NOT NULL DEFAULT now()
        )
        "#,
        )
        .with_down(
            r#"
        DROP TABLE IF EXISTS migrations
        "#,
        )
}