sanity checks make use of new mysql_package_name_query

1 files changed, 9 insertions, 35 deletions

diff --git a/lib/mysql-functions b/lib/mysql-functions
index 0de438f..6619968 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -673,13 +673,9 @@ mysql_sanity_check() {
     for arch in 'i686'; do
       for dir in $(ls_master_mirror "${arch}"); do
         ls_master_mirror "${arch}/${dir}" | \
-          sed -n '
-            s/\.pkg\.tar\.xz$//
-            T
-            s/-\([0-9]\+\)-\([^-]\+\)$/-\1.0-\2/
-            s/-\([^-:]\+-[^-]\+-[^-]\+\)$/-0:\1/
+          sed '
+            /\.pkg\.tar\.xz$/!d
             s|^|'"${arch}"'/'"${dir}"'/|
-            p
           '
       done
     done | \
@@ -687,15 +683,9 @@ mysql_sanity_check() {
       "${temp_dir}/master-mirror-listing"
 
     {
-      printf 'SELECT `r_a`.`name`,`repositories`.`name`,'
-      printf '`binary_packages`.`%s`,' \
-        'pkgname' \
-        'epoch' \
-        'pkgver' \
-        'pkgrel' \
-        'sub_pkgrel'
-      printf '`architectures`.`name`'
-      printf ' FROM `binary_packages_in_repositories`'
+      printf 'SELECT CONCAT(`r_a`.`name`,"/",`repositories`.`name`,"/",'
+      mysql_package_name_query
+      printf ') FROM `binary_packages_in_repositories`'
       mysql_join_binary_packages_in_repositories_binary_packages
       mysql_join_binary_packages_architectures
       mysql_join_binary_packages_in_repositories_repositories
@@ -721,12 +711,9 @@ mysql_sanity_check() {
 
     # shellcheck disable=SC2041
     ls_master_mirror 'pool' | \
-      sed -n '
-        s/\.pkg\.tar\.xz\(\.sig\)\?$//
-        T
-        s/-\([0-9]\+\)-\([^-]\+\)$/-\1.0-\2/
-        s/-\([^-:]\+-[^-]\+-[^-]\+\)$/-0:\1/
-        p
+      sed '
+        s/\.sig$//
+        /\.pkg\.tar\.xz$/ !d
       ' | \
       sort | \
       uniq -c | \
@@ -736,13 +723,7 @@ mysql_sanity_check() {
 
     {
       printf 'SELECT '
-      printf '`binary_packages`.`%s`,' \
-        'pkgname' \
-        'epoch' \
-        'pkgver' \
-        'pkgrel' \
-        'sub_pkgrel'
-      printf '`architectures`.`name`'
+      mysql_package_name_query
       printf ' FROM `binary_packages`'
       mysql_join_binary_packages_architectures
       printf ' WHERE NOT EXISTS ('
@@ -758,13 +739,6 @@ mysql_sanity_check() {
       printf ')'
     } | \
       mysql_run_query | \
-      sed '
-        s,\t,-,
-        s,\t,:,
-        s,\t,-,
-        s,\t,.,
-        s,\t,-,
-      ' | \
       sort > \
       "${temp_dir}/mysql-packages-pool"