Revision 672c9f5a pithos/backends/lib/sqlalchemy/dbwrapper.py

b/pithos/backends/lib/sqlalchemy/dbwrapper.py
44 44 
        if db.startswith('sqlite://'):
45 45 
            class ForeignKeysListener(PoolListener):
46 46 
                def connect(self, dbapi_con, con_record):
47 
                    db_cursor = dbapi_con.execute('pragma foreign_keys=ON')
47 
                    db_cursor = dbapi_con.execute('pragma foreign_keys=ON;')
48 
                    db_cursor = dbapi_con.execute('PRAGMA case_sensitive_like=ON;')
48 49 
            self.engine = create_engine(db, connect_args={'check_same_thread': False}, poolclass=NullPool, listeners=[ForeignKeysListener()])
49 50 
        elif db.startswith('mysql://'):
50 51 
            db = '%s?charset=utf8&use_unicode=0' %db

Also available in: Unified diff