ssql 0.2.0

Async ms sql server basic orm
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

use std::marker::PhantomData;

use futures_lite::StreamExt;
#[cfg(feature = "serde")]
use serde_json::Value;
use tiberius::Client;
use tokio::net::TcpStream;
use tokio_util::compat::Compat;

use crate::{RowStream, SsqlMarker, SsqlResult};
use crate::structs::into_result::IntoResult;
use crate::structs::query_core::{Executable, QueryCore, RawQuery};

pub struct RawQueryBuilder<'a, T>
where
    T: SsqlMarker,
{
    pub(crate) core: QueryCore<'a, RawQuery>,
    pub(crate) t: PhantomData<T>,
}

impl<'a, T> RawQueryBuilder<'a, T>
where
    T: SsqlMarker + Send + Sync + 'static,
{
    pub async fn all(&self, conn: &mut Client<Compat<TcpStream>>) -> SsqlResult<Vec<T>> {
        let mut stream = self.core.execute(conn).await?.into_row_stream();
        let mut ret = vec![];
        while let Some(row) = stream.try_next().await? {
            ret.push(T::to_struct(&row));
        }
        Ok(ret)
    }

    pub async fn stream<'b>(
        &self,
        conn: &'b mut tiberius::Client<Compat<TcpStream>>,
    ) -> SsqlResult<RowStream<'b, T>> {
        let stream = self.core.execute(conn).await?;
        Ok(RowStream::new(stream, T::to_struct))
    }

    pub async fn one(
        &self,
        conn: &mut tiberius::Client<Compat<TcpStream>>,
    ) -> SsqlResult<Option<T>> {
        let row = self.core.execute(conn).await?.into_row().await?;
        match row {
            None => Ok(None),
            Some(row) => Ok(Some(T::to_struct(&row))),
        }
    }

    #[cfg(feature = "serde")]
    pub async fn json(
        &self,
        conn: &mut tiberius::Client<Compat<TcpStream>>,
    ) -> SsqlResult<Vec<Value>> {
        let mut stream = self.core.execute(conn).await?.into_row_stream();
        let mut ret = vec![];
        while let Some(row) = stream.try_next().await? {
            ret.push(T::to_json(&row))
        }
        Ok(ret)
    }
}