Struct postgres_querybuilder::SelectBuilder

pub struct SelectBuilder { /* fields omitted */ }

Methods

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)

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)

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");

pub fn add_param(&mut self, raw: String) -> usize

Add a parameter to the list of parameters. This is mostly used internally.

Examples

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

let user_password = "password".to_string();
let mut builder = SelectBuilder::new("users");
let index = builder.add_param(user_password);
builder.add_where_raw(format!("password = MD5(${})", index));

assert_eq!(builder.get_query(), "SELECT * FROM users WHERE password = MD5($1)");

Trait Implementations

impl QueryBuilder for SelectBuilder

fn get_query(&self) -> String

fn has_params(&self) -> bool

fn next_index(&self) -> usize

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

impl QueryBuilderWithGroupBy for SelectBuilder

fn group_by(&mut self, field: &str)

impl QueryBuilderWithJoin for SelectBuilder

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

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

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

impl QueryBuilderWithLimit for SelectBuilder

fn limit(&mut self, limit: i64)

impl QueryBuilderWithOffset for SelectBuilder

fn offset(&mut self, offset: u32)

impl QueryBuilderWithWhere for SelectBuilder

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

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