pub struct SelectQuery<'a, 'c> {
pub whre: Vec<WhereClause<'a, 'c>>,
/* private fields */
}
Expand description
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>>
Implementations§
Source§impl<'a, 'c> SelectQuery<'a, 'c>
impl<'a, 'c> SelectQuery<'a, 'c>
Sourcepub fn select(rows: &[&'a str]) -> SelectQuery<'a, 'c>
pub fn select(rows: &[&'a str]) -> SelectQuery<'a, 'c>
Creates a new SelectQuery
that selects data from the row/s rows
Sourcepub fn from(self, t: &'a str) -> Self
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")
Sourcepub fn limit(&mut self, l: usize)
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")
Sourcepub fn has_limit(&self) -> bool
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());
Sourcepub fn get_limit(&self) -> Option<usize>
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));
Sourcepub fn clear_limit(&mut self)
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");
Trait Implementations§
Source§impl<'a, 'c> Debug for SelectQuery<'a, 'c>
impl<'a, 'c> Debug for SelectQuery<'a, 'c>
Source§impl<'a, 'c> Display for SelectQuery<'a, 'c>
impl<'a, 'c> Display for SelectQuery<'a, 'c>
Auto Trait Implementations§
impl<'a, 'c> Freeze for SelectQuery<'a, 'c>
impl<'a, 'c> RefUnwindSafe for SelectQuery<'a, 'c>
impl<'a, 'c> Send for SelectQuery<'a, 'c>
impl<'a, 'c> Sync for SelectQuery<'a, 'c>
impl<'a, 'c> Unpin for SelectQuery<'a, 'c>
impl<'a, 'c> UnwindSafe for SelectQuery<'a, 'c>
Blanket Implementations§
Source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
Source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more