Struct QueryBuilderI

pub struct QueryBuilderI<'a, Ta>
where
    Ta: SsqlMarker,
{ /* private fields */ }

Struct representing one TABLE.

Implementations

impl<'a, T> QueryBuilderI<'a, T>

where T: SsqlMarker,

pub fn new( fields: (&'static str, Vec<&'static str>), func: fn(&str) -> &'static str, ) -> Self

Create a new query builder, shouldn’t call it manually, this is handled by [query] method.

Trait Implementations

impl<'a, Ta> QueryAble<'a> for QueryBuilderI<'a, Ta>

where Ta: SsqlMarker + Send + Sync + 'static,

fn join<NxtType>(self, join_args: JoinArg) -> Self::NxtModel<NxtType>

where NxtType: SsqlMarker,

Perform left join on another table. Will panic if the relationship not presented in field attribute #[ssql(foreign_key=...)] or if the provided table is already joined.

fn all( &self, conn: &mut Client<Compat<TcpStream>>, ) -> impl Future<Output = SsqlResult<Vec<Self::Ret>>> + Send

Getting data from query builder instance, will panic if data type defined in struct is not corresponding to the tables. Returns Vector containing tuple of TABLE structs Vec<(Ta..Te)>, depends on how much tables joined in this query builder.

fn stream<'b>( &self, conn: &'b mut Client<Compat<TcpStream>>, ) -> impl Future<Output = SsqlResult<RowStream<'b, Self::Ret>>> + Send

Similar to all, but returns a stream producing tuple of structs instead of a whole vector.

fn one( &self, conn: &mut Client<Compat<TcpStream>>, ) -> impl Future<Output = SsqlResult<Option<Self::Ret>>> + Send

Similar to all, but returns first row only.

fn left_join<NxtType>(self) -> Self::NxtModel<NxtType>

where NxtType: SsqlMarker, Self: Sized,

See join. Except that this method only perform LEFT JOIN.

fn right_join<NxtType>(self) -> Self::NxtModel<NxtType>

where NxtType: SsqlMarker, Self: Sized,

See join. Except that this method only perform RIGHT JOIN.

fn inner_join<NxtType>(self) -> Self::NxtModel<NxtType>

where NxtType: SsqlMarker, Self: Sized,

See join. Except that this method only perform INNER JOIN.

fn outer_join<NxtType>(self) -> Self::NxtModel<NxtType>

where NxtType: SsqlMarker, Self: Sized,

See join. Except that this method only perform OUTER JOIN.

fn filter(self, filter_expr: FilterExpr<'a>) -> SsqlResult<Self>

where Self: Sized,

Chain a filter to current builder. This method will check whether the table provided is in this builder thus SsqlResult is returned.

fn order_by_asc(self, col_expr: ColExpr) -> SsqlResult<Self>

where Self: Sized,

Ordering the output by a specified column in ascending order.

fn order_by_desc(self, col_expr: ColExpr) -> SsqlResult<Self>

where Self: Sized,

Ordering the output by a specified column in descending order.