summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xbin/mysql-functions47
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"
+ )
+}