feat(db-functions): Check the archive index in check_reproducible

With the archive and repos no longer hosted on the same server[1], the
existence of "dependent packages" can no longer be determined solely by
checking whether the file exists in the local archive directory, which
now contains at most a few days worth of packages.

To solve this the archive index[2] must also be checked which contains
all archived packages. We still need to check locally first, as the
archive index is only updated once a day.

[1] https://lists.archlinux.org/archives/list/arch-dev-public@lists.archlinux.org/thread/B66SQUW4HOJAN2WHG4RLEBLYWNWOSF3Y/
[2] https://archive.archlinux.org/packages/.all/index.0.xz

mentioned in issue infrastructure#531 (closed)

@klausenbusk whats the status of the index sync and this marked as draft?

A small note, can you please remove the Fix annotation from the commit as it would close the whole ifra issue.

added 2 commits

• 9f32b030 - fixup! Fix check_reproducible() after split repo/archive split
• 3ec8cc51 - fixup! Fix check_reproducible() after split repo/archive split

Compare with previous version

added 1 commit

• 3c647f4d - fixup! Fix check_reproducible() after split repo/archive split

Compare with previous version

added 1 commit

• 4fb27597 - fixup! Fix check_reproducible() after split repo/archive split

Compare with previous version

added 1 commit

• c3a99910 - feat(db-functions): Check the archive index in check_reproducible

Compare with previous version

marked this merge request as ready

changed title from Draft: Fix check_reproducible() after split repo/archive split to feat(db-functions): Check the archive index in check_reproducible

changed the description

added 1 commit

• a56c7109 - feat(db-functions): Check the archive index in check_reproducible

Compare with previous version

resolved all threads

merged