Statistics
| Branch: | Tag: | Revision:

root / pithos / backends / lib / sqlite / dbwrapper.py @ 95d47e1a

History | View | Annotate | Download (2 kB)

1 a9b3f29d Antony Chazapis
# Copyright 2011 GRNET S.A. All rights reserved.
2 a9b3f29d Antony Chazapis
# 
3 a9b3f29d Antony Chazapis
# Redistribution and use in source and binary forms, with or
4 a9b3f29d Antony Chazapis
# without modification, are permitted provided that the following
5 a9b3f29d Antony Chazapis
# conditions are met:
6 a9b3f29d Antony Chazapis
# 
7 a9b3f29d Antony Chazapis
#   1. Redistributions of source code must retain the above
8 a9b3f29d Antony Chazapis
#      copyright notice, this list of conditions and the following
9 a9b3f29d Antony Chazapis
#      disclaimer.
10 a9b3f29d Antony Chazapis
# 
11 a9b3f29d Antony Chazapis
#   2. Redistributions in binary form must reproduce the above
12 a9b3f29d Antony Chazapis
#      copyright notice, this list of conditions and the following
13 a9b3f29d Antony Chazapis
#      disclaimer in the documentation and/or other materials
14 a9b3f29d Antony Chazapis
#      provided with the distribution.
15 a9b3f29d Antony Chazapis
# 
16 a9b3f29d Antony Chazapis
# THIS SOFTWARE IS PROVIDED BY GRNET S.A. ``AS IS'' AND ANY EXPRESS
17 a9b3f29d Antony Chazapis
# OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
18 a9b3f29d Antony Chazapis
# WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
19 a9b3f29d Antony Chazapis
# PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL GRNET S.A OR
20 a9b3f29d Antony Chazapis
# CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
21 a9b3f29d Antony Chazapis
# SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
22 a9b3f29d Antony Chazapis
# LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
23 a9b3f29d Antony Chazapis
# USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED
24 a9b3f29d Antony Chazapis
# AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
25 a9b3f29d Antony Chazapis
# LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
26 a9b3f29d Antony Chazapis
# ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
27 a9b3f29d Antony Chazapis
# POSSIBILITY OF SUCH DAMAGE.
28 a9b3f29d Antony Chazapis
# 
29 a9b3f29d Antony Chazapis
# The views and conclusions contained in the software and
30 a9b3f29d Antony Chazapis
# documentation are those of the authors and should not be
31 a9b3f29d Antony Chazapis
# interpreted as representing official policies, either expressed
32 a9b3f29d Antony Chazapis
# or implied, of GRNET S.A.
33 a9b3f29d Antony Chazapis
34 2c5363a0 Antony Chazapis
import sqlite3
35 a9b3f29d Antony Chazapis
36 2c5363a0 Antony Chazapis
class DBWrapper(object):
37 2c5363a0 Antony Chazapis
    """Database connection wrapper."""
38 a9b3f29d Antony Chazapis
    
39 2c5363a0 Antony Chazapis
    def __init__(self, db):
40 2c5363a0 Antony Chazapis
        self.conn = sqlite3.connect(db, check_same_thread=False)
41 7759260d Antony Chazapis
        self.conn.execute(""" pragma case_sensitive_like = on """)
42 2c5363a0 Antony Chazapis
    
43 d14fe290 Antony Chazapis
    def close(self):
44 d14fe290 Antony Chazapis
        self.conn.close()
45 d14fe290 Antony Chazapis
    
46 2c5363a0 Antony Chazapis
    def execute(self):
47 2c5363a0 Antony Chazapis
        self.conn.execute('begin deferred')
48 2c5363a0 Antony Chazapis
    
49 2c5363a0 Antony Chazapis
    def commit(self):
50 2c5363a0 Antony Chazapis
        self.conn.commit()
51 2c5363a0 Antony Chazapis
    
52 2c5363a0 Antony Chazapis
    def rollback(self):
53 2c5363a0 Antony Chazapis
        self.conn.rollback()