sqlx-testcontainers 0.3.0

use testcontainers to isolate sqlx tests
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

#[sqlx_testcontainers::test]
async fn test_basic(mut conn: sqlx::postgres::PgConnection) {
    let row: (i32,) = sqlx::query_as("SELECT 1 + 1")
        .fetch_one(&mut conn)
        .await
        .expect("Failed to execute query");
    assert_eq!(row.0, 2);
}

#[sqlx_testcontainers::test(tag = "14-alpine")]
async fn test_with_tag(mut conn: sqlx::postgres::PgConnection) {
    let row: (String,) = sqlx::query_as("SELECT version()")
        .fetch_one(&mut conn)
        .await
        .expect("Failed to execute query");
    assert!(row.0.contains("PostgreSQL 14"));
}

#[sqlx_testcontainers::test(migrations = "./migrations")]
async fn test_with_migrations_path(mut conn: sqlx::postgres::PgConnection) {
    let row: (i64,) = sqlx::query_as("SELECT count(*) FROM test")
        .fetch_one(&mut conn)
        .await
        .expect("Failed to execute query");
    assert_eq!(row.0, 0);
}