Struct query_builder::SelectQuery

pub struct SelectQuery<'a, 'c> {
    pub whre: Vec<WhereClause<'a, 'c>>,
    // some fields omitted
}

Struct representing a SQL-INSERT Query A simple query to select everything from a table can be created like this:

Example

use query_builder::SelectQuery;

// create the query
let query = SelectQuery::select(&["*"]).from("users");

// make sure it looks like you would expect it to look
assert_eq!(query.as_string(), "SELECT * FROM users");

Fields

whre: Vec<WhereClause<'a, 'c>>

Methods

impl<'a, 'c> SelectQuery<'a, 'c>

pub fn select(rows: &[&'a str]) -> SelectQuery<'a, 'c>

Creates a new SelectQuery that selects data from the row/s rows

pub fn from(self, t: &'a str) -> Self

Sets the table to select from to the value of t

Example

use query_builder::SelectQuery;

let q = SelectQuery::select(&["user"]).from("users");

assert_eq!(q.as_string(), "SELECT user FROM users")

pub fn limit(&mut self, l: usize)

Sets the limit value of the Query to the value of l

Example

use query_builder::SelectQuery;

let mut q = SelectQuery::select(&["user"]).from("users");
q.limit(12);

assert_eq!(q.as_string(), "SELECT user FROM users LIMIT 12")

pub fn has_limit(&self) -> bool

Return whether or not the SelectQuery has a limit

Example

use query_builder::SelectQuery;

let mut q = SelectQuery::select(&["user"]).from("users");
q.limit(12);
 
assert!(q.has_limit());
 
q.clear_limit();
assert!(!q.has_limit());

pub fn get_limit(&self) -> Option<usize>

Returns the value of the Limit of the SelectQuery if there is one

Example

use query_builder::SelectQuery;
 
let mut q = SelectQuery::select(&["user"]).from("users");
assert_eq!(q.get_limit(), None);
 
q.limit(12);
assert_eq!(q.get_limit(), Some(12));

pub fn clear_limit(&mut self)

Removes the limit from the query

Example

use query_builder::SelectQuery;

let mut q = SelectQuery::select(&["user"]).from("users");
 
// set the limit
q.limit(42);
assert_eq!(q.as_string(), "SELECT user FROM users LIMIT 42");

// clear limit
q.clear_limit();
 
assert_eq!(q.as_string(), "SELECT user FROM users");

pub fn order_by(&mut self, ob: OrderBy<'c>)

Adds a ORDER BY clause to the query

pub fn as_string(&self) -> String

Creates the string representation of the query

Example

use query_builder::SelectQuery;

let mut q = SelectQuery::select(&["*"]).from("users");

assert_eq!(q.as_string(), "SELECT * FROM users")

Trait Implementations

impl<'a, 'c> Debug for SelectQuery<'a, 'c>

fn fmt(&self, __arg_0: &mut Formatter) -> Result

Formats the value using the given formatter.

impl<'a, 'c> Display for SelectQuery<'a, 'c>

fn fmt(&self, f: &mut Formatter) -> FormatResult

Formats the value using the given formatter.