barrel 0.7.0

A powerful schema migration building API 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

//! All add_column combinations for pgsql
#![allow(unused_imports)]

use crate::backend::{MsSql, SqlGenerator};
use crate::types;

#[test]
fn text() {
    let sql = MsSql::add_column(true, None, "Text", &types::text());
    assert_eq!(String::from("ADD [Text] TEXT NOT NULL"), sql);
}

#[test]
fn varchar() {
    let sql = MsSql::add_column(true, None, "Varchar", &types::varchar(255));
    assert_eq!(String::from("ADD [Varchar] VARCHAR(255) NOT NULL"), sql);
}

#[test]
fn integer() {
    let sql = MsSql::add_column(true, None, "Integer", &types::integer());
    assert_eq!(String::from("ADD [Integer] INT NOT NULL"), sql);
}

#[test]
fn float() {
    let sql = MsSql::add_column(true, None, "Float", &types::float());
    assert_eq!(String::from("ADD [Float] FLOAT(24) NOT NULL"), sql);
}

#[test]
fn double() {
    let sql = MsSql::add_column(true, None, "Double", &types::double());
    assert_eq!(String::from("ADD [Double] FLOAT(53) NOT NULL"), sql);
}

#[test]
fn boolean() {
    let sql = MsSql::add_column(true, None, "Boolean", &types::boolean());
    assert_eq!(String::from("ADD [Boolean] BIT NOT NULL"), sql);
}

#[test]
fn binary() {
    let sql = MsSql::add_column(true, None, "Binary", &types::binary());
    assert_eq!(String::from("ADD [Binary] VARBINARY(MAX) NOT NULL"), sql);
}

#[test]
fn date() {
    let sql = MsSql::add_column(true, None, "Date", &types::date());
    assert_eq!(String::from("ADD [Date] DATE NOT NULL"), sql);
}

#[test]
fn foreign() {
    let sql = MsSql::add_column(true, None, "Foreign", &types::foreign("posts", "id"));
    assert_eq!(
        String::from("ADD [Foreign] INT REFERENCES [posts]([id]) NOT NULL"),
        sql
    );
}

#[test]
fn custom() {
    let sql = MsSql::add_column(true, None, "Xml", &types::custom("XML"));
    assert_eq!(String::from("ADD [Xml] XML NOT NULL"), sql);
}