Method get_wifi_network_analytics

db_manager.py:1757–1794

Get WiFi network analytics for one or all networks. Args: ssid: Specific SSID or None for all networks Returns: List of analytics dicts sorted by priority score

(self, ssid: str = None)

                        now if success else None,
                        failure_reason if not success else None,
                        success_rate,
                        priority_score,
                        now
                    ))
                
                conn.commit()
                
        except Exception as e:
            logger.error(f"Error updating WiFi analytics: {e}")
    
    def get_wifi_network_analytics(self, ssid: str = None) -> List[Dict[str, Any]]:
        """
        Get WiFi network analytics for one or all networks.
        
        Args:
            ssid: Specific SSID or None for all networks
            
        Returns:
            List of analytics dicts sorted by priority score
        """
        try:
            with self.get_connection() as conn:
                cursor = conn.cursor()
                
                if ssid:
                    cursor.execute("""
                        SELECT * FROM wifi_network_analytics
                        WHERE ssid = ?
                    """, (ssid,))
                else:
                    cursor.execute("""
                        SELECT * FROM wifi_network_analytics
                        ORDER BY priority_score DESC
                    """)
                
                columns = [desc[0] for desc in cursor.description]
                results = []
                
                for row in cursor.fetchall():
                    result = dict(zip(columns, row))
                    results.append(result)