Escape catch-all characters in LIKE queries.

[pithos] / pithos / backends / lib / sqlite / dbworker.py

diff --git a/pithos/backends/lib/sqlite/dbworker.py b/pithos/backends/lib/sqlite/dbworker.py
index cce4c60..3c7efb2 100644 (file)
--- a/pithos/backends/lib/sqlite/dbworker.py
+++ b/pithos/backends/lib/sqlite/dbworker.py
@@ -45,3 +45,6 @@ class DBWorker(object):
         self.fetchall = cur.fetchall
         self.cur = cur
         self.conn = conn
+    
+    def escape_like(self, s):
+        return s.replace('\\', '\\\\').replace('%', '\%').replace('_', '\_')