SqlRuleFilter Class

Represents a filter which is a composition of an expression and an action that is executed in the pub/sub pipeline.

Inheritance

builtins.object

SqlRuleFilter

Constructor

SqlRuleFilter(sql_expression: Optional[str] = None, parameters: Optional[Dict[str, Union[str, int, float, bool, datetime.datetime, datetime.timedelta]]] = None)

Parameters

sql_expression

str

default value: None

The SQL expression. e.g. MyProperty='ABC'

parameters

dict[str, <xref:Union>[str, int, float, bool, datetime, <xref:timedelta>]]

default value: None

Sets the value of the sql expression parameters if any.

Examples

Create SqlRuleFilter.

   sql_filter = SqlRuleFilter("property1 = 'value'")
   sql_filter_parametrized = SqlRuleFilter(
       "property1 = @param1 AND property2 = @param2",
       parameters={
           "@param1": "value",
           "@param2" : 1
       }
   )