liteql 0.1.2

LiteQL is a lightweight wrapper for Rusqlite and Eloquent, designed to make working with SQLite in Rust easier and more intuitive.
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

use eloquent::{QueryBuilder, ToSql};
use rusqlite::{Connection, Error, Row};

pub trait FromRow {
    fn from_row(row: &Row) -> Result<Self, Error>
    where
        Self: Sized;
}

pub trait Query {
    fn query<T>(&self, connection: &Connection) -> Result<Vec<T>, Error>
    where
        T: FromRow;
}

impl Query for &str {
    fn query<T>(&self, connection: &Connection) -> Result<Vec<T>, Error>
    where
        T: FromRow,
    {
        let mut output = Vec::new();
        let mut statement = connection.prepare(self)?;
        for row in statement.query_map([], T::from_row)? {
            output.push(row?);
        }
        Ok(output)
    }
}

impl Query for QueryBuilder {
    fn query<T>(&self, connection: &Connection) -> Result<Vec<T>, Error>
    where
        T: FromRow,
    {
        self.to_sql().unwrap().as_str().query(connection)
    }
}