Struct query_builder::SelectQuery
[−]
[src]
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>
[src]
pub fn select(rows: &[&'a str]) -> SelectQuery<'a, 'c>
[src]
Creates a new SelectQuery
that selects data from the row/s rows
pub fn from(self, t: &'a str) -> Self
[src]
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)
[src]
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
[src]
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>
[src]
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)
[src]
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>)
[src]
Adds a ORDER BY clause to the query
pub fn as_string(&self) -> String
[src]
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>
[src]
fn fmt(&self, __arg_0: &mut Formatter) -> Result
[src]
Formats the value using the given formatter. Read more
impl<'a, 'c> Display for SelectQuery<'a, 'c>
[src]
fn fmt(&self, f: &mut Formatter) -> FormatResult
[src]
Formats the value using the given formatter. Read more