derive-sql 0.13.0

Structure the interaction with SQL databases - currently SQLite and MySQL via trait and a procedural macro
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

use super::*;

pub struct Paginate<T, I>
where T: traits::AsStatement<I>,
{
  inner: T,
  limit: Option<usize>,
  offset: Option<usize>,
  phantom_i: std::marker::PhantomData<I>,
}

impl<T, I> Paginate<T, I>
where T: traits::AsStatement<I>,
{
  pub fn with_limit(mut self, limit: usize) -> Self { self.limit = Some(limit); self }
  pub fn with_offset(mut self, offset: usize) -> Self { self.offset = Some(offset); self }
}

impl<T, I> std::convert::From<T> for Paginate<T, I>
where T: traits::AsStatement<I>,
{
  fn from(v: T) -> Self {
    Paginate {
      inner: v,
      limit: None,
      offset: None,
      phantom_i: std::marker::PhantomData::default(),
    }
  }
}

impl<I, T> traits::AsStatement<I> for Paginate<T, I>
where T: traits::AsStatement<I>,
{
  fn as_statement(&self) -> DeriveSqlResult<String> {
    Ok(format!("{statement} {limit} {offset}",
      statement = self.inner.as_statement()?,
      limit = self.limit.as_ref().map(|v| format!("LIMIT {v}")).unwrap_or_default(),
      offset = self.offset.as_ref().map(|v| format!("OFFSET {v}")).unwrap_or_default(),
    ))
  }
}

impl<I, T> traits::IsSelect for Paginate<T, I>
where T: traits::AsStatement<I> + traits::IsSelect,
{}