improve debian filtering

[etc/mailfilter.git] / procmail / sql-escape

diff --git a/procmail/sql-escape b/procmail/sql-escape
index 08d0903f33b50eb69d57ed651b380fcef3894522..c8bb8c9e096577885df6f9091987d0d33b51609f 100644 (file)
--- a/procmail/sql-escape
+++ b/procmail/sql-escape
@@ -1,17 +1,14 @@
-SQ="'\\''"
-SQE="'\\\''"
-
 :0
 * DATA ?? .
-{ 
+{
+  # 1. replace ' with ''
+  # 2. add quotes to each line
+  # 3. swap comma outside
   DATA="`echo \"$DATA\" \
-    | sed -re 's,'\'','$SQE$SQE',g;' \
-          -e  's/^.*$/'\$SQE'&'\$SQE'/' \
-          -e  's/,'$SQE'$/'\$SQE',/'`"
+    | sed -re \"s,','',g\" \
+           -e \"s/^.*$/'&'/\" \
+           -e \"s/,'$/',/\"`"
 }
 
 :0 E
 { LOG="sql-escape:  WARNING: no \$DATA provided!$NL" }
-
-SQE
-SQ