diff options
| -rwxr-xr-x | bin/return-assignment | 22 | ||||
| -rwxr-xr-x | lib/mysql-functions | 29 |
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 +} |