Struct pg_worm::query::SelectBuilder

pub struct SelectBuilder { /* private fields */ }

QueryBuilder for SELECT queries.

Implementations

impl SelectBuilder

pub fn new(cols: Vec<&'static DynCol>) -> SelectBuilder

Start building a new SELECT query.

Panics

Panics if an empty vec is provided.

pub fn filter(self, new_filter: Filter) -> SelectBuilder

Add a Filter to the select query.

Example

use pg_worm::{Model, Query, QueryBuilder};

#[derive(Model)]
struct Book {
    id: i64,
    title: String
}

let q = Query::select([&Book::title])
    .filter(Book::id.eq(5))
    .build();

pub fn join( self, column: &'static DynCol, on_column: &'static DynCol, join_type: JoinType ) -> SelectBuilder

Add a Join to the select query.

Example

use pg_worm::{Model, Query, QueryBuilder, JoinType};

#[derive(Model)]
struct Book {
    #[column(primary_key, auto)]
    id: i64,
    title: String,
    author_id: i64
}

#[derive(Model)]
struct Author {
    #[column(primary_key, auto)]
    id: i64,
    name: String
}

let q = Query::select([&Book::id, &Book::title, &Author::name])
    .join(&Book::author_id, &Author::id, JoinType::Inner)
    .filter(Author::name.eq("Marx"))
    .build();

pub fn limit(self, n: usize) -> SelectBuilder

Add a LIMIT to your query.

Trait Implementations

impl QueryBuilder for SelectBuilder

fn build(self) -> Query

Build the query.