ormer 0.1.0

The simplest ORM for Rust.
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

use ormer::Model;
use ormer::abstract_layer::DbType;
use ormer::generate_create_table_sql;

#[derive(Debug, Model)]
#[table = "test_users"]
struct TestUser {
    #[primary(auto)]
    id: i32,
    #[unique]
    name: String,
    #[index]
    age: i32,
    email: Option<String>,
}

#[derive(Debug, Model)]
#[table = "test_roles"]
struct TestRole {
    #[primary]
    id: i32,
    #[unique(group = 1)]
    uid: i32,
    #[unique(group = 1)]
    name: String,
}

#[test]
fn test_generate_sql_with_new_features() {
    let user_sql = generate_create_table_sql::<TestUser>(DbType::Turso);
    println!("User SQL: {}", user_sql);

    // 验证 AUTOINCREMENT
    assert!(
        user_sql.contains("AUTOINCREMENT"),
        "Should contain AUTOINCREMENT"
    );

    // 验证 name 字段的 UNIQUE
    assert!(
        user_sql.contains("name TEXT NOT NULL UNIQUE"),
        "name should be UNIQUE"
    );

    // 验证 age 字段的索引（索引是单独的语句）
    assert!(
        user_sql.contains("CREATE INDEX"),
        "Should contain CREATE INDEX"
    );
    assert!(
        user_sql.contains("idx_test_users_age"),
        "Should have index on age"
    );

    let role_sql = generate_create_table_sql::<TestRole>(DbType::Turso);
    println!("Role SQL: {}", role_sql);

    // 验证没有 AUTOINCREMENT（因为主键没有 auto）
    assert!(
        !role_sql.contains("AUTOINCREMENT"),
        "Should NOT contain AUTOINCREMENT"
    );

    // 验证联合唯一约束
    assert!(
        role_sql.contains("UNIQUE (uid, name)"),
        "Should have UNIQUE (uid, name)"
    );
}