#!/bin/bash

(
  ls '/var/lib/pacman/sync' | \
    grep 'testing\.db$' | \
    sed 's|^|/var/lib/pacman/sync/|' | \
    xargs -rn1 bsdtar -tf | \
    sed -n '
      /\/$/{
        s|/$||
        p
      }
    '
  pacman -Q | \
    tr ' ' '-'
) | \
  sort | \
  uniq -d