rquery-orm 1.0.0

Lightweight SQL ORM for Rust with query-style (MSSQL + PostgreSQL).
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

use crate::query::{PlaceholderStyle, SqlParam};

pub struct ColumnMeta {
    pub name: &'static str,
    pub required: bool,
    pub allow_null: bool,
    pub max_length: Option<usize>,
    pub min_length: Option<usize>,
    pub allow_empty: bool,
    pub regex: Option<&'static str>,
    pub error_max_length: Option<&'static str>,
    pub error_min_length: Option<&'static str>,
    pub error_required: Option<&'static str>,
    pub error_allow_null: Option<&'static str>,
    pub error_allow_empty: Option<&'static str>,
    pub error_regex: Option<&'static str>,
    pub ignore: bool,
    pub ignore_in_update: bool,
    pub ignore_in_insert: bool,
    pub ignore_in_delete: bool,
}

pub struct KeyMeta {
    pub column: &'static str,
    pub is_identity: bool,
    pub ignore_in_update: bool,
    pub ignore_in_insert: bool,
}

pub struct RelationMeta {
    pub name: &'static str,
    pub foreign_key: &'static str,
    pub table: &'static str,
    pub table_number: Option<u32>,
    pub ignore_in_update: bool,
    pub ignore_in_insert: bool,
}

pub struct TableMeta {
    pub name: &'static str,
    pub schema: Option<&'static str>,
    pub columns: &'static [ColumnMeta],
    pub keys: &'static [KeyMeta],
    pub relations: &'static [RelationMeta],
}

pub trait Entity {
    fn table() -> &'static TableMeta;
}

pub trait FromRowNamed: Sized {
    fn from_row_ms(row: &tiberius::Row) -> anyhow::Result<Self>;
    fn from_row_pg(row: &tokio_postgres::Row) -> anyhow::Result<Self>;
}

// Like FromRowNamed, but expects column names to be prefixed with
// a short identifier, e.g., "t_ColumnName" or "u_ColumnName".
pub trait FromRowWithPrefix: Sized {
    fn from_row_ms_with(row: &tiberius::Row, prefix: &str) -> anyhow::Result<Self>;
    fn from_row_pg_with(row: &tokio_postgres::Row, prefix: &str) -> anyhow::Result<Self>;
}

pub trait Validatable {
    fn validate(&self) -> Result<(), Vec<String>>;
}

pub trait Persistable {
    fn build_insert(&self, style: PlaceholderStyle) -> (String, Vec<SqlParam>, bool);
    fn build_update(&self, style: PlaceholderStyle) -> (String, Vec<SqlParam>);
    fn build_delete(&self, style: PlaceholderStyle) -> (String, Vec<SqlParam>);
    fn build_delete_by_key(key: SqlParam, style: PlaceholderStyle) -> (String, Vec<SqlParam>);
}

pub trait KeyAsInt {
    fn key(&self) -> i32;
}

pub trait KeyAsGuid {
    fn key(&self) -> uuid::Uuid;
}

pub trait KeyAsString {
    fn key(&self) -> String;
}