statiq 0.2.4

Zero-overhead, compile-time MSSQL service for Rust — stored procedures, async CRUD, connection pooling, static dispatch
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

use serde::{de::DeserializeOwned, Serialize};

use crate::error::SqlError;
use crate::params::{OdbcParam, PkValue};
use crate::row::OdbcRow;

/// Implemented automatically by `#[derive(SqlEntity)]`.
///
/// Supertrait bounds:
/// - `Serialize + DeserializeOwned` — required for Redis caching
/// - `Send + Sync + 'static` — required for async pool dispatch
pub trait SqlEntity: Sized + Send + Sync + 'static + Serialize + DeserializeOwned {
    const TABLE_NAME: &'static str;
    const SCHEMA: &'static str;

    const SELECT_COLS: &'static str;
    const SELECT_SQL: &'static str;
    const SELECT_BY_PK_SQL: &'static str;
    const INSERT_SQL: &'static str;
    const UPDATE_SQL: &'static str;
    const DELETE_SQL: &'static str;
    const UPSERT_SQL: &'static str;
    const COUNT_SQL: &'static str;
    const EXISTS_SQL: &'static str;

    const PK_COLUMN: &'static str;
    const PK_IS_IDENTITY: bool;

    const CACHE_PREFIX: &'static str;
    const COLUMN_COUNT: usize;

    fn from_row(row: &OdbcRow) -> Result<Self, SqlError>;
    fn to_params(&self) -> Vec<OdbcParam>;
    fn pk_value(&self) -> PkValue;
}