summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xbin/mysql-functions11
1 files changed, 11 insertions, 0 deletions
diff --git a/bin/mysql-functions b/bin/mysql-functions
index 2f0b282..78728c0 100755
--- a/bin/mysql-functions
+++ b/bin/mysql-functions
@@ -983,3 +983,14 @@ mysql_remove_duplicate_build_order() {
} | \
${mysql_command}
}
+
+mysql_package_name_query() {
+ printf 'CONCAT('
+ printf '`binary_packages`.`pkgname`,"-",'
+ printf 'IF(`binary_packages`.`epoch`=0,"",CONCAT(`binary_packages`.`epoch`,":")),'
+ printf '`binary_packages`.`pkgver`,"-",'
+ printf '`binary_packages`.`pkgrel`,".",'
+ printf '`binary_packages`.`sub_pkgrel`,"-",'
+ printf '`architectures`.`name`,".pkg.tar.xz"'
+ printf ')'
+}