summaryrefslogtreecommitdiff
path: root/bin/mysql-functions
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-02-14 14:11:49 +0100
committerErich Eckner <git@eckner.net>2018-02-14 14:11:49 +0100
commita844091fa0913b7b18b1f2a087f717085384a3c6 (patch)
tree72862004150658e784dc8bb008690e3c6d5f865d /bin/mysql-functions
parent437fa0fc93e4c59b7d677a4d954dbd4656448b15 (diff)
downloadbuilder-a844091fa0913b7b18b1f2a087f717085384a3c6.tar.xz
bin/mysql-functions: mysql_package_name_query new
Diffstat (limited to 'bin/mysql-functions')
-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 ')'
+}