lib/mysql-functions: update binary_packages_in_repositories in mysql_generate_package_metadata()

1 files changed, 7 insertions, 0 deletions

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