fireinfo: Label unknown processors as "Unknown"

[ipfire.org.git] / src / backend / fireinfo.py

diff --git a/src/backend/fireinfo.py b/src/backend/fireinfo.py
index a295ca6c9479622724b41ef7be58548fa7b7d5ba..e5099599d0b67a417de01d7f421ed61b54284aea 100644 (file)
--- a/src/backend/fireinfo.py
+++ b/src/backend/fireinfo.py
@@ -1813,10 +1813,10 @@ class Fireinfo(Object):
 
        def get_cpu_vendors_map(self, when=None):
                res = self.db.query("WITH profiles AS (SELECT fireinfo_profiles_with_data_at(%s) AS id) \
-                       SELECT vendor, COUNT(vendor)::float / (SELECT COUNT(*) FROM profiles) AS count FROM profiles \
+                       SELECT COALESCE(vendor, %s) AS vendor, COUNT(vendor)::float / (SELECT COUNT(*) FROM profiles) AS count FROM profiles \
                        LEFT JOIN fireinfo_profiles_processors ON profiles.id = fireinfo_profiles_processors.profile_id \
                        LEFT JOIN fireinfo_processors ON fireinfo_profiles_processors.processor_id = fireinfo_processors.id \
-                       WHERE NOT fireinfo_profiles_processors.processor_id IS NULL GROUP BY vendor ORDER BY count DESC", when)
+                       WHERE NOT fireinfo_profiles_processors.processor_id IS NULL GROUP BY vendor ORDER BY count DESC", when, "Unknown")
 
                return ((CPU_VENDORS.get(r.vendor, r.vendor), r.count) for r in res)