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
|
//! Other simple table/ column migrations
#![allow(unused_imports)]
use crate::backend::{MySql, SqlGenerator};
#[test]
fn create_table() {
let sql = MySql::create_table("table_to_create", None);
assert_eq!(String::from("CREATE TABLE `table_to_create`"), sql);
}
#[test]
fn create_table_with_schema() {
let sql = MySql::create_table("table_to_create", Some("my_schema"));
assert_eq!(String::from("CREATE TABLE `my_schema`.`table_to_create`"), sql);
}
#[test]
fn create_table_if_not_exists() {
let sql = MySql::create_table_if_not_exists("table_to_create", None);
assert_eq!(
String::from("CREATE TABLE `table_to_create` IF NOT EXISTS"),
sql
);
}
#[test]
fn drop_table() {
let sql = MySql::drop_table("table_to_drop", None);
assert_eq!(String::from("DROP TABLE `table_to_drop`"), sql);
}
#[test]
fn drop_table_if_exists() {
let sql = MySql::drop_table_if_exists("table_to_drop", None);
assert_eq!(String::from("DROP TABLE `table_to_drop` IF EXISTS"), sql);
}
#[test]
fn rename_table() {
let sql = MySql::rename_table("old_table", "new_table", None);
assert_eq!(String::from("RENAME TABLE `old_table` TO `new_table`"), sql);
}
#[test]
fn alter_table() {
let sql = MySql::alter_table("table_to_alter", None);
assert_eq!(String::from("ALTER TABLE `table_to_alter`"), sql);
}
|