bin/mysql-functions: mysql_package_name_query new

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 ')'
+}