Tiberius Row

tiberius_row 是一个Rust过程宏库，用于简化从Tiberius SQL Server客户端获取的行数据到Rust结构体的转换过程。

功能特点

• 提供Row_Ext派生宏，自动为结构体实现从Tiberius行数据到Rust结构体的转换
• 支持多种SQL数据类型，包括整数、浮点数、字符串、日期时间等
• 使用serde进行数据反序列化，提供类型安全的数据访问
• 自动处理NULL值
• 提供友好的错误处理

安装

在你的Cargo.toml文件中添加以下依赖：

[dependencies]

tiberius_row = "0.1.0"

base64 = "0.22.1"

tiberius = { version = "0.12.3", features = ["chrono", "rust_decimal", "time"] }

serde = { version = "1.0", features = ["derive"] }

serde_json = "1.0.140"

anyhow = "1.0"

使用方法

1. 首先，为你的结构体派生必要的特性：

use serde::Deserialize;
use tiberius_row::Row_Ext;

#[derive(Deserialize, Row_Ext)]
struct User {
    id: i32,
    name: String,
    email: Option<String>,
    created_at: chrono::DateTime<chrono::Utc>,
}

2. 然后，你可以直接从Tiberius的Row转换为你的结构体：

use anyhow::Result;
use tiberius::Client;

async fn get_user(client: &mut Client<Connection>, user_id: i32) -> Result<User> {
    let query = "SELECT id, name, email, created_at FROM users WHERE id = @P1";
    let stream = client.query(query, &[&user_id]).await?;
    let row = stream.into_row().await?.expect("No user found");
    
    // 使用派生的from_row方法
    let user = User::from_row(row)?;
    Ok(user)
}

支持的数据类型

下表展示了SQL Server数据类型与Rust类型的对应关系：

错误处理

该库使用anyhow进行错误处理，当遇到不支持的列数据类型或反序列化失败时会返回适当的错误。

许可证

MIT

贡献

欢迎提交问题和拉取请求！

Tiberius Row (English Version)

tiberius_row is a Rust procedural macro library designed to simplify the conversion of row data from the Tiberius SQL Server client to Rust structures.

Features

• Provides a Row_Ext derive macro that automatically implements conversion from Tiberius row data to Rust structures
• Supports various SQL data types including integers, floating-point numbers, strings, date-time, etc.
• Uses serde for data deserialization, providing type-safe data access
• Automatically handles NULL values
• Provides friendly error handling

Installation

Add the following dependencies to your Cargo.toml file:

[dependencies]

tiberius_row = "0.1.0"

base64 = "0.22.1"

tiberius = { version = "0.12.3", features = ["chrono", "rust_decimal", "time"] }

serde = { version = "1.0", features = ["derive"] }

serde_json = "1.0.140"

anyhow = "1.0"

Usage

1. First, derive the necessary traits for your structure:

use serde::Deserialize;
use tiberius_row::Row_Ext;

#[derive(Deserialize, Row_Ext)]
struct User {
    id: i32,
    name: String,
    email: Option<String>,
    created_at: chrono::DateTime<chrono::Utc>,
}

2. Then, you can convert directly from a Tiberius Row to your structure:

use anyhow::Result;
use tiberius::Client;

async fn get_user(client: &mut Client<Connection>, user_id: i32) -> Result<User> {
    let query = "SELECT id, name, email, created_at FROM users WHERE id = @P1";
    let stream = client.query(query, &[&user_id]).await?;
    let row = stream.into_row().await?.expect("No user found");
    
    // Use the derived from_row method
    let user = User::from_row(row)?;
    Ok(user)
}

Supported Data Types

The following table shows the correspondence between SQL Server data types and Rust types:

Error Handling

This library uses anyhow for error handling, returning appropriate errors when encountering unsupported column data types or deserialization failures.

License

MIT

Contributions

Issues and pull requests are welcome!