File size: 2,493 Bytes
7872230 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 | 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}")
|