/
database_setup.rs
65 lines (50 loc) · 1.73 KB
/
database_setup.rs
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
use support::{database, project};
#[test]
fn database_setup_creates_database() {
let p = project("database_setup_creates_database")
.folder("migrations")
.build();
let db = database(&p.database_url());
// sanity check
assert!(!db.exists());
let result = p.command("database")
.arg("setup")
.run();
assert!(result.is_success(), "Result was unsuccessful {:?}", result);
assert!(result.stdout().contains("Creating database:"),
"Unexpected stdout {}", result.stdout());
assert!(db.exists());
}
#[test]
fn database_setup_creates_schema_table () {
let p = project("database_setup_creates_schema_table")
.folder("migrations")
.build();
let db = database(&p.database_url());
// sanity check
assert!(!db.exists());
let result = p.command("database")
.arg("setup")
.run();
assert!(result.is_success(), "Result was unsuccessful {:?}", result);
assert!(db.table_exists("__diesel_schema_migrations"));
}
#[test]
fn database_setup_runs_migrations_if_no_schema_table() {
let p = project("database_setup_runs_migrations_if_no_schema_table")
.folder("migrations")
.build();
let db = database(&p.database_url());
p.create_migration("12345_create_users_table",
"CREATE TABLE users ( id INTEGER )",
"DROP TABLE users");
// sanity check
assert!(!db.exists());
let result = p.command("database")
.arg("setup")
.run();
assert!(result.is_success(), "Result was unsuccessful {:?}", result);
assert!(result.stdout().contains("Running migration 12345"),
"Unexpected stdout {}", result.stdout());
assert!(db.table_exists("users"));
}