Load from SQLite database and filter for SQL ports.
(self)
| 89 | self.console = Console() |
| 90 | |
| 91 | def load_scan_file(self): |
| 92 | """ |
| 93 | Load from SQLite database and filter for SQL ports. |
| 94 | """ |
| 95 | try: |
| 96 | data = self.shared_data.read_data() |
| 97 | self.scan = pd.DataFrame(data) |
| 98 | if "Ports" not in self.scan.columns: |
| 99 | self.scan["Ports"] = None |
| 100 | except Exception as e: |
| 101 | logger.warning(f"Could not read data from database: {e}") |
| 102 | self.scan = pd.DataFrame(columns=['MAC Address', 'IPs', 'Hostnames', 'Ports', 'Alive']) |
| 103 | # Ensure Ports column is string type before using .str accessor |
| 104 | self.scan["Ports"] = self.scan["Ports"].astype(str) |
| 105 | self.scan = self.scan[self.scan["Ports"].str.contains("3306", na=False)] |
| 106 | |
| 107 | def sql_connect(self, adresse_ip, user, password): |
| 108 | """ |
no test coverage detected