vespertide-query 0.2.1

Converts migration actions into SQL statements with bind parameters
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

#[cfg(test)]
mod tests {
    use crate::sql::types::DatabaseBackend;
    use crate::sql::{BuiltQuery, RawSql};
    use insta::{assert_snapshot, with_settings};
    use rstest::rstest;

    #[rstest]
    #[case::raw_sql_action_postgres(
        "raw_sql_action_postgres",
        DatabaseBackend::Postgres,
        &["SELECT 1"]
    )]
    #[case::raw_sql_action_mysql(
        "raw_sql_action_mysql",
        DatabaseBackend::MySql,
        &["SELECT 1"]
    )]
    #[case::raw_sql_action_sqlite(
        "raw_sql_action_sqlite",
        DatabaseBackend::Sqlite,
        &["SELECT 1"]
    )]
    fn test_raw_sql(
        #[case] title: &str,
        #[case] backend: DatabaseBackend,
        #[case] expected: &[&str],
    ) {
        let result = BuiltQuery::Raw(RawSql::uniform("SELECT 1".into()));
        let sql = result.build(backend);
        for exp in expected {
            assert!(
                sql.contains(exp),
                "Expected SQL to contain '{exp}', got: {sql}"
            );
        }

        with_settings!({ snapshot_suffix => format!("raw_sql_{}", title) }, {
            assert_snapshot!(sql);
        });
    }
}