Struct MsFunc 

pub struct MsFunc;

Function call helper.

Implementations

impl MsFunc

pub fn convert_as<V, I>(expr: V, iden: I) -> FunctionCall

where V: Into<SimpleExpr>, I: IntoIden,

Call CONVERT function with a custom type.

Examples

use sea_query::{tests_cfg::*, *};

let query = Query::select()
    .expr(MsFunc::convert_as(123, Alias::new("text")))
    .to_owned();

assert_eq!(
    query.to_string(MsSqlQueryBuilder),
    r#"SELECT CONVERT(text, 123)"#
);

pub fn db_name() -> FunctionCall

Get current database name.

Examples

use sea_query::{tests_cfg::*, *};

let query = Query::select().expr(MsFunc::db_name()).to_owned();

assert_eq!(query.to_string(MsSqlQueryBuilder), r#"SELECT DB_NAME()"#);

pub fn iif<C, T, F>(cond: C, if_true: T, if_false: F) -> FunctionCall

where C: Into<SimpleExpr>, T: Into<Value>, F: Into<Value>,

If.

Examples

use sea_query::{tests_cfg::*, *};

let query = Query::select()
    .expr(MsFunc::iif(Expr::val(2).gt(1), 1, 0))
    .to_owned();

assert_eq!(
    query.to_string(MsSqlQueryBuilder),
    r#"SELECT IIF(2 > 1, 1, 0)"#
);

pub fn getdate() -> FunctionCall

The getdate() -> datetime function.

https://learn.microsoft.com/en-us/sql/t-sql/functions/getdate-transact-sql?view=sql-server-2016

pub fn newid() -> FunctionCall

The newid() -> uniqueidentifier function.

https://learn.microsoft.com/en-us/sql/t-sql/functions/newid-transact-sql?view=sql-server-2016

Trait Implementations

impl Clone for MsFunc

fn clone(&self) -> MsFunc

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for MsFunc

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

Formats the value using the given formatter.