Method get_optimization_history

rightnow_cli/cache.py:265–291

Get optimization history.

(
        self,
        model_name: Optional[str] = None,
        limit: int = 100
    )

            conn.commit()
    
    def get_optimization_history(
        self,
        model_name: Optional[str] = None,
        limit: int = 100
    ) -> List[Dict[str, Any]]:
        """Get optimization history."""
        with sqlite3.connect(self.db_path) as conn:
            cursor = conn.cursor()
            
            if model_name:
                query = """
                    SELECT * FROM optimization_history
                    WHERE model_name = ?
                    ORDER BY timestamp DESC
                    LIMIT ?
                """
                cursor.execute(query, (model_name, limit))
            else:
                query = """
                    SELECT * FROM optimization_history
                    ORDER BY timestamp DESC
                    LIMIT ?
                """
                cursor.execute(query, (limit,))
            
            columns = [desc[0] for desc in cursor.description]
            return [dict(zip(columns, row)) for row in cursor.fetchall()]