Struct SetQuery 

pub struct SetQuery { /* private fields */ }

Set operation query, supports chaining multiple SELECTs joined by UNION/INTERSECT/EXCEPT.

Example

use sz_orm_core::DbType;
use sz_orm_query_builder::Query;

let q1 = Query::select().column("id").from("active_users");
let q2 = Query::select().column("id").from("pending_users");
let sql = q1.union(q2).build(DbType::MySQL);
// SELECT `id` FROM `active_users` UNION SELECT `id` FROM `pending_users`

Implementations

impl SetQuery

pub fn new(first: SelectQuery, op: SetOperator, second: SelectQuery) -> Self

Create a set operation query.

pub fn union(self, other: SelectQuery) -> Self

Append a UNION query.

pub fn union_all(self, other: SelectQuery) -> Self

Append a UNION ALL query.

pub fn intersect(self, other: SelectQuery) -> Self

Append an INTERSECT query.

pub fn except(self, other: SelectQuery) -> Self

Append an EXCEPT query.

pub fn order_by(self, column: &str, asc: bool) -> Self

Set global ORDER BY (applies to the entire set operation result).

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

Set global LIMIT.

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

Set global OFFSET.

pub fn build(self, db_type: DbType) -> String

Generate SQL.

Joins all subqueries with the corresponding set operators, and appends global ORDER BY / LIMIT / OFFSET at the end.

Trait Implementations

impl Clone for SetQuery

fn clone(&self) -> SetQuery

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for SetQuery

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

Formats the value using the given formatter.