Revision d50ed8d4 snf-pithos-backend/pithos/backends/lib/sqlite/dbwrapper.py
b/snf-pithos-backend/pithos/backends/lib/sqlite/dbwrapper.py | ||
---|---|---|
1 | 1 |
# Copyright 2011-2012 GRNET S.A. All rights reserved. |
2 |
#
|
|
2 |
# |
|
3 | 3 |
# Redistribution and use in source and binary forms, with or |
4 | 4 |
# without modification, are permitted provided that the following |
5 | 5 |
# conditions are met: |
6 |
#
|
|
6 |
# |
|
7 | 7 |
# 1. Redistributions of source code must retain the above |
8 | 8 |
# copyright notice, this list of conditions and the following |
9 | 9 |
# disclaimer. |
10 |
#
|
|
10 |
# |
|
11 | 11 |
# 2. Redistributions in binary form must reproduce the above |
12 | 12 |
# copyright notice, this list of conditions and the following |
13 | 13 |
# disclaimer in the documentation and/or other materials |
14 | 14 |
# provided with the distribution. |
15 |
#
|
|
15 |
# |
|
16 | 16 |
# THIS SOFTWARE IS PROVIDED BY GRNET S.A. ``AS IS'' AND ANY EXPRESS |
17 | 17 |
# OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED |
18 | 18 |
# WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR |
... | ... | |
25 | 25 |
# LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN |
26 | 26 |
# ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE |
27 | 27 |
# POSSIBILITY OF SUCH DAMAGE. |
28 |
#
|
|
28 |
# |
|
29 | 29 |
# The views and conclusions contained in the software and |
30 | 30 |
# documentation are those of the authors and should not be |
31 | 31 |
# interpreted as representing official policies, either expressed |
... | ... | |
39 | 39 |
|
40 | 40 |
class DBWrapper(object): |
41 | 41 |
"""Database connection wrapper.""" |
42 |
|
|
42 |
|
|
43 | 43 |
def __init__(self, db): |
44 | 44 |
self.conn = sqlite3.connect(db, check_same_thread=False) |
45 | 45 |
self.conn.execute(""" pragma case_sensitive_like = on """) |
46 |
|
|
46 |
|
|
47 | 47 |
def close(self): |
48 | 48 |
self.conn.close() |
49 |
|
|
49 |
|
|
50 | 50 |
def execute(self): |
51 | 51 |
self.conn.execute('begin deferred') |
52 |
|
|
52 |
|
|
53 | 53 |
def commit(self): |
54 | 54 |
self.conn.commit() |
55 |
|
|
55 |
|
|
56 | 56 |
def rollback(self): |
57 | 57 |
self.conn.rollback() |
Also available in: Unified diff