Class WardrivingEngine

wardriving.py:1332–4054

Main wardriving engine that coordinates WiFi scanning and GPS.

        # Add GPS track
        with self._lock:
            try:
                with sqlite3.connect(self.db_path) as conn:
                    track = conn.execute("SELECT latitude, longitude, altitude FROM gps_track ORDER BY timestamp").fetchall()
                    if track:
                        coords = ' '.join(f'{r[1]},{r[0]},{r[2] or 0}' for r in track)
                        kml_parts.append(f''&#x27;<Placemark>
<name>GPS Track</name>
<Style><LineStyle><color>ff0088ff</color><width>3</width></LineStyle></Style>
<LineString><tessellate>1</tessellate><coordinates>{coords}</coordinates></LineString>
</Placemark>''&#x27;)
            except Exception:
                pass

        kml_parts.extend(['</Document>', '</kml>'])
        return '\n'.join(kml_parts)

    # ------------------------------------------------------------------
    # Survey report (self-contained, printable HTML → PDF)
    # ------------------------------------------------------------------

    def _report_collect(self):
        """Gather everything a survey report needs in a single DB pass.

        Returns a plain dict so export_report_html stays pure formatting.
        Every table read is defensive: older session DBs may lack the
        bluetooth/cell/zigbee tables, and a report must never fail because
        an optional radio was never used."""
        data = {
            'session_id': self.session_id,
            'security': {'open': 0, 'owe': 0, 'wep': 0, 'wpa': 0, 'wpa2': 0, 'wpa3': 0, 'other': 0},
            'bands': {'2.4GHz': 0, '5GHz': 0, '6GHz': 0, 'other': 0},
            'channels': {},          # channel -> count
            'total_wifi': 0,
            'top_networks': [],      # strongest signal
            'risk_networks': [],     # open / WEP for the concern list
            'cameras': [],
            'bt_count': 0, 'cell_count': 0, 'zigbee_count': 0,
            'coverage': self.get_coverage_stats(),
            'gps': {'points': 0, 'lat_min': None, 'lat_max': None,
                    'lon_min': None, 'lon_max': None, 'distance_km': 0.0},
            'first_seen': None, 'last_seen': None,
        }
        with self._lock:
            try:
                with sqlite3.connect(self.db_path) as conn:
                    conn.row_factory = sqlite3.Row
                    rows = conn.execute("SELECT * FROM networks").fetchall()
                    for row in rows:
                        r = dict(row)
                        data['total_wifi'] += 1
                        sec = (r.get('security') or '').upper()
                        if not sec or sec in ('--',):
                            data['security']['open'] += 1
                        elif 'OWE' in sec:
                            data['security']['owe'] += 1
                        elif 'WEP' in sec:
                            data['security']['wep'] += 1