Merge ~litios/ubuntu-cve-tracker:bug/pkg-cache-ppas into ubuntu-cve-tracker:master

[David Fernandez Gonzalez]

There is a bug when updating the cache for PPAs after the first time since all updates are marked with the Release pocket there, and we are not including in for future syncs.

Example with the change:
DEBUG: Reading esm-apps_xenial-pkg-cache.json
DEBUG: UPDATING CACHE
DEBUG: Retrieving Launchpad publications since 2024-05-22 15:40:39.232662+00:00
DEBUG: atril, 1.12.2-1ubuntu0.3+esm1, Release, 2024-06-05 20:27:52.246413+00:00, Published
DEBUG: ffmpeg, 7:2.8.17-0ubuntu0.1+esm7, Release, 2024-05-30 12:59:35.892208+00:00, Published
DEBUG: vlc, 2.2.2-5ubuntu0.16.04.5+esm3, Release, 2024-05-22 16:40:39.232662+00:00, Published
DEBUG: Retrieving Launchpad publications since 2024-05-22 15:40:39.232662+00:00
DEBUG: NEW DATE: 1717619272.246413
DEBUG: WRITING TO CACHE
DEBUG: esm-apps_xenial, esm-apps/xenial

[Eduardo Barretto (ebarretto)]

lgtm, thanks!

review: Approve

diff --git a/scripts/generate_pkg_cache.py b/scripts/generate_pkg_cache.py
index a858100..250145e 100644
--- a/scripts/generate_pkg_cache.py
+++ b/scripts/generate_pkg_cache.py
@@ -26,6 +26,7 @@ is_debug = False
 pockets = []
 
 def load_cache_file(cache_dir, release):
+    parent = release_parent(release)
     rel = release.replace('/', '_')
     filename = f"{rel}-pkg-cache.json"
     cache = {}
@@ -35,6 +36,9 @@ def load_cache_file(cache_dir, release):
             debug(f"Reading {filename}")
             pockets.append("Security")
             pockets.append("Updates")
+            if parent:
+                # In PPAs, security updates are marked with Release pocket.
+                pockets.append("Release")
     except OSError:
         debug(f"File {filename} not found!")
         debug(f"Creating {filename}")
@@ -63,7 +67,7 @@ def get_binaries_rel(release, archive, real_threshold, series, cache, latest_dat
         if s.pocket not in pockets:
             continue
 
-        debug(f"{s.source_package_name}, {s.date_created}, {s.status}")
+        debug(f"{s.source_package_name}, {s.source_package_version}, {s.pocket}, {s.date_created}, {s.status}")
         if latest_date_created is None or s.date_created > latest_date_created:
             latest_date_created = s.date_created