row.py

class Row:
    """
    A row of data from a cursor fetch operation. Provides both tuple-like indexing
    and attribute access to column values.
    
    Example:
        row = cursor.fetchone()
        print(row[0])           # Access by index
        print(row.column_name)  # Access by column name
    """
    
    def __init__(self, values, cursor_description):
        """
        Initialize a Row object with values and cursor description.
        
        Args:
            values: List of values for this row
            cursor_description: The cursor description containing column metadata
        """
        self._values = values
        
        # TODO: ADO task - Optimize memory usage by sharing column map across rows
        # Instead of storing the full cursor_description in each Row object:
        # 1. Build the column map once at the cursor level after setting description
        # 2. Pass only this map to each Row instance
        # 3. Remove cursor_description from Row objects entirely
        
        # Create mapping of column names to indices
        self._column_map = {}
        for i, desc in enumerate(cursor_description):
            if desc and desc[0]:  # Ensure column name exists
                self._column_map[desc[0]] = i
    
    def __getitem__(self, index):
        """Allow accessing by numeric index: row[0]"""
        return self._values[index]
    
    def __getattr__(self, name):
        """Allow accessing by column name as attribute: row.column_name"""
        if name in self._column_map:
            return self._values[self._column_map[name]]
        raise AttributeError(f"'{self.__class__.__name__}' object has no attribute '{name}'")
    
    def __eq__(self, other):
        """
        Support comparison with lists for test compatibility.
        This is the key change needed to fix the tests.
        """
        if isinstance(other, list):
            return self._values == other
        elif isinstance(other, Row):
            return self._values == other._values
        return super().__eq__(other)
    
    def __len__(self):
        """Return the number of values in the row"""
        return len(self._values)
    
    def __iter__(self):
        """Allow iteration through values"""
        return iter(self._values)
    
    def __str__(self):
        """Return string representation of the row"""
        return str(tuple(self._values))

    def __repr__(self):
        """Return a detailed string representation for debugging"""
        return repr(tuple(self._values))