def _setup_handler(self, filename, autocommit=False, journal_mode='OFF',
cache_size=2000):
# Convert the filename to UTF-8, this is needed for windows, and special
# characters, see:
# http://www.sqlite.org/c3ref/open.html
unicode_filename = filename.decode(sys.getfilesystemencoding())
filename = unicode_filename.encode("utf-8")
self.filename = replace_file_special_chars(filename)
self.autocommit = autocommit
self.journal_mode = journal_mode
self.cache_size = cache_size
#
# Setup phase
#
if self.autocommit:
conn = sqlite3.connect(self.filename,
isolation_level=None,
check_same_thread=True)
else:
conn = sqlite3.connect(self.filename,
check_same_thread=True)
conn.execute('PRAGMA journal_mode = %s' % self.journal_mode)
conn.execute('PRAGMA cache_size = %s' % self.cache_size)
conn.text_factory = str
self.conn = conn
self.cursor = conn.cursor()
def _setup_handler(self,
filename,
autocommit=False,
journal_mode='OFF',
cache_size=2000):
# Convert the filename to UTF-8, this is needed for windows, and special
# characters, see:
# http://www.sqlite.org/c3ref/open.html
unicode_filename = filename.decode(sys.getfilesystemencoding())
filename = unicode_filename.encode("utf-8")
self.filename = replace_file_special_chars(filename)
self.autocommit = autocommit
self.journal_mode = journal_mode
self.cache_size = cache_size
#
# Setup phase
#
if self.autocommit:
conn = sqlite3.connect(self.filename,
isolation_level=None,
check_same_thread=True)
else:
conn = sqlite3.connect(self.filename, check_same_thread=True)
conn.execute('PRAGMA journal_mode = %s' % self.journal_mode)
conn.execute('PRAGMA cache_size = %s' % self.cache_size)
conn.text_factory = str
self.conn = conn
self.cursor = conn.cursor()
