neuralib.sqlp.expr.SqlCteExpr

class neuralib.sqlp.expr.SqlCteExpr

Bases: SqlExpr

__init__(name, select)

Parameters:

name (str)
select (SqlSelectStat)

Methods

`__init__`(name, select)
`between`(value[, value2])
`cast`(t)
`contains`(value)
`glob`(value)
`is_not_null`()
`is_null`()
`like`(value)
`not_between`(value[, value2])
`not_contains`(value)
`not_like`(value)

__init__(name, select)

Parameters:

name (str)
select (SqlSelectStat)

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

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