lib/mysql-functions: mysql_load_min_and_max_versions() new

1 files changed, 1 insertions, 21 deletions

diff --git a/bin/return-assignment b/bin/return-assignment
index 8db7737..b1bd51e 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -538,27 +538,7 @@ if [ -n "${errors}" ]; then
   exit 1
 fi
 
-min_version=$(
-  # shellcheck disable=SC2016
-  {
-    printf 'SELECT CONCAT(`versions`.`epoch`,":",`versions`.`version`)'
-    printf ' FROM `versions`'
-    printf ' ORDER BY `versions`.`order`'
-    printf ' LIMIT 1'
-  } | \
-  mysql_run_query
-)
-
-max_version=$(
-  # shellcheck disable=SC2016
-  {
-    printf 'SELECT CONCAT(`versions`.`epoch`,":",`versions`.`version`)'
-    printf ' FROM `versions`'
-    printf ' ORDER BY `versions`.`order` DESC'
-    printf ' LIMIT 1'
-  } | \
-  mysql_run_query
-)
+mysql_load_min_and_max_versions
 
 while read -r package_id package_name; do
   # move namcap.logs