Statistics
| Branch: | Tag: | Revision:

root / snf-pithos-backend / pithos / backends / lib / sqlite / public.py @ 4a7b190f

History | View | Annotate | Download (4.2 kB)

1
# Copyright 2011-2012 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
from pithos.backends.random_word import get_random_word
37

    
38
import logging
39

    
40
logger = logging.getLogger(__name__)
41

    
42

    
43
class Public(DBWorker):
44
    """Paths can be marked as public."""
45

    
46
    def __init__(self, **params):
47
        DBWorker.__init__(self, **params)
48
        execute = self.execute
49

    
50
        execute(""" create table if not exists public
51
                          ( public_id integer primary key autoincrement,
52
                            path      text not null,
53
                            active    boolean not null default 1,
54
                            url       text) """)
55
        execute(""" create unique index if not exists idx_public_path
56
                    on public(path) """)
57
        execute(""" create unique index if not exists idx_public_url
58
                    on public(url) """)
59

    
60
    def get_unique_url(self, public_url_security, public_url_alphabet):
61
        l = public_url_security
62
        while 1:
63
            candidate = get_random_word(length=l, alphabet=public_url_alphabet)
64
            if self.public_path(candidate) is None:
65
                return candidate
66
            l += 1
67

    
68
    def public_set(self, path, public_url_security, public_url_alphabet):
69
        q = "select public_id from public where path = ?"
70
        self.execute(q, (path,))
71
        row = self.fetchone()
72

    
73
        if not row:
74
            url = self.get_unique_url(
75
                public_url_security, public_url_alphabet
76
            )
77
            q = "insert into public(path, active, url) values(?, 1, ?)"
78
            r = self.execute(q, (path, url))
79
            if r.rowcount != 0:
80
                logger.info('Public url set for path: %s' % path)
81

    
82
    def public_unset(self, path):
83
        q = "delete from public where path = ?"
84
        c = self.execute(q, (path,))
85
        if c.rowcount != 0:
86
            logger.info('Public url unset for path: %s' % path)
87

    
88
    def public_unset_bulk(self, paths):
89
        placeholders = ','.join('?' for path in paths)
90
        q = "delete from public where path in (%s)" % placeholders
91
        self.execute(q, paths)
92

    
93
    def public_get(self, path):
94
        q = "select url from public where path = ? and active = 1"
95
        self.execute(q, (path,))
96
        row = self.fetchone()
97
        if row:
98
            return row[0]
99
        return None
100

    
101
    def public_list(self, prefix):
102
        q = ("select path, url from public where "
103
             "path like ? escape '\\' and active = 1")
104
        self.execute(q, (self.escape_like(prefix) + '%',))
105
        return self.fetchall()
106

    
107
    def public_path(self, public):
108
        q = "select path from public where url = ? and active = 1"
109
        self.execute(q, (public,))
110
        row = self.fetchone()
111
        if row:
112
            return row[0]
113
        return None