Struct Select

pub struct Select { /* private fields */ }

Represents the creation of a SELECT with specified table and options.

Implementations

impl Select

pub fn new(table: &str) -> Self

Creates a new Select instance with the specified table name.

Example

use lumus_sql_builder::sqlite::Select;
let select = Select::new("users").columns("name, age").build().unwrap();
assert_eq!(select, "SELECT name, age FROM users;")

pub fn from(query: &str) -> Result<Select, SqlBuilderError>

Creates a new Select instance from a SQL query string. The query string should be in the format “SELECT * FROM table_name [WHERE condition] [GROUP BY column] [ORDER BY column] [LIMIT limit] [OFFSET offset]”.

Example

use lumus_sql_builder::sqlite::Select;
let query = "SELECT * FROM users WHERE age > 18 GROUP BY city ORDER BY name LIMIT 10 OFFSET 0";
Select::from(query);

pub fn distinct(&mut self) -> &mut Self

Specifies that the select statement should return distinct rows.

pub fn columns(&mut self, columns: &str) -> &mut Self

Specifies the columns to be selected in the query.

pub fn group(&mut self, group: &str) -> &mut Self

Specifies the grouping for the query results.

pub fn order(&mut self, order: &str) -> &mut Self

Specifies the ordering for the query results.

pub fn condition(&mut self, condition: String) -> &mut Self

Specifies where for Select.

pub fn limit(&mut self, limit: u32) -> &mut Self

Specifies the maximum number of rows to be returned by the query.

pub fn offset(&mut self, offset: u32) -> &mut Self

Specifies the offset for the query results.

pub fn join(&mut self, join: String) -> &mut Self

Specifies a join.

pub fn build(&self) -> Result<String, SqlBuilderError>

Builds and returns the SQL statement for the select query.

Trait Implementations

impl Debug for Select

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.