sea-query 0.9.6

A database agnostic runtime query builder for Rust
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

use sea_query::Iden;

#[derive(Iden)]
enum User {
    Table,
    Id,
    FirstName,
    LastName,
    Email,
}

#[derive(Iden)]
// Outer iden attributes overrides what's used for "Table"...
#[iden = "user"]
enum Custom {
    Table,
    #[iden = "my_id"]
    Id,
    #[iden = "name"]
    FirstName,
    #[iden = "surname"]
    LastName,
    // Custom casing if needed
    #[iden = "EMail"]
    // the tuple variant will be ignored
    Email(String),
    // Custom method
    #[method = "custom_to_string"]
    Custom(String),
}

impl Custom {
    pub fn custom_to_string(&self) -> &str {
        match self {
            Self::Custom(custom) => custom,
            _ => panic!("not Custom::Custom"),
        }
    }
}

#[derive(Iden)]
enum Something {
    // ...the Table can also be overwritten like this
    #[iden = "something_else"]
    Table,
    Id,
    AssetName,
    UserId,
}

#[derive(Iden)]
pub struct SomeType;
#[derive(Iden)]
#[iden = "another_name"]
pub struct CustomName;

fn main() {
    println!("Default field names");
    assert_eq!(dbg!(Iden::to_string(&User::Table)), "user");
    assert_eq!(dbg!(Iden::to_string(&User::Id)), "id");
    assert_eq!(dbg!(Iden::to_string(&User::FirstName)), "first_name");
    assert_eq!(dbg!(Iden::to_string(&User::LastName)), "last_name");
    assert_eq!(dbg!(Iden::to_string(&User::Email)), "email");

    println!("Custom field names");
    assert_eq!(dbg!(Iden::to_string(&Custom::Table)), "user");
    assert_eq!(dbg!(Iden::to_string(&Custom::Id)), "my_id");
    assert_eq!(dbg!(Iden::to_string(&Custom::FirstName)), "name");
    assert_eq!(dbg!(Iden::to_string(&Custom::LastName)), "surname");
    assert_eq!(dbg!(Iden::to_string(&Custom::Email("chris@gmail.com".to_owned()))), "EMail");
    assert_eq!(dbg!(Iden::to_string(&Custom::Custom("hello".to_owned()))), "hello");

    println!("Single custom field name");
    assert_eq!(dbg!(Iden::to_string(&Something::Table)), "something_else");
    assert_eq!(dbg!(Iden::to_string(&Something::Id)), "id");
    assert_eq!(dbg!(Iden::to_string(&Something::AssetName)), "asset_name");
    assert_eq!(dbg!(Iden::to_string(&Something::UserId)), "user_id");

    println!("Unit structs");
    assert_eq!(dbg!(Iden::to_string(&SomeType)), "some_type");
    assert_eq!(dbg!(Iden::to_string(&CustomName)), "another_name");
}