Struct CaseStatement 

pub struct CaseStatement {
    pub when_clauses: Vec<(SimpleExpr, SimpleExpr)>,
    pub else_clause: Option<SimpleExpr>,
}

A CASE WHEN statement.

Represents SQL CASE expressions:

CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    ELSE default_result
END

Fields

when_clauses: Vec<(SimpleExpr, SimpleExpr)>

The WHEN conditions and their THEN results

else_clause: Option<SimpleExpr>

The ELSE result (optional)

Implementations

impl CaseStatement

pub fn new() -> Self

Create a new empty CASE statement.

pub fn when<C, R>(self, condition: C, result: R) -> Self

where C: Into<SimpleExpr>, R: Into<SimpleExpr>,

Add a WHEN clause.

pub fn else_result<E>(self, result: E) -> Self

where E: Into<SimpleExpr>,

Set the ELSE clause.

Trait Implementations

impl Clone for CaseStatement

fn clone(&self) -> CaseStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CaseStatement

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

Formats the value using the given formatter.

impl Default for CaseStatement

fn default() -> CaseStatement

Returns the “default value” for a type.

impl From<CaseStatement> for SimpleExpr

fn from(case: CaseStatement) -> Self

Converts to this type from the input type.