bin/mysql-functions: mysql_sanity_check() new

1 files changed, 47 insertions, 0 deletions

diff --git a/bin/mysql-functions b/bin/mysql-functions
index 340f9d5..ca7d0ca 100755
--- a/bin/mysql-functions
+++ b/bin/mysql-functions
@@ -573,3 +573,50 @@ mysql_generate_package_metadata() {
 
   )
 }
+
+# mysql_sanity_check
+# do a sanity check on the mysql database
+
+mysql_sanity_check() {
+  ( # new shell is intentional
+    temp_dir=$(mktemp -d)
+    trap 'rm -rf --one-file-system "${temp_dir}"' EXIT
+
+    for dir in $(ls_master_mirror 'i686'); do
+      ls_master_mirror "i686/${dir}" | \
+        sed -n '
+          s/\.pkg\.tar\.xz$//
+          T
+          s/-\([0-9]\+\)-\([^-]\+\)$/-\1.0-\2/
+          s/-\([^-:]\+-[^-]\+-[^-]\+\)$/-0:\1/
+          s|^|'"${dir}"'/|
+          p
+        '
+    done | \
+      sort > \
+      "${temp_dir}/master-mirror-listing"
+
+    # shellcheck disable=SC2016
+    ${mysql_command} '
+      SELECT `repositories`.`name`,`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architectures`.`name`
+      FROM `binary_packages`
+      JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id`
+      JOIN `repositories` ON `binary_packages`.`repository`=`repositories`.`id`
+    ' --batch | \
+      sed '
+        1d
+        s,\t,/,
+        s,\t,-,
+        s,\t,:,
+        s,\t,-,
+        s,\t,.,
+        s,\t,-,
+      ' | \
+      sort > \
+      "${temp_dir}/mysql-packages"
+
+    diff -u \
+      "${temp_dir}/mysql-packages" \
+      "${temp_dir}/master-mirror-listing"
+  )
+}