| from decimal import Decimal, InvalidOperation |
| from typing import Any |
|
|
|
|
| def _to_bool(value: Any) -> bool | None: |
| if isinstance(value, bool): |
| return value |
| if isinstance(value, str): |
| lowered = value.strip().lower() |
| if lowered in {"true", "1", "yes", "y"}: |
| return True |
| if lowered in {"false", "0", "no", "n"}: |
| return False |
| return None |
|
|
|
|
| def _to_decimal(value: Any) -> Decimal | None: |
| if value is None: |
| return None |
| try: |
| return Decimal(str(value)) |
| except (InvalidOperation, ValueError): |
| return None |
|
|
|
|
| def _split_values(expected: str) -> list[str]: |
| return [item.strip() for item in expected.split(",") if item.strip()] |
|
|
|
|
| def evaluate_operator(actual: Any, operator: str, expected: str) -> bool: |
| op = operator.strip().upper() |
| if actual is None: |
| return False |
|
|
| actual_bool = _to_bool(actual) |
| expected_bool = _to_bool(expected) |
| if actual_bool is not None and expected_bool is not None and op in {"=", "==", "!=", "<>"}: |
| return actual_bool == expected_bool if op in {"=", "=="} else actual_bool != expected_bool |
|
|
| actual_num = _to_decimal(actual) |
| if op == "BETWEEN": |
| bounds = _split_values(expected) |
| if actual_num is None or len(bounds) != 2: |
| return False |
| low = _to_decimal(bounds[0]) |
| high = _to_decimal(bounds[1]) |
| return low is not None and high is not None and low <= actual_num <= high |
|
|
| expected_num = _to_decimal(expected) |
| if actual_num is not None and expected_num is not None: |
| if op in {"=", "=="}: |
| return actual_num == expected_num |
| if op in {"!=", "<>"}: |
| return actual_num != expected_num |
| if op == ">": |
| return actual_num > expected_num |
| if op == ">=": |
| return actual_num >= expected_num |
| if op == "<": |
| return actual_num < expected_num |
| if op == "<=": |
| return actual_num <= expected_num |
|
|
| actual_str = str(actual).strip().upper() |
| expected_str = str(expected).strip().upper() |
| if op in {"=", "=="}: |
| return actual_str == expected_str |
| if op in {"!=", "<>"}: |
| return actual_str != expected_str |
| if op in {"IN", "NOT_IN"}: |
| values = {value.upper() for value in _split_values(expected)} |
| matched = actual_str in values |
| return matched if op == "IN" else not matched |
|
|
| raise ValueError(f"Unsupported operator: {operator}") |
|
|
|
|
