Class NavigationFrame

xtop/core/navigation.py:47–153

Single frame in navigation history

@dataclass
class NavigationFrame:
    """Single frame in navigation history"""

    filters: Dict[str, List[Any]] = field(default_factory=dict)
    exclude_filters: Dict[str, List[Any]] = field(default_factory=dict)
    group_cols: List[str] = field(default_factory=list)
    sort_col: str = "samples"
    sort_desc: bool = True
    timestamp: datetime = field(default_factory=datetime.now)
    description: str = ""
    labels: Dict[str, str] = field(default_factory=dict)

    def to_where_clause(self) -> str:
        """Convert filters to SQL WHERE clause"""
        conditions: List[str] = []

        def qualify_column(col: str) -> str:
            """Qualify ambiguous columns with table alias"""
            if "." in col:
                return col  # Already qualified
            return col

        def _format_value(value: Any) -> str:
            if value is None:
                return "NULL"
            if isinstance(value, str):
                escaped = value.replace("'", "''")
                return "'" + escaped + "'"
            return str(value)

        # Handle include filters (= / IN)
        for col, values in self.filters.items():
            if not values:
                continue
            qualified_col = qualify_column(col)
            if len(values) == 1:
                value = values[0]
                if value is None:
                    conditions.append(f"{qualified_col} IS NULL")
                else:
                    conditions.append(f"{qualified_col} = {_format_value(value)}")
            else:
                formatted = [_format_value(v) for v in values if v is not None]
                if len(formatted) != len(values):
                    # Separate NULL handling: column IS NULL OR column IN (...)
                    non_null = [v for v in values if v is not None]
                    clauses = []
                    if non_null:
                        formatted_non_null = ", ".join(_format_value(v) for v in non_null)
                        clauses.append(f"{qualified_col} IN ({formatted_non_null})")
                    if any(v is None for v in values):
                        clauses.append(f"{qualified_col} IS NULL")
                    conditions.append("(" + " OR ".join(clauses) + ")")
                else:
                    values_str = ", ".join(formatted)
                    conditions.append(f"{qualified_col} IN ({values_str})")

        # Handle exclude filters (!= / NOT IN)