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
48
49
50
51
52
53
54
55
56
57

use super::*;

pub struct Database<'a, C, S, I>
where C: proxy::sqlite::SqliteTrait,
      S: traits::AsStatement,
      I: for<'b> std::convert::TryFrom<&'b rusqlite::Row<'b>, Error = rusqlite::Error>,
{
  conn: &'a C,
  statement: S,
  phantom_i: std::marker::PhantomData<I>,
}

impl<'a, C, S, I> std::convert::From<&'a C> for Database<'a, C, S, I>
where C: proxy::sqlite::SqliteTrait,
      S: traits::AsStatement + std::default::Default,
      I: for<'b> std::convert::TryFrom<&'b rusqlite::Row<'b>, Error = rusqlite::Error>
{
  fn from(conn: &'a C) -> Self {
    Database { 
      conn, 
      statement: S::default(),
      phantom_i: std::marker::PhantomData,
    }
  }
}

impl<'a, C, S, I> Database<'a, C, S, I> 
where C: proxy::sqlite::SqliteTrait,
      S: traits::AsStatement,
      I: for<'b> std::convert::TryFrom<&'b rusqlite::Row<'b>, Error = rusqlite::Error>,
{
  pub fn from_conn_statement(conn: &'a C, statement: S) -> Database<'a, C, S, I> {
    Database {
      conn,
      statement,
      phantom_i: std::marker::PhantomData,
    }
  }
}

impl<'a, C, S, I> traits::Selectable for Database<'a, C, S, I> 
where C: proxy::sqlite::SqliteTrait,
      S: traits::AsStatement,
      I: for<'b> std::convert::TryFrom<&'b rusqlite::Row<'b>, Error = rusqlite::Error>,
{
  type Item = I;
  fn select_with_statement(&self, statement: String) -> DeriveSqlResult<Vec<Self::Item>> {
    self.conn.query_map(statement.as_str(), 
      [],
      |r| r.try_into())
  }

  fn statement(&self) -> DeriveSqlResult<String> {
    Ok(self.statement.into_statement()?)
  }
}