Method cache_wifi_scan

db_manager.py:1448–1511

Cache WiFi scan results to reduce expensive nmcli rescan calls. Args: networks: List of network dicts with ssid, signal, security, etc.

(self, networks: List[Dict[str, Any]])

            logger.info(f"Exported {len(hosts)} hosts to {csv_path}")
            return True
            
        except Exception as e:
            logger.error(f"Failed to export to CSV: {e}")
            return False


    # ============================================================================
    # WIFI MANAGEMENT METHODS
    # ============================================================================
    
    def cache_wifi_scan(self, networks: List[Dict[str, Any]]):
        """
        Cache WiFi scan results to reduce expensive nmcli rescan calls.
        
        Args:
            networks: List of network dicts with ssid, signal, security, etc.
        """
        try:
            with self.get_connection() as conn:
                cursor = conn.cursor()
                timestamp = datetime.now()
                
                for network in networks:
                    ssid = network.get('ssid', '').strip()
                    if not ssid or network.get('instruction'):  # Skip instruction entries
                        continue
                    
                    # Check if network exists
                    cursor.execute("""
                        SELECT scan_count FROM wifi_scan_cache WHERE ssid = ?
                    """, (ssid,))
                    row = cursor.fetchone()
                    
                    if row:
                        # Update existing entry
                        scan_count = row[0] + 1
                        cursor.execute("""
                            UPDATE wifi_scan_cache
                            SET signal = ?,
                                security = ?,
                                last_seen = ?,
                                scan_count = ?,
                                is_known = ?,
                                has_system_profile = ?
                            WHERE ssid = ?
                        """, (
                            network.get('signal', 0),
                            network.get('security', ''),
                            timestamp,
                            scan_count,
                            1 if network.get('known', False) else 0,
                            1 if network.get('has_system_profile', False) else 0,
                            ssid
                        ))
                    else:
                        # Insert new entry
                        cursor.execute("""
                            INSERT INTO wifi_scan_cache