drizzle-cli 0.4.2

Command-line interface for drizzle-rs migrations
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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76

use assert_cmd::cargo::cargo_bin_cmd;
use std::fs;
use tempfile::tempdir;

#[test]
fn generate_preserves_mysql_storage_and_type_options() {
    let dir = tempdir().expect("create MySQL-specific temp directory");
    let root = dir.path();
    let config = root.join("drizzle.config.toml");
    let schema = root.join("schema.rs");
    let out = root.join("generated");
    let driver = if cfg!(feature = "mysql-sync") {
        "mysql-sync"
    } else {
        "mysql-async"
    };

    fs::write(
        &schema,
        r#"
#[derive(MySQLEnum)]
enum State { Draft, Published }

#[MySQLTable(NAME = "mysql_storage_contract", ENGINE = "InnoDB", CHARSET = "utf8mb4")]
struct Documents {
    #[column(PRIMARY, AUTO_INCREMENT)]
    id: u64,
    #[column(ENUM)]
    state: State,
    sequence: u32,
    #[column(generated(STORED, "sequence + 1"))]
    next_sequence: u32,
}

#[MySQLIndex(unique, using = "BTREE", algorithm = "INPLACE", lock = "NONE")]
struct DocumentsState(Documents::state);
"#,
    )
    .expect("write MySQL-specific schema");
    fs::write(
        &config,
        format!(
            "dialect = \"mysql\"\ndriver = \"{driver}\"\nschema = '{}'\nout = '{}'\n\n[dbCredentials]\nurl = \"mysql://drizzle:drizzle@127.0.0.1:3307/drizzle_test\"\n",
            schema.to_string_lossy(),
            out.to_string_lossy(),
        ),
    )
    .expect("write MySQL-specific config");

    cargo_bin_cmd!("drizzle")
        .current_dir(root)
        .args([
            "--config",
            &config.to_string_lossy(),
            "generate",
            "--driver",
            driver,
            "--name",
            "mysql_storage",
        ])
        .assert()
        .success();

    let migration_path = fs::read_dir(&out)
        .expect("read MySQL migration output")
        .filter_map(Result::ok)
        .find(|entry| entry.file_type().is_ok_and(|kind| kind.is_dir()))
        .map(|entry| entry.path().join("migration.sql"))
        .expect("find MySQL migration");
    let migration = fs::read_to_string(migration_path).expect("read MySQL migration");
    assert!(migration.contains("InnoDB"));
    assert!(migration.contains("utf8mb4"));
    assert!(migration.contains("enum('Draft', 'Published')"));
    assert!(migration.contains("GENERATED ALWAYS AS (sequence + 1) STORED"));
    assert!(migration.contains("USING BTREE"));
}