Struct quaint::ast::Union

pub struct Union<'a> { /* fields omitted */ }

A builder for a UNIONs over multiple SELECT statements.

Methods

impl<'a> Union<'a>

pub fn new(q: Select<'a>) -> Self

pub fn all(self, q: Select<'a>) -> Self

Creates a union with previous selection and the given SELECT statement, allowing duplicates.

let s1 = Select::default().value(1);
let s2 = Select::default().value(2);
let (sql, params) = Sqlite::build(Union::new(s1).all(s2));

assert_eq!("(SELECT ?) UNION ALL (SELECT ?)", sql);

assert_eq!(vec![
    ParameterizedValue::from(1),
    ParameterizedValue::from(2)
], params);

pub fn distinct(self, q: Select<'a>) -> Self

Creates a union with previous selection and the given SELECT statement, selecting only distinct values.

let s1 = Select::default().value(1);
let s2 = Select::default().value(2);
let (sql, params) = Sqlite::build(Union::new(s1).distinct(s2));

assert_eq!("(SELECT ?) UNION (SELECT ?)", sql);

assert_eq!(vec![
    ParameterizedValue::from(1),
    ParameterizedValue::from(2)
], params);

Trait Implementations

impl<'a> Clone for Union<'a>

fn clone(&self) -> Union<'a>

Returns a copy of the value.

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

Performs copy-assignment from source.

impl<'a> Debug for Union<'a>

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

Formats the value using the given formatter.

impl<'a> Default for Union<'a>

fn default() -> Union<'a>

Returns the "default value" for a type.

impl<'a> From<Union<'a>> for Query<'a>

fn from(ua: Union<'a>) -> Self

Performs the conversion.

impl<'a> PartialEq<Union<'a>> for Union<'a>

fn eq(&self, other: &Union<'a>) -> bool

This method tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Union<'a>) -> bool

This method tests for !=.

impl<'a> StructuralPartialEq for Union<'a>