summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2021-01-10 20:50:01 +0100
committerErich Eckner <git@eckner.net>2021-01-10 20:50:01 +0100
commit198c1c537490c0cad8a76401d49bef8ecf0ab3c8 (patch)
treef672df0a7a533ff29765dc471fa9da24a60eaafa
parentab25da2a469046576d0aa5586db460f9986e361f (diff)
downloadbuilder-198c1c537490c0cad8a76401d49bef8ecf0ab3c8.tar.xz
bin/wtp: order results
-rwxr-xr-xbin/wtp8
1 files changed, 6 insertions, 2 deletions
diff --git a/bin/wtp b/bin/wtp
index 3545f61..b1b682f 100755
--- a/bin/wtp
+++ b/bin/wtp
@@ -29,7 +29,9 @@
printf 'CONCAT(".",`binary_packages`.`sub_pkgrel`),'
printf '""),'
printf '")"'
- printf ') SEPARATOR ", "'
+ printf ')'
+ printf ' ORDER BY `repositories`.`stability`'
+ printf ' SEPARATOR ", "'
printf ')'
printf ')'
printf ' FROM `binary_packages`'
@@ -41,6 +43,8 @@
printf '%s' "$*" | \
base64 -w0
printf '") AND `repositories`.`is_on_master_mirror`'
- printf ' GROUP BY CONCAT(`binary_packages`.`pkgname`,"-",`architectures`.`name`);\n'
+ printf ' GROUP BY CONCAT(`binary_packages`.`pkgname`,"-",`architectures`.`name`)'
+ printf ' ORDER BY `binary_packages`.`pkgname`,`architectures`.`name`'
+ printf ';\n'
} | \
mysql_run_query