vespertide-query 0.1.61

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
43
44
45
46
47
48
49
50
51
52
53
54
55
56

use sea_query::{Alias, Table};

use super::types::BuiltQuery;

pub fn build_rename_column(table: &str, from: &str, to: &str) -> BuiltQuery {
    let stmt = Table::alter()
        .table(Alias::new(table))
        .rename_column(Alias::new(from), Alias::new(to))
        .to_owned();
    BuiltQuery::AlterTable(Box::new(stmt))
}

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

    #[rstest]
    #[case::rename_column_postgres(
        "rename_column_postgres",
        DatabaseBackend::Postgres,
        &["ALTER TABLE \"users\" RENAME COLUMN \"email\" TO \"contact_email\""]
    )]
    #[case::rename_column_mysql(
        "rename_column_mysql",
        DatabaseBackend::MySql,
        &["ALTER TABLE `users` RENAME COLUMN `email` TO `contact_email`"]
    )]
    #[case::rename_column_sqlite(
        "rename_column_sqlite",
        DatabaseBackend::Sqlite,
        &["ALTER TABLE \"users\" RENAME COLUMN \"email\" TO \"contact_email\""]
    )]
    fn test_rename_column(
        #[case] title: &str,
        #[case] backend: DatabaseBackend,
        #[case] expected: &[&str],
    ) {
        let result = build_rename_column("users", "email", "contact_email");
        let sql = result.build(backend);
        for exp in expected {
            assert!(
                sql.contains(exp),
                "Expected SQL to contain '{}', got: {}",
                exp,
                sql
            );
        }

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