Escape catch-all characters in LIKE queries.

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

diff --git a/pithos/backends/lib/sqlite/dbwrapper.py b/pithos/backends/lib/sqlite/dbwrapper.py
index ebe16be..17e089d 100644 (file)
--- a/pithos/backends/lib/sqlite/dbwrapper.py
+++ b/pithos/backends/lib/sqlite/dbwrapper.py
@@ -38,6 +38,10 @@ class DBWrapper(object):
     
     def __init__(self, db):
         self.conn = sqlite3.connect(db, check_same_thread=False)
+        self.conn.execute(""" pragma case_sensitive_like = on """)
+    
+    def close(self):
+        self.conn.close()
     
     def execute(self):
         self.conn.execute('begin deferred')