常用期望
| 期望 | 用途 |
|---|---|
| expect_table_row_count_to_be_between | 行数区间 |
| expect_column_values_to_be_unique | 主键唯一 |
| expect_column_values_to_not_be_null | 非空 |
| expect_column_values_to_be_in_set | 枚举集合 |
| expect_column_values_to_be_between | 数值范围 |
| expect_column_values_to_match_regex | 格式正则 |
组合使用
组合使用
validator.expect_table_row_count_to_be_between(min_value=1000, max_value=10000000)
validator.expect_column_values_to_be_in_set("status", ["created", "paid", "shipped", "closed"])
validator.expect_column_values_to_match_regex("phone", r"^1[3-9][0-9]{9}$")
validator.expect_column_mean_to_be_between("pay_amount", min_value=10, max_value=500)阈值别写太死：均值类期望随业务波动，建议按近 30 天分位数确定区间。