Struct postgres_querybuilder::SelectBuilder

pub struct SelectBuilder { /* fields omitted */ }

Implementations

impl SelectBuilder

pub fn new(from: &str) -> Self

Create a new select query for a given table

Examples

use postgres_querybuilder::SelectBuilder;

let mut builder = SelectBuilder::new("users");

pub fn select(&mut self, column: &str) -> &mut Self

Add a column to select

Examples

use postgres_querybuilder::SelectBuilder;
use postgres_querybuilder::prelude::QueryBuilder;

let mut builder = SelectBuilder::new("users");
builder.select("id");
builder.select("email");

assert_eq!(builder.get_query(), "SELECT id, email FROM users");

pub fn add_where_raw(&mut self, raw: String) -> &mut Self

Add a raw where condition

Examples

use postgres_querybuilder::SelectBuilder;
use postgres_querybuilder::prelude::QueryBuilder;

let mut builder = SelectBuilder::new("users");
builder.add_where_raw("something IS NULL".into());

assert_eq!(builder.get_query(), "SELECT * FROM users WHERE something IS NULL");

Trait Implementations

impl QueryBuilder for SelectBuilder

fn add_param<T: 'static + ToSql + Sync + Clone>(&mut self, value: T) -> usize

fn get_query(&self) -> String

fn get_ref_params(self) -> Vec<&'static (dyn ToSql + Sync)>

impl QueryBuilderWithGroupBy for SelectBuilder

fn group_by(&mut self, field: &str) -> &mut Self

impl QueryBuilderWithJoin for SelectBuilder

fn inner_join(&mut self, table_name: &str, relation: &str) -> &mut Self

fn left_join(&mut self, table_name: &str, relation: &str) -> &mut Self

fn left_outer_join(&mut self, table_name: &str, relation: &str) -> &mut Self

impl QueryBuilderWithLimit for SelectBuilder

fn limit(&mut self, limit: i64) -> &mut Self

impl QueryBuilderWithOffset for SelectBuilder

fn offset(&mut self, offset: i64) -> &mut Self

impl QueryBuilderWithOrder for SelectBuilder

fn order_by(&mut self, field: Order)

Add order attribute to request

Examples

use postgres_querybuilder::SelectBuilder;
use postgres_querybuilder::prelude::Order;
use postgres_querybuilder::prelude::QueryBuilder;
use postgres_querybuilder::prelude::QueryBuilderWithOrder;

let mut builder = SelectBuilder::new("users");
builder.order_by(Order::Asc("name".into()));

assert_eq!(builder.get_query(), "SELECT * FROM users ORDER BY name ASC");

impl QueryBuilderWithQueries for SelectBuilder

fn with_query(&mut self, name: &str, query: &str) -> &mut Self

impl QueryBuilderWithWhere for SelectBuilder

fn where_condition(&mut self, raw: &str) -> &mut Self

Add where condition to query

fn where_eq<T: 'static + ToSql + Sync + Clone>(
    &mut self,
    field: &str,
    value: T
) -> &mut Self

Add where equal condition to query

fn where_ne<T: 'static + ToSql + Sync + Clone>(
    &mut self,
    field: &str,
    value: T
) -> &mut Self

Add where not equal condition to query