neuralib.sqlp.expr.SqlCaseExpr

class neuralib.sqlp.expr.SqlCaseExpr

Bases: SqlExpr

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

__init__(expr=None)

Parameters:: expr (SqlExpr | None)

Methods

`__init__`([expr])
`between`(value[, value2])
`cast`(t)
`contains`(value)
`else_`(then)
`glob`(value)
`is_not_null`()
`is_null`()
`like`(value)
`not_between`(value[, value2])
`not_contains`(value)
`not_like`(value)
`when`(case, then)

Attributes

`expr`
`cases`

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