ormer 0.1.10

An ORM framework with a usage style similar to Linq, supporting Sqlite, PostgresQL, MySQL, MSSQL
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

#![cfg(any(feature = "sqlite", feature = "postgresql", feature = "mysql"))]

use ormer::Model;

mod _test_common;

// 使用宏定义测试专用模型（唯一表名）
define_test_user_simple!(TestUser, "syntax_validation_users_1");

#[cfg(test)]
mod syntax_validation {
    use super::*;
    // ColumnBuilder is used for future tests
    #[allow(unused_imports)]
    use ormer::query::builder::ColumnBuilder;

    // 注意：为了让语法工作，我们需要为 TestUser 实现字段访问
    // 这需要通过过程宏生成，但这里我们先演示概念

    async fn test_model_constants_impl(config: &_test_common::DbConfig) {
        let _config = config; // 仅用于获取数据库类型
        // 验证 Model trait 实现正确
        assert_eq!(TestUser::TABLE_NAME, "syntax_validation_users_1");
        assert_eq!(TestUser::COLUMNS, &["id", "name", "age"]);
    }

    async fn test_query_builder_creation_impl(config: &_test_common::DbConfig) {
        let query = TestUser::query();
        let sql = query.to_sql_with_params(config.0);
        assert_eq!(sql.0, "SELECT id, name, age FROM syntax_validation_users_1");
    }

    async fn test_query_with_filter_impl(config: &_test_common::DbConfig) {
        // 简化测试:手动创建 FilterExpr
        use ormer::FilterExpr;
        #[allow(unused_imports)]
        use ormer::query::builder::FilterValue;
        use ormer::query::filter::Value as FilterValueInner;

        // 模拟过程宏生成的代码
        let _filter = FilterExpr::Comparison {
            column: "age".to_string(),
            operator: ">".to_string(),
            value: FilterValueInner::Integer(18),
        };

        // 这里展示最终用户代码在过程宏展开后的效果
        // 用户写:.filter(|u| u.age.gt(18))
        // 宏展开为:.filter_with_expr(FilterExpr::Comparison {...})

        let sql = TestUser::query().to_sql_with_params(config.0);
        assert!(sql.0.contains("SELECT"));
        assert!(sql.0.contains("FROM syntax_validation_users_1"));
    }

    async fn test_complex_query_impl(config: &_test_common::DbConfig) {
        #[allow(unused_imports)]
        use ormer::{OrderBy, OrderDirection};

        // offset方法已被range替代，使用range(start..end)语法
        let query = TestUser::query().range(20..30);

        let sql = query.to_sql_with_params(config.0);

        assert!(sql.0.contains("LIMIT 10"));
        assert!(sql.0.contains("OFFSET 20"));
    }

    async fn test_sql_generation_placeholders_impl(config: &_test_common::DbConfig) {
        // 验证 SQL 生成使用占位符（防 SQL 注入）
        let query = TestUser::query().range(..10);

        let sql = query.to_sql_with_params(config.0);

        // PostgreSQL 使用 $1, $2 等占位符
        // 这里验证基本结构
        assert!(sql.0.starts_with("SELECT"));
        assert!(sql.0.contains("FROM syntax_validation_users_1"));
    }

    test_on_all_dbs!(test_model_constants_impl);
    test_on_all_dbs!(test_query_builder_creation_impl);
    test_on_all_dbs!(test_query_with_filter_impl);
    test_on_all_dbs!(test_complex_query_impl);
    test_on_all_dbs!(test_sql_generation_placeholders_impl);
}