Method delete_host

db_manager.py:858–890

Delete a host record by MAC address. Args: mac: MAC address to delete Returns: bool: True if successful

(self, mac: str)

                cursor.execute(
                    f"UPDATE hosts SET {column} = ?, updated_at = CURRENT_TIMESTAMP WHERE lower(mac) = lower(?)",
                    (status, mac)
                )
                updated = cursor.rowcount > 0
                if not updated:
                    logger.debug(f"No host updated for MAC {mac} when setting {column}")
                return updated
        except Exception as exc:
            logger.error(f"Failed to update action status for {mac}: {exc}")
            return False
    
    def delete_host(self, mac: str) -> bool:
        """
        Delete a host record by MAC address.
        
        Args:
            mac: MAC address to delete
            
        Returns:
            bool: True if successful
        """
        if not mac:
            logger.warning("Cannot delete host without MAC address")
            return False
        
        # Normalize MAC address
        mac = mac.lower().strip()
        
        try:
            with self.get_connection() as conn:
                cursor = conn.cursor()
                cursor.execute("DELETE FROM hosts WHERE mac = ?", (mac,))
                conn.commit()
                
                if cursor.rowcount > 0:
                    logger.info(f"Deleted host: {mac}")
                    return True