sntl 0.1.0

Compile-time guarded ORM for PostgreSQL — your data's guardian from compile to production
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

use crate::core::expr::Expr;
use crate::core::query::{DeleteQuery, SelectQuery};
use crate::core::types::Value;

/// Metadata for a single column in a model.
pub struct ModelColumn {
    pub name: &'static str,
    pub column_type: &'static str,
    pub nullable: bool,
    pub has_default: bool,
}

/// Core trait that all Sentinel models implement.
///
/// In Phase 2, `#[derive(Model)]` generates this automatically.
/// For Phase 1, models implement this manually for testing.
pub trait Model {
    /// The PostgreSQL table name.
    const TABLE: &'static str;

    /// The primary key column name (default: "id").
    const PRIMARY_KEY: &'static str;

    /// Returns column metadata for this model.
    fn columns() -> &'static [ModelColumn];

    /// Start a SELECT query for this model's table.
    fn find() -> SelectQuery {
        SelectQuery::new(Self::TABLE)
    }

    /// SELECT ... WHERE id = $1
    fn find_by_id(id: Value) -> SelectQuery {
        SelectQuery::new(Self::TABLE).where_(Expr::Compare {
            column: format!("\"{}\"", Self::PRIMARY_KEY),
            op: "=",
            value: id,
        })
    }

    /// DELETE ... WHERE id = $1
    fn delete(id: Value) -> DeleteQuery {
        DeleteQuery::new(Self::TABLE).where_id(id)
    }
}