Statistics
| Branch: | Tag: | Revision:

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

History | View | Annotate | Download (2.7 kB)

1
# Copyright 2011 GRNET S.A. All rights reserved.
2
# 
3
# Redistribution and use in source and binary forms, with or
4
# without modification, are permitted provided that the following
5
# conditions are met:
6
# 
7
#   1. Redistributions of source code must retain the above
8
#      copyright notice, this list of conditions and the following
9
#      disclaimer.
10
# 
11
#   2. Redistributions in binary form must reproduce the above
12
#      copyright notice, this list of conditions and the following
13
#      disclaimer in the documentation and/or other materials
14
#      provided with the distribution.
15
# 
16
# THIS SOFTWARE IS PROVIDED BY GRNET S.A. ``AS IS'' AND ANY EXPRESS
17
# OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
18
# WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
19
# PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL GRNET S.A OR
20
# CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
21
# SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
22
# LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
23
# USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED
24
# AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
25
# LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
26
# ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
27
# POSSIBILITY OF SUCH DAMAGE.
28
# 
29
# The views and conclusions contained in the software and
30
# documentation are those of the authors and should not be
31
# interpreted as representing official policies, either expressed
32
# or implied, of GRNET S.A.
33

    
34
from dbworker import DBWorker
35

    
36

    
37
class Public(DBWorker):
38
    """Paths can be marked as public."""
39
    
40
    def __init__(self, **params):
41
        DBWorker.__init__(self, **params)
42
        execute = self.execute
43
        
44
        execute(""" create table if not exists public
45
                          ( public_id integer primary key autoincrement,
46
                            path      text ) """)
47
        execute(""" create unique index if not exists idx_public_path
48
                    on public(path) """)
49
    
50
    def public_set(self, path):
51
        q = "insert or ignore into public (path) values (?)"
52
        self.execute(q, (path,))
53
    
54
    def public_unset(self, path):
55
        q = "delete from public where path = ?"
56
        self.execute(q, (path,))
57
    
58
    def public_get(self, path):
59
        q = "select public_id from public where path = ?"
60
        self.execute(q, (path,))
61
        row = self.fetchone()
62
        if row:
63
            return row[0]
64
        return None
65
    
66
    def public_path(self, public):
67
        q = "select path from public where public_id = ?"
68
        self.execute(q, (public,))
69
        row = self.fetchone()
70
        if row:
71
            return row[0]
72
        return None