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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
//! Builder API's module
use super::impls::{BaseType, WrapVec};
use crate::types::Type;
/// A standard primary numeric key type
///
/// It's 64-bit wide, can't be null or non-unique
/// and auto-increments on inserts.
/// Maps to `primary` on `Pg` and manually enforces
/// this behaviour for other Sql variants.
pub fn primary() -> Type {
Type::new(BaseType::Primary)
.nullable(true) // Primary keys are non-null implicitly
.increments(true) // This is ignored for now
.primary(false) // Primary keys are primary implictly
.unique(false) // Primary keys are unique implicitly
.indexed(false)
}
/// A (standardised) UUID primary key type
///
/// Similar to `primary()`, but uses a standard
/// layout UUID type, mapping to `uuid` on `Pg`
/// and not supported by all Sql variants.
pub fn uuid() -> Type {
Type::new(BaseType::UUID)
.nullable(false)
.unique(true)
.indexed(true)
}
/// Create a basic integer type
pub fn integer() -> Type {
Type::new(BaseType::Integer)
}
/// A 32-bit floating point type
pub fn float() -> Type {
Type::new(BaseType::Float)
}
/// A 64-bit floating point type
pub fn double() -> Type {
Type::new(BaseType::Double)
}
/// A boolean data type (true, false)
pub fn boolean() -> Type {
Type::new(BaseType::Boolean)
}
/// A fixed-length string type
pub fn varchar(len: usize) -> Type {
Type::new(BaseType::Varchar(len))
}
/// A variable-length string type
pub fn text() -> Type {
Type::new(BaseType::Text)
}
/// A json-type column – not supported by all backends
pub fn json() -> Type {
Type::new(BaseType::Json)
}
/// Embed binary data
pub fn binary<'inner>() -> Type {
Type::new(BaseType::Binary)
}
/// Create a column that points to some foreign table
pub fn foreign<S, I>(table: S, keys: I) -> Type
where
S: Into<String>,
I: Into<WrapVec<String>>,
{
Type::new(BaseType::Foreign(None, table.into(), keys.into()))
}
/// Like `foreign(...)` but letting you provide an external schema
///
/// This function is important when making cross-schema references
pub fn foreign_schema<S, I>(schema: S, table: S, keys: I) -> Type
where
S: Into<String>,
I: Into<WrapVec<String>>,
{
Type::new(BaseType::Foreign(
Some(schema.into()),
table.into(),
keys.into(),
))
}
/// Any custom SQL type that is embedded into a migration
pub fn custom(sql: &'static str) -> Type {
Type::new(BaseType::Custom(sql))
}
/// An SQL date type
pub fn date() -> Type {
Type::new(BaseType::Date)
}
/// Create an array of inner types
pub fn array(inner: &Type) -> Type {
Type::new(BaseType::Array(Box::new(inner.get_inner())))
}
/// Create an index over multiple, existing columns of the same type
pub fn index<S: Into<String>>(columns: Vec<S>) -> Type {
let vec: Vec<String> = columns.into_iter().map(|s| s.into()).collect();
Type::new(BaseType::Index(vec))
}
|
