zombee11/scorecardapi

1from decimal import Decimal, InvalidOperation2from typing import Any3 4 5def _to_bool(value: Any) -> bool | None:6    if isinstance(value, bool):7        return value8    if isinstance(value, str):9        lowered = value.strip().lower()10        if lowered in {"true", "1", "yes", "y"}:11            return True12        if lowered in {"false", "0", "no", "n"}:13            return False14    return None15 16 17def _to_decimal(value: Any) -> Decimal | None:18    if value is None:19        return None20    try:21        return Decimal(str(value))22    except (InvalidOperation, ValueError):23        return None24 25 26def _split_values(expected: str) -> list[str]:27    return [item.strip() for item in expected.split(",") if item.strip()]28 29 30def evaluate_operator(actual: Any, operator: str, expected: str) -> bool:31    op = operator.strip().upper()32    if actual is None:33        return False34 35    actual_bool = _to_bool(actual)36    expected_bool = _to_bool(expected)37    if actual_bool is not None and expected_bool is not None and op in {"=", "==", "!=", "<>"}:38        return actual_bool == expected_bool if op in {"=", "=="} else actual_bool != expected_bool39 40    actual_num = _to_decimal(actual)41    if op == "BETWEEN":42        bounds = _split_values(expected)43        if actual_num is None or len(bounds) != 2:44            return False45        low = _to_decimal(bounds[0])46        high = _to_decimal(bounds[1])47        return low is not None and high is not None and low <= actual_num <= high48 49    expected_num = _to_decimal(expected)50    if actual_num is not None and expected_num is not None:51        if op in {"=", "=="}:52            return actual_num == expected_num53        if op in {"!=", "<>"}:54            return actual_num != expected_num55        if op == ">":56            return actual_num > expected_num57        if op == ">=":58            return actual_num >= expected_num59        if op == "<":60            return actual_num < expected_num61        if op == "<=":62            return actual_num <= expected_num63 64    actual_str = str(actual).strip().upper()65    expected_str = str(expected).strip().upper()66    if op in {"=", "=="}:67        return actual_str == expected_str68    if op in {"!=", "<>"}:69        return actual_str != expected_str70    if op in {"IN", "NOT_IN"}:71        values = {value.upper() for value in _split_values(expected)}72        matched = actual_str in values73        return matched if op == "IN" else not matched74 75    raise ValueError(f"Unsupported operator: {operator}")76 77