lib/mysql-functions: mysql_load_min_and_max_versions() new

2 files changed, 30 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
diff --git a/lib/mysql-functions b/lib/mysql-functions
index 8cdafad..6c8154c 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -1257,3 +1257,32 @@ mysql_sort_versions() {
       mysql_run_query
   )
 }
+
+# mysql_load_min_and_max_versions
+# load the minimal and maximal versions into min_version and max_version
+
+mysql_load_min_and_max_versions() {
+  if [ -z "${min_version}" ]; then
+    min_version=$(
+      {
+        printf 'SELECT CONCAT(`versions`.`epoch`,":",`versions`.`version`)'
+        printf ' FROM `versions`'
+        printf ' ORDER BY `versions`.`order`'
+        printf ' LIMIT 1'
+      } | \
+      mysql_run_query
+    )
+  fi
+
+  if [ -z "${max_version}" ]; then
+    max_version=$(
+      {
+        printf 'SELECT CONCAT(`versions`.`epoch`,":",`versions`.`version`)'
+        printf ' FROM `versions`'
+        printf ' ORDER BY `versions`.`order` DESC'
+        printf ' LIMIT 1'
+      } | \
+      mysql_run_query
+    )
+  fi
+}