[−][src]Struct sqlite3builder::Sqlite3Builder
Builder stored info
Methods
impl Sqlite3Builder
[src]
pub fn select_from(table: &str) -> Self
[src]
Create SELECT request. You may specify comma separted list of tables.
extern crate sqlite3builder; use sqlite3builder::Sqlite3Builder; let sql = Sqlite3Builder::select_from("books") .field("title") .field("price") .and_where("price > 100") .and_where("title LIKE 'Harry Potter%'") .sql()?; assert_eq!("SELECT title, price FROM books WHERE (price > 100) AND (title LIKE 'Harry Potter%');", &sql);
pub fn insert_into(table: &str) -> Self
[src]
Create INSERT request.
extern crate sqlite3builder; use sqlite3builder::{Sqlite3Builder, quote}; let sql = Sqlite3Builder::insert_into("books") .field("title") .field("price") .values(&["e("In Search of Lost Time"), "150"]) .values(&["'Don Quixote', 200"]) .sql()?; assert_eq!("INSERT INTO books (title, price) VALUES ('In Search of Lost Time', 150), ('Don Quixote', 200);", &sql);
pub fn update_table(table: &str) -> Self
[src]
Create UPDATE request.
extern crate sqlite3builder; use sqlite3builder::Sqlite3Builder; let sql = Sqlite3Builder::update_table("books") .set("price", "price + 10") .sql()?; assert_eq!("UPDATE books SET price = price + 10;", &sql);
pub fn delete_from(table: &str) -> Self
[src]
Create DELETE request.
extern crate sqlite3builder; use sqlite3builder::Sqlite3Builder; let sql = Sqlite3Builder::delete_from("books") .and_where("price > 100") .sql()?; assert_eq!("DELETE FROM books WHERE price > 100;", &sql);
pub fn join(
&mut self,
table: &str,
operator: Option<&str>,
constraint: Option<&str>
) -> &mut Self
[src]
&mut self,
table: &str,
operator: Option<&str>,
constraint: Option<&str>
) -> &mut Self
Join with table.
extern crate sqlite3builder; use sqlite3builder::Sqlite3Builder; let sql = Sqlite3Builder::select_from("books AS b") .field("b.title") .field("s.total") .join("shops AS s", Some("LEFT OUTER"), Some("ON b.id = s.book")) .sql()?; assert_eq!("SELECT b.title, s.total FROM books AS b LEFT OUTER JOIN shops AS s ON b.id = s.book;", &sql);
pub fn distinct(&mut self) -> &mut Self
[src]
Set DISTINCT for fields.
extern crate sqlite3builder; use sqlite3builder::Sqlite3Builder; let sql = Sqlite3Builder::select_from("books") .distinct() .field("price") .sql()?; assert_eq!("SELECT DISTINCT price FROM books;", &sql);
pub fn fields(&mut self, fields: &[&str]) -> &mut Self
[src]
Add fields.
extern crate sqlite3builder; use sqlite3builder::Sqlite3Builder; let sql = Sqlite3Builder::select_from("books") .fields(&["title", "price"]) .sql()?; assert_eq!("SELECT title, price FROM books;", &sql);
pub fn set_fields(&mut self, fields: &[&str]) -> &mut Self
[src]
Replace fields
pub fn field(&mut self, field: &str) -> &mut Self
[src]
Add field
pub fn set_field(&mut self, field: &str) -> &mut Self
[src]
Replace fields with choosed one
pub fn set(&mut self, field: &str, value: &str) -> &mut Self
[src]
Add SET part (for UPDATE)
pub fn values(&mut self, values: &[&str]) -> &mut Self
[src]
Add VALUES part (for INSERT)
pub fn group_by(&mut self, field: &str) -> &mut Self
[src]
Add GROUP BY part
pub fn having(&mut self, cond: &str) -> &mut Self
[src]
Add HAVING condition
pub fn and_where(&mut self, cond: &str) -> &mut Self
[src]
Add WHERE condition
pub fn and_where_eq(&mut self, field: &str, value: &str) -> &mut Self
[src]
Add WHERE condition for equal parts
pub fn order_by(&mut self, field: &str, desc: bool) -> &mut Self
[src]
Add ORDER BY
pub fn order_asc(&mut self, field: &str) -> &mut Self
[src]
Add ORDER BY ASC
pub fn order_desc(&mut self, field: &str) -> &mut Self
[src]
Add ORDER BY DESC
pub fn limit(&mut self, limit: usize) -> &mut Self
[src]
Set LIMIT
pub fn offset(&mut self, offset: usize) -> &mut Self
[src]
Set OFFSET
pub fn sql(&self) -> Result<String, Box<dyn Error>>
[src]
Build complete SQL command
pub fn subquery(&self) -> Result<String, Box<dyn Error>>
[src]
Build subquery SQL command
pub fn subquery_as(&self, name: &str) -> Result<String, Box<dyn Error>>
[src]
Build named subquery SQL command
pub fn exec(
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<(), Box<dyn Error>>
[src]
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<(), Box<dyn Error>>
Execute request
pub fn get(
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<Vec<Vec<JValue>>, Box<dyn Error>>
[src]
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<Vec<Vec<JValue>>, Box<dyn Error>>
Execute and return all data
pub fn get_row(
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<Vec<JValue>, Box<dyn Error>>
[src]
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<Vec<JValue>, Box<dyn Error>>
Execute and return first row
pub fn get_value(
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<JValue, Box<dyn Error>>
[src]
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<JValue, Box<dyn Error>>
Execute and return first value
pub fn get_int(
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<i64, Box<dyn Error>>
[src]
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<i64, Box<dyn Error>>
Execute and return first integer value
pub fn get_str(
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<String, Box<dyn Error>>
[src]
&self,
conn: &PooledConnection<SqliteConnectionManager>
) -> Result<String, Box<dyn Error>>
Execute and return first string value
pub fn get_cursor<'a>(
&'a self,
conn: &'a PooledConnection<SqliteConnectionManager>
) -> Result<Cursor<'a>, Box<dyn Error>>
[src]
&'a self,
conn: &'a PooledConnection<SqliteConnectionManager>
) -> Result<Cursor<'a>, Box<dyn Error>>
Get cursor for request
Auto Trait Implementations
impl RefUnwindSafe for Sqlite3Builder
impl Send for Sqlite3Builder
impl Sync for Sqlite3Builder
impl Unpin for Sqlite3Builder
impl UnwindSafe for Sqlite3Builder
Blanket Implementations
impl<T> Any for T where
T: 'static + ?Sized,
[src]
T: 'static + ?Sized,
impl<T> Borrow<T> for T where
T: ?Sized,
[src]
T: ?Sized,
impl<T> BorrowMut<T> for T where
T: ?Sized,
[src]
T: ?Sized,
fn borrow_mut(&mut self) -> &mut T
[src]
impl<T> From<T> for T
[src]
impl<T, U> Into<U> for T where
U: From<T>,
[src]
U: From<T>,
impl<T, U> TryFrom<U> for T where
U: Into<T>,
[src]
U: Into<T>,
type Error = Infallible
The type returned in the event of a conversion error.
fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>
[src]
impl<T, U> TryInto<U> for T where
U: TryFrom<T>,
[src]
U: TryFrom<T>,