Skip to main content

Crate sz_orm_macros

Crate sz_orm_macros 

Source
Expand description

SZ-ORM Procedural Macros - compile-time SQL validation & derive macros

Provides:

  • sql_string! macro that validates SQL string literals at compile time. Errors like SELECT * FORM users or '; DROP TABLE are caught before the binary is built.
  • #[derive(Schema)] — auto-generate table structure info from a struct.
  • #[derive(Builder)] — auto-generate builder pattern code for a struct.

§Usage

use sz_orm_macros::sql_string;

// Basic usage
let sql = sql_string!("SELECT * FROM users WHERE id = 1"); // ✅ compiles

// With parameter count check
let sql = sql_string!("SELECT * FROM users WHERE id = ?");
                     params: 1);                          // ✅ compiles

// ❌ compile error: missing FROM
let sql = sql_string!("SELECT * users WHERE id = 1");

// ❌ compile error: SQL injection detected
let sql = sql_string!("SELECT * FROM users WHERE name = 'x' OR '1'='1'");

// ❌ compile error: parameter count mismatch
let sql = sql_string!("SELECT * FROM users WHERE id = ?");
                     params: 2);

§Derive macros

use sz_orm_macros::{Schema, Builder};

#[derive(Schema)]
#[table(name = "users")]
struct User {
    #[column(primary_key)]
    id: i64,
    name: String,
}

#[derive(Builder)]
struct Order {
    id: i64,
    total: f64,
}

Macros§

query
Compile-time SQL validation with optional real DB verification.
schema
Compile-time SQL schema generator.
sql_string
Compile-time SQL validation macro.
typed_query
Diesel 风格强类型 AST 宏(与 sql_string! / query! 并存)。

Derive Macros§

Builder
派生宏:自动生成构造器模式代码。
Schema
派生宏:自动从 Rust 结构体生成表结构信息。