db_dsl 0.3.3

A simple DSL for creating database objects.
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

use crate::{SqlUp, TableName};

#[derive(Clone, Debug)]
pub struct Sequence {
    pub name: TableName,
    pub options: Option<SequenceOptions>,
}

impl SqlUp for Sequence {
    fn sqlite_up(&self) -> Option<String> {
        let options = self.options.clone().unwrap_or_default();
        let mut sql = format!("CREATE SEQUENCE {}", self.name);
        if let Some(start) = options.start {
            sql.push_str(&format!(" START WITH {}", start));
        }
        if let Some(increment) = options.increment {
            sql.push_str(&format!(" INCREMENT BY {}", increment));
        }
        if let Some(min) = options.min {
            sql.push_str(&format!(" MINVALUE {}", min));
        }
        if let Some(max) = options.max {
            sql.push_str(&format!(" MAXVALUE {}", max));
        }
        if let Some(cycle) = options.cycle {
            sql.push_str(&format!(" CYCLE {}", cycle));
        }
        Some(sql)
    }
}

#[derive(Clone, Debug, Default)]
pub struct SequenceOptions {
    pub start: Option<i64>,
    pub increment: Option<i64>,
    pub min: Option<i64>,
    pub max: Option<i64>,
    pub cycle: Option<bool>,
}