Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-02-11 14:10:09 +0100
committerErich Eckner <git@eckner.net>2018-02-11 14:10:09 +0100
commitb8c6ba933adb5f4bad3ac28864a61d7e3b7166c1 (patch)
treee965aad88310b81980e7689365df32e30a79504b
parent8a47d8320876599924e73a75a33c8fe3d20dc163 (diff)
bin/get-package-updates: fix black listing mysql query
-rwxr-xr-xbin/get-package-updates4
1 files changed, 3 insertions, 1 deletions
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","")'