sqlx-repo 0.2.2

repository pattern on top of sqlx
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

use sqlx_repo::prelude::*;

const fn migration_test() -> Migration {
    migration!(
        "first migration",
        "create table test(id int primary key autoincrement)"
    )
}

const fn migration_select_items() -> Migration {
    migration!("create select_items", "create table select_items(id int)")
}

const fn migration_select_pairs() -> Migration {
    migration!(
        "create select_pairs",
        "create table select_pairs(category int, value int)"
    )
}

const fn migration_seed_select_items() -> Migration {
    migration!(
        "seed select_items",
        "insert into select_items values (1), (2), (3), (4), (5)"
    )
}

const fn migration_seed_select_pairs() -> Migration {
    migration!(
        "seed select_pairs",
        "insert into select_pairs values (1, 10), (1, 20), (2, 30), (2, 40), (3, 50)"
    )
}

pub fn all_migrations() -> &'static [Migration] {
    static MIGRATIONS: &[Migration] = &[
        migration_test(),
        migration_select_items(),
        migration_select_pairs(),
        migration_seed_select_items(),
        migration_seed_select_pairs(),
    ];
    MIGRATIONS
}