sqlx-migrate-validate 0.1.0

Validate your database sqlx migration state
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
61
62
63
64
65
66
67
68
69
70
71
72

use std::path::Path;

use sqlx::migrate::MigrateError;

use sqlx_migrate_validate::{Validate, ValidateError, Validator};

async fn prepare() -> sqlx_core::sqlite::SqliteConnection {
    let pool = sqlx::SqlitePool::connect("sqlite::memory:").await.unwrap();
    let mut conn = pool.acquire().await.unwrap();

    sqlx::migrate!("./tests/migrations-1")
        .run(&mut conn)
        .await
        .unwrap();

    conn.detach()
}

#[tokio::test]
async fn validate_returns_ok_with_same_migrations() {
    let mut conn = prepare().await;

    sqlx::migrate!("./tests/migrations-1")
        .validate(&mut conn)
        .await
        .unwrap();
}

#[tokio::test]
async fn validate_returns_err_with_more_migrations_in_source() {
    let mut conn = prepare().await;

    match Validator::new(Path::new("./tests/migrations-2"))
        .await
        .unwrap()
        .validate(&mut conn)
        .await
    {
        Err(ValidateError::VersionNotApplied(20230312141719)) => (),
        o => panic!("Expected VersionNotApplied error, got: {:?}", o),
    };
}

#[tokio::test]
async fn validate_returns_err_with_less_migrations_in_source() {
    let mut conn = prepare().await;

    match Validator::new(Path::new("./tests/migrations-3"))
        .await
        .unwrap()
        .validate(&mut conn)
        .await
    {
        Err(ValidateError::MigrateError(MigrateError::VersionMissing(20230312133715))) => (),
        o => panic!("Expected VersionMissing error, got: {:?}", o),
    };
}

#[tokio::test]
async fn validate_returns_err_with_migration_content_mismatch() {
    let mut conn = prepare().await;

    match Validator::new(Path::new("./tests/migrations-4"))
        .await
        .unwrap()
        .validate(&mut conn)
        .await
    {
        Err(ValidateError::MigrateError(MigrateError::VersionMismatch(20230312133715))) => (),
        o => panic!("Expected VersionMismatch error, got: {:?}", o),
    };
}