Escape catch-all characters in LIKE queries.

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

diff --git a/pithos/backends/lib/sqlalchemy/dbworker.py b/pithos/backends/lib/sqlalchemy/dbworker.py
index beb2a8a..2537e57 100644 (file)
--- a/pithos/backends/lib/sqlalchemy/dbworker.py
+++ b/pithos/backends/lib/sqlalchemy/dbworker.py
@@ -39,3 +39,6 @@ class DBWorker(object):
         self.params = params
         self.conn = params['wrapper'].conn
         self.engine = params['wrapper'].engine
+    
+    def escape_like(self, s):
+        return s.replace('\\', '\\\\').replace('%', '\%').replace('_', '\_')