From 48cdd01ea9d6a6a74edfc33ef73147b35ce927b5 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 9 May 2018 14:35:20 +0200 Subject: lib/mysql-functions: update binary_packages_in_repositories in mysql_generate_package_metadata() --- lib/mysql-functions | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'lib/mysql-functions') diff --git a/lib/mysql-functions b/lib/mysql-functions index d192112..cfc8a2e 100755 --- a/lib/mysql-functions +++ b/lib/mysql-functions @@ -487,6 +487,13 @@ mysql_generate_package_metadata() { 'repositories' 'name' "${current_repository}" \ 'architectures' 'name' "${arch}" printf ';\n' + printf 'COMMIT;\n' + printf 'INSERT IGNORE INTO `binary_packages_in_repositories` (`package`,`repository`)' + printf ' SELECT LAST_INSERT_ID(),`repositories`.`id`' + printf ' FROM `repositories`' + printf ' WHERE `repositories`.`name` = from_base64("%s");\n' \ + "${current_repository}" + printf 'COMMIT;\n' } | \ sed ' s|,)|)|g -- cgit v1.2.3-54-g00ecf