expect_column_values_to_not_match_regex_list.sql

{% test expect_column_values_to_not_match_regex_list(model, column_name,
                                                    regex_list,
                                                    match_on="any",
                                                    row_condition=None,
                                                    is_raw=False,
                                                    flags=""
                                                    ) %}

{% set expression %}
{% for regex in regex_list %}
{{ dbt_expectations.regexp_instr(column_name, regex, is_raw=is_raw, flags=flags) }} = 0
{%- if not loop.last %}
{{ " and " if match_on == "all" else " or "}}
{% endif -%}
{% endfor %}
{% endset %}

{{ dbt_expectations.expression_is_true(model,
                                        expression=expression,
                                        group_by_columns=None,
                                        row_condition=row_condition
                                        )
                                        }}

{% endtest %}