sqltool 0.4.1

功能强大的数据库迁移、同步、运维工具，支持自动分库分表、慢查询检测、数据对比、备份恢复，提供多语言SDK
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
77
78
79
80
81
82
83
84
85
86
87
88

use sqltool::{SmartFieldMatcher, TableSchema, Field};

#[test]
fn test_smart_field_matching() {
    // 创建源表结构
    let source_schema = TableSchema {
        name: "users".to_string(),
        fields: vec![
            Field {
                name: "id".to_string(),
                data_type: "int".to_string(),
                length: Some(11),
                nullable: false,
                default_value: None,
                primary_key: true,
                auto_increment: true,
            },
            Field {
                name: "name".to_string(),
                data_type: "varchar".to_string(),
                length: Some(255),
                nullable: false,
                default_value: None,
                primary_key: false,
                auto_increment: false,
            },
            Field {
                name: "email".to_string(),
                data_type: "varchar".to_string(),
                length: Some(255),
                nullable: false,
                default_value: None,
                primary_key: false,
                auto_increment: false,
            },
        ],
        indexes: vec![],
        foreign_keys: vec![],
    };

    // 创建目标表结构
    let target_schema = TableSchema {
        name: "customers".to_string(),
        fields: vec![
            Field {
                name: "id".to_string(),
                data_type: "int".to_string(),
                length: Some(11),
                nullable: false,
                default_value: None,
                primary_key: true,
                auto_increment: true,
            },
            Field {
                name: "full_name".to_string(),
                data_type: "varchar".to_string(),
                length: Some(255),
                nullable: false,
                default_value: None,
                primary_key: false,
                auto_increment: false,
            },
            Field {
                name: "email_address".to_string(),
                data_type: "varchar".to_string(),
                length: Some(255),
                nullable: false,
                default_value: None,
                primary_key: false,
                auto_increment: false,
            },
        ],
        indexes: vec![],
        foreign_keys: vec![],
    };

    // 创建智能字段匹配器
    let matcher = SmartFieldMatcher::with_default_config();

    // 执行匹配
    let mappings = matcher.match_fields(&source_schema, &target_schema);

    // 验证匹配结果
    assert_eq!(mappings.len(), 3);
    assert!(mappings.iter().any(|m| m.source_field == "id" && m.target_field == "id"));
    assert!(mappings.iter().any(|m| m.source_field == "name" && m.target_field == "full_name"));
    assert!(mappings.iter().any(|m| m.source_field == "email" && m.target_field == "email_address"));
}