kurtbuilds_sql 0.26.2

Structs representing sql queries, enabling query building, migrations, and more
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

use crate::query::Expr;
use crate::schema::constraint::Constraint;
use crate::util::SqlExtension;
use crate::{Dialect, Generated, ToSql, Type};

#[derive(Debug, Clone, PartialEq, Eq)]
#[cfg_attr(feature = "serde", derive(serde::Serialize, serde::Deserialize))]
pub struct Column {
    pub name: String,
    pub typ: Type,
    pub nullable: bool,
    pub primary_key: bool,
    #[cfg_attr(
        feature = "serde",
        serde(default, skip_serializing_if = "Option::is_none")
    )]
    pub default: Option<Expr>,
    #[cfg_attr(
        feature = "serde",
        serde(default, skip_serializing_if = "Option::is_none")
    )]
    pub constraint: Option<Constraint>,
    #[cfg_attr(
        feature = "serde",
        serde(default, skip_serializing_if = "Option::is_none")
    )]
    pub generated: Option<Generated>,
}

impl ToSql for Column {
    fn write_sql(&self, buf: &mut String, dialect: Dialect) {
        buf.push_quoted(&self.name);
        buf.push(' ');
        buf.push_str(&self.typ.to_sql(dialect));
        if let Some(generated) = &self.generated {
            buf.push(' ');
            buf.push_sql(generated, dialect);
        }
        if !self.nullable {
            buf.push_str(" NOT NULL");
        }
        if self.primary_key {
            buf.push_str(" PRIMARY KEY");
        }
        if let Some(default) = &self.default {
            buf.push_str(" DEFAULT ");
            buf.push_sql(default, dialect);
        }
        if let Some(constraint) = &self.constraint {
            buf.push(' ');
            buf.push_sql(constraint, dialect);
        }
    }
}