Python row_constraint示例

示例#1

文件： test_regulation.py 项目： roll/frictionless-py

def test_validate_row_constraint_list_in_formula_issue_817():
    data = [["val"], ["one"], ["two"]]
    report = validate(
        data,
        checks=[
            checks.duplicate_row(),
            checks.row_constraint(formula="val in ['one', 'two']"),
        ],
    )
    assert report.valid

示例#2

文件： test_regulation.py 项目： hbruch/frictionless-py

def test_validate_row_constraint():
    source = [
        ["row", "salary", "bonus"],
        [2, 1000, 200],
        [3, 2500, 500],
        [4, 1300, 500],
        [5, 5000, 1000],
        [6],
    ]
    report = validate(
        source, checks=[checks.row_constraint(formula="salary == bonus * 5")])
    assert report.flatten(["rowPosition", "fieldPosition", "code"]) == [
        [4, None, "row-constraint"],
        [6, 2, "missing-cell"],
        [6, 3, "missing-cell"],
        [6, None, "row-constraint"],
    ]