lib/mysql-functions: mysql_find_build_assignment_loops(): insert looped packages, 20 at a time

1 files changed, 6 insertions, 2 deletions

diff --git a/lib/mysql-functions b/lib/mysql-functions
index aba6ce6..c605c8b 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -783,9 +783,13 @@ mysql_find_build_assignment_loops() {
             >&2 printf 'ERROR: non-numeric id "%s"\n' "${id}"
             continue
           fi
-          printf '(%s,%s),' "${loop}" "${id}"
+          printf '(%s,%s),\n' "${loop}" "${id}"
         done | \
-          sed 's/,$//'
+          sed '
+            1~20 i INSERT INTO `build_dependency_loops` (`loop`,`build_assignment`) VALUES ''
+            0~20 s/,$/;/
+            $ s/,$/;/
+          '
       }
   )
   {