Struct SelectBuilder 

pub struct SelectBuilder<E: Entity> { /* private fields */ }

SELECT 查询构建器

Implementations

impl<E: Entity> SelectBuilder<E>

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

选择指定列

pub fn join(self, join_type: JoinType, table: &str, on: Condition) -> Self

添加 JOIN

pub fn inner_join(self, table: &str, on: Condition) -> Self

添加 INNER JOIN

pub fn left_join(self, table: &str, on: Condition) -> Self

添加 LEFT JOIN

pub fn right_join(self, table: &str, on: Condition) -> Self

添加 RIGHT JOIN

pub fn full_join(self, table: &str, on: Condition) -> Self

添加 FULL JOIN

pub fn where_(self, condition: Condition) -> Self

添加 WHERE 条件

pub fn where_all(self, conditions: Vec<Condition>) -> Self

添加多个 WHERE 条件 (AND 连接)

pub fn group_by(self, columns: &[&str]) -> Self

添加 GROUP BY

pub fn having(self, condition: Condition) -> Self

添加 HAVING 条件

pub fn having_all(self, conditions: Vec<Condition>) -> Self

添加多个 HAVING 条件 (AND 连接)

pub fn order_by<C: Into<String>>(self, column: C, order: Order) -> Self

添加排序

pub fn limit(self, limit: u64) -> Self

设置 LIMIT

pub fn offset(self, offset: u64) -> Self

设置 OFFSET