Statistics
| Branch: | Tag: | Revision:

root / snf-pithos-backend / pithos / backends / lib / sqlalchemy / permissions.py @ 235a4227

History | View | Annotate | Download (6.7 kB)

1 2e662088 Antony Chazapis
# Copyright 2011-2012 GRNET S.A. All rights reserved.
2 2715ade4 Sofia Papagiannaki
#
3 4f917833 Sofia Papagiannaki
# Redistribution and use in source and binary forms, with or
4 4f917833 Sofia Papagiannaki
# without modification, are permitted provided that the following
5 4f917833 Sofia Papagiannaki
# conditions are met:
6 2715ade4 Sofia Papagiannaki
#
7 4f917833 Sofia Papagiannaki
#   1. Redistributions of source code must retain the above
8 4f917833 Sofia Papagiannaki
#      copyright notice, this list of conditions and the following
9 4f917833 Sofia Papagiannaki
#      disclaimer.
10 2715ade4 Sofia Papagiannaki
#
11 4f917833 Sofia Papagiannaki
#   2. Redistributions in binary form must reproduce the above
12 4f917833 Sofia Papagiannaki
#      copyright notice, this list of conditions and the following
13 4f917833 Sofia Papagiannaki
#      disclaimer in the documentation and/or other materials
14 4f917833 Sofia Papagiannaki
#      provided with the distribution.
15 2715ade4 Sofia Papagiannaki
#
16 4f917833 Sofia Papagiannaki
# THIS SOFTWARE IS PROVIDED BY GRNET S.A. ``AS IS'' AND ANY EXPRESS
17 4f917833 Sofia Papagiannaki
# OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
18 4f917833 Sofia Papagiannaki
# WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
19 4f917833 Sofia Papagiannaki
# PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL GRNET S.A OR
20 4f917833 Sofia Papagiannaki
# CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
21 4f917833 Sofia Papagiannaki
# SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
22 4f917833 Sofia Papagiannaki
# LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
23 4f917833 Sofia Papagiannaki
# USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED
24 4f917833 Sofia Papagiannaki
# AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
25 4f917833 Sofia Papagiannaki
# LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
26 4f917833 Sofia Papagiannaki
# ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
27 4f917833 Sofia Papagiannaki
# POSSIBILITY OF SUCH DAMAGE.
28 2715ade4 Sofia Papagiannaki
#
29 4f917833 Sofia Papagiannaki
# The views and conclusions contained in the software and
30 4f917833 Sofia Papagiannaki
# documentation are those of the authors and should not be
31 4f917833 Sofia Papagiannaki
# interpreted as representing official policies, either expressed
32 4f917833 Sofia Papagiannaki
# or implied, of GRNET S.A.
33 4f917833 Sofia Papagiannaki
34 4f917833 Sofia Papagiannaki
from sqlalchemy.sql import select, literal
35 4f1bc0a6 Sofia Papagiannaki
from sqlalchemy.sql.expression import join, union
36 4f917833 Sofia Papagiannaki
37 4f917833 Sofia Papagiannaki
from xfeatures import XFeatures
38 4f917833 Sofia Papagiannaki
from groups import Groups
39 4f917833 Sofia Papagiannaki
from public import Public
40 4f917833 Sofia Papagiannaki
41 235a4227 Sofia Papagiannaki
from dbworker import ESCAPE_CHAR
42 235a4227 Sofia Papagiannaki
43 4f917833 Sofia Papagiannaki
44 4f917833 Sofia Papagiannaki
READ = 0
45 4f917833 Sofia Papagiannaki
WRITE = 1
46 4f917833 Sofia Papagiannaki
47 4f917833 Sofia Papagiannaki
48 4f917833 Sofia Papagiannaki
class Permissions(XFeatures, Groups, Public):
49 2715ade4 Sofia Papagiannaki
50 4f917833 Sofia Papagiannaki
    def __init__(self, **params):
51 4f917833 Sofia Papagiannaki
        XFeatures.__init__(self, **params)
52 4f917833 Sofia Papagiannaki
        Groups.__init__(self, **params)
53 4f917833 Sofia Papagiannaki
        Public.__init__(self, **params)
54 2715ade4 Sofia Papagiannaki
55 4f917833 Sofia Papagiannaki
    def access_grant(self, path, access, members=()):
56 4f917833 Sofia Papagiannaki
        """Grant members with access to path.
57 4f917833 Sofia Papagiannaki
           Members can also be '*' (all),
58 4f917833 Sofia Papagiannaki
           or some group specified as 'owner:group'."""
59 2715ade4 Sofia Papagiannaki
60 4f917833 Sofia Papagiannaki
        if not members:
61 4f917833 Sofia Papagiannaki
            return
62 4f917833 Sofia Papagiannaki
        feature = self.xfeature_create(path)
63 4f917833 Sofia Papagiannaki
        self.feature_setmany(feature, access, members)
64 2715ade4 Sofia Papagiannaki
65 4f917833 Sofia Papagiannaki
    def access_set(self, path, permissions):
66 4f917833 Sofia Papagiannaki
        """Set permissions for path. The permissions dict
67 4f917833 Sofia Papagiannaki
           maps 'read', 'write' keys to member lists."""
68 2715ade4 Sofia Papagiannaki
69 cf341da4 Antony Chazapis
        r = permissions.get('read', [])
70 cf341da4 Antony Chazapis
        w = permissions.get('write', [])
71 cf341da4 Antony Chazapis
        if not r and not w:
72 cf341da4 Antony Chazapis
            self.xfeature_destroy(path)
73 cf341da4 Antony Chazapis
            return
74 cf341da4 Antony Chazapis
        feature = self.xfeature_create(path)
75 345dcf39 Antony Chazapis
        self.feature_clear(feature, READ)
76 345dcf39 Antony Chazapis
        self.feature_clear(feature, WRITE)
77 cf341da4 Antony Chazapis
        if r:
78 cf341da4 Antony Chazapis
            self.feature_setmany(feature, READ, r)
79 cf341da4 Antony Chazapis
        if w:
80 cf341da4 Antony Chazapis
            self.feature_setmany(feature, WRITE, w)
81 2715ade4 Sofia Papagiannaki
82 cf341da4 Antony Chazapis
    def access_get(self, path):
83 cf341da4 Antony Chazapis
        """Get permissions for path."""
84 2715ade4 Sofia Papagiannaki
85 cf341da4 Antony Chazapis
        feature = self.xfeature_get(path)
86 cf341da4 Antony Chazapis
        if not feature:
87 cf341da4 Antony Chazapis
            return {}
88 cf341da4 Antony Chazapis
        permissions = self.feature_dict(feature)
89 cf341da4 Antony Chazapis
        if READ in permissions:
90 cf341da4 Antony Chazapis
            permissions['read'] = permissions[READ]
91 cf341da4 Antony Chazapis
            del(permissions[READ])
92 cf341da4 Antony Chazapis
        if WRITE in permissions:
93 cf341da4 Antony Chazapis
            permissions['write'] = permissions[WRITE]
94 cf341da4 Antony Chazapis
            del(permissions[WRITE])
95 cf341da4 Antony Chazapis
        return permissions
96 2715ade4 Sofia Papagiannaki
97 a74ba506 Sofia Papagiannaki
    def access_members(self, path):
98 a74ba506 Sofia Papagiannaki
        feature = self.xfeature_get(path)
99 a74ba506 Sofia Papagiannaki
        if not feature:
100 a74ba506 Sofia Papagiannaki
            return []
101 a74ba506 Sofia Papagiannaki
        permissions = self.feature_dict(feature)
102 a74ba506 Sofia Papagiannaki
        members = set()
103 a74ba506 Sofia Papagiannaki
        members.update(permissions.get(READ, []))
104 a74ba506 Sofia Papagiannaki
        members.update(permissions.get(WRITE, []))
105 a74ba506 Sofia Papagiannaki
        for m in set(members):
106 a74ba506 Sofia Papagiannaki
            parts = m.split(':', 1)
107 a74ba506 Sofia Papagiannaki
            if len(parts) != 2:
108 a74ba506 Sofia Papagiannaki
                continue
109 a74ba506 Sofia Papagiannaki
            user, group = parts
110 a74ba506 Sofia Papagiannaki
            members.remove(m)
111 a74ba506 Sofia Papagiannaki
            members.update(self.group_members(user, group))
112 a74ba506 Sofia Papagiannaki
        return list(members)
113 2715ade4 Sofia Papagiannaki
114 4f917833 Sofia Papagiannaki
    def access_clear(self, path):
115 4f917833 Sofia Papagiannaki
        """Revoke access to path (both permissions and public)."""
116 2715ade4 Sofia Papagiannaki
117 4f917833 Sofia Papagiannaki
        self.xfeature_destroy(path)
118 4f917833 Sofia Papagiannaki
        self.public_unset(path)
119 2715ade4 Sofia Papagiannaki
120 8221c89d Sofia Papagiannaki
    def access_clear_bulk(self, paths):
121 8221c89d Sofia Papagiannaki
        """Revoke access to path (both permissions and public)."""
122 2715ade4 Sofia Papagiannaki
123 8221c89d Sofia Papagiannaki
        self.xfeature_destroy_bulk(paths)
124 8221c89d Sofia Papagiannaki
        self.public_unset_bulk(paths)
125 2715ade4 Sofia Papagiannaki
126 4f917833 Sofia Papagiannaki
    def access_check(self, path, access, member):
127 4f917833 Sofia Papagiannaki
        """Return true if the member has this access to the path."""
128 2715ade4 Sofia Papagiannaki
129 cf341da4 Antony Chazapis
        feature = self.xfeature_get(path)
130 cf341da4 Antony Chazapis
        if not feature:
131 4f917833 Sofia Papagiannaki
            return False
132 4f917833 Sofia Papagiannaki
        members = self.feature_get(feature, access)
133 4f917833 Sofia Papagiannaki
        if member in members or '*' in members:
134 4f917833 Sofia Papagiannaki
            return True
135 4f917833 Sofia Papagiannaki
        for owner, group in self.group_parents(member):
136 4f917833 Sofia Papagiannaki
            if owner + ':' + group in members:
137 4f917833 Sofia Papagiannaki
                return True
138 4f917833 Sofia Papagiannaki
        return False
139 2715ade4 Sofia Papagiannaki
140 4f917833 Sofia Papagiannaki
    def access_inherit(self, path):
141 cf341da4 Antony Chazapis
        """Return the paths influencing the access for path."""
142 2715ade4 Sofia Papagiannaki
143 d83c93c9 Antony Chazapis
#         r = self.xfeature_inherit(path)
144 d83c93c9 Antony Chazapis
#         if not r:
145 d83c93c9 Antony Chazapis
#             return []
146 d83c93c9 Antony Chazapis
#         # Compute valid.
147 d83c93c9 Antony Chazapis
#         return [x[0] for x in r if x[0] in valid]
148 2715ade4 Sofia Papagiannaki
149 cf341da4 Antony Chazapis
        # Only keep path components.
150 cf341da4 Antony Chazapis
        parts = path.rstrip('/').split('/')
151 cf341da4 Antony Chazapis
        valid = []
152 cf341da4 Antony Chazapis
        for i in range(1, len(parts)):
153 cf341da4 Antony Chazapis
            subp = '/'.join(parts[:i + 1])
154 cf341da4 Antony Chazapis
            valid.append(subp)
155 d83c93c9 Antony Chazapis
            if subp != path:
156 d83c93c9 Antony Chazapis
                valid.append(subp + '/')
157 d83c93c9 Antony Chazapis
        return [x for x in valid if self.xfeature_get(x)]
158 2715ade4 Sofia Papagiannaki
159 4f917833 Sofia Papagiannaki
    def access_list_paths(self, member, prefix=None):
160 4f917833 Sofia Papagiannaki
        """Return the list of paths granted to member."""
161 2715ade4 Sofia Papagiannaki
162 2715ade4 Sofia Papagiannaki
        xfeatures_xfeaturevals = self.xfeatures.join(self.xfeaturevals)
163 2715ade4 Sofia Papagiannaki
164 4f917833 Sofia Papagiannaki
        selectable = (self.groups.c.owner + ':' + self.groups.c.name)
165 4f917833 Sofia Papagiannaki
        member_groups = select([selectable.label('value')],
166 2715ade4 Sofia Papagiannaki
                               self.groups.c.member == member)
167 2715ade4 Sofia Papagiannaki
168 4f917833 Sofia Papagiannaki
        members = select([literal(member).label('value')])
169 f992aa60 Sofia Papagiannaki
        any = select([literal('*').label('value')])
170 2715ade4 Sofia Papagiannaki
171 fe232f24 Sofia Papagiannaki
        u = union(member_groups, members, any).alias()
172 4f1bc0a6 Sofia Papagiannaki
        inner_join = join(xfeatures_xfeaturevals, u,
173 2715ade4 Sofia Papagiannaki
                          self.xfeaturevals.c.value == u.c.value)
174 4f917833 Sofia Papagiannaki
        s = select([self.xfeatures.c.path], from_obj=[inner_join]).distinct()
175 4f917833 Sofia Papagiannaki
        if prefix:
176 2715ade4 Sofia Papagiannaki
            s = s.where(self.xfeatures.c.path.like(
177 235a4227 Sofia Papagiannaki
                self.escape_like(prefix) + '%', escape=ESCAPE_CHAR
178 235a4227 Sofia Papagiannaki
            ))
179 4f917833 Sofia Papagiannaki
        r = self.conn.execute(s)
180 4f917833 Sofia Papagiannaki
        l = [row[0] for row in r.fetchall()]
181 4f917833 Sofia Papagiannaki
        r.close()
182 4f917833 Sofia Papagiannaki
        return l
183 2715ade4 Sofia Papagiannaki
184 4f917833 Sofia Papagiannaki
    def access_list_shared(self, prefix=''):
185 4f917833 Sofia Papagiannaki
        """Return the list of shared paths."""
186 2715ade4 Sofia Papagiannaki
187 4f917833 Sofia Papagiannaki
        s = select([self.xfeatures.c.path],
188 235a4227 Sofia Papagiannaki
                   self.xfeatures.c.path.like(self.escape_like(prefix) + '%',
189 235a4227 Sofia Papagiannaki
                                              escape=ESCAPE_CHAR
190 235a4227 Sofia Papagiannaki
                   )
191 235a4227 Sofia Papagiannaki
        ).order_by(self.xfeatures.c.path.asc())
192 4f917833 Sofia Papagiannaki
        r = self.conn.execute(s)
193 4f917833 Sofia Papagiannaki
        l = [row[0] for row in r.fetchall()]
194 4f917833 Sofia Papagiannaki
        r.close()
195 937dc831 Antony Chazapis
        return l