neuralib.sqlp.expr.SqlCaseExpr

class neuralib.sqlp.expr.SqlCaseExpr

Bases: SqlExpr

https://www.sqlite.org/lang_expr.html#the_case_expression

expr
cases
__init__(expr=None)
Parameters:

expr (SqlExpr | None)

between(value, value2=None)
Return type:

SqlCompareOper

cast(t)
Parameters:

t (type)

Return type:

SqlExpr

contains(value)
Parameters:

value (Union[Sequence, SqlStat])

Return type:

SqlCompareOper

else_(then)
Return type:

Self

glob(value)
Parameters:

value (str)

Return type:

SqlCompareOper

is_not_null()
Return type:

SqlCompareOper

is_null()
Return type:

SqlCompareOper

like(value)
Parameters:

value (str)

Return type:

SqlCompareOper

not_between(value, value2=None)
Return type:

SqlCompareOper

not_contains(value)
Parameters:

value (Union[Sequence, SqlStat])

Return type:

SqlCompareOper

not_like(value)
Parameters:

value (str)

Return type:

SqlCompareOper

when(case, then)
Return type:

Self