From b8c6ba933adb5f4bad3ac28864a61d7e3b7166c1 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Sun, 11 Feb 2018 14:10:09 +0100
Subject: bin/get-package-updates: fix black listing mysql query

---
 bin/get-package-updates | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'bin/get-package-updates')

diff --git a/bin/get-package-updates b/bin/get-package-updates
index 8322e6d..612294e 100755
--- a/bin/get-package-updates
+++ b/bin/get-package-updates
@@ -403,9 +403,11 @@ while [ -n "${black_listed_new}" ]; do
       {
         printf 'CREATE TEMPORARY TABLE `bl` (`pkgbase` VARCHAR(64));\n'
         printf 'INSERT INTO `bl` (`pkgbase`) VALUES '
-        printf '(from_base64("%s")),\n' "${black_listed}" | \
+        printf '%s\n' "${black_listed}" | \
           sort -u | \
           sed '
+            s/^/(from_base64("/
+            s/$/")),/
             $ s/,$/;/
           '
         printf 'SELECT replace(to_base64(`a_ps`.`pkgbase`),"\\n","")'
-- 
cgit v1.2.3-70-g09d2