From a844091fa0913b7b18b1f2a087f717085384a3c6 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 14 Feb 2018 14:11:49 +0100 Subject: bin/mysql-functions: mysql_package_name_query new --- bin/mysql-functions | 11 +++++++++++ 1 file changed, 11 insertions(+) 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 ')' +} -- cgit v1.2.3-70-g09d2