Statistics
| Branch: | Tag: | Revision:

root / snf-astakos-app / astakos / im / quotas.py @ 9cd9bfe7

History | View | Annotate | Download (10 kB)

1 dc9da5b9 Giorgos Korfiatis
# Copyright 2013 GRNET S.A. All rights reserved.
2 dc9da5b9 Giorgos Korfiatis
#
3 dc9da5b9 Giorgos Korfiatis
# Redistribution and use in source and binary forms, with or
4 dc9da5b9 Giorgos Korfiatis
# without modification, are permitted provided that the following
5 dc9da5b9 Giorgos Korfiatis
# conditions are met:
6 dc9da5b9 Giorgos Korfiatis
#
7 dc9da5b9 Giorgos Korfiatis
#   1. Redistributions of source code must retain the above
8 dc9da5b9 Giorgos Korfiatis
#      copyright notice, this list of conditions and the following
9 dc9da5b9 Giorgos Korfiatis
#      disclaimer.
10 dc9da5b9 Giorgos Korfiatis
#
11 dc9da5b9 Giorgos Korfiatis
#   2. Redistributions in binary form must reproduce the above
12 dc9da5b9 Giorgos Korfiatis
#      copyright notice, this list of conditions and the following
13 dc9da5b9 Giorgos Korfiatis
#      disclaimer in the documentation and/or other materials
14 dc9da5b9 Giorgos Korfiatis
#      provided with the distribution.
15 dc9da5b9 Giorgos Korfiatis
#
16 dc9da5b9 Giorgos Korfiatis
# THIS SOFTWARE IS PROVIDED BY GRNET S.A. ``AS IS'' AND ANY EXPRESS
17 dc9da5b9 Giorgos Korfiatis
# OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
18 dc9da5b9 Giorgos Korfiatis
# WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
19 dc9da5b9 Giorgos Korfiatis
# PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL GRNET S.A OR
20 dc9da5b9 Giorgos Korfiatis
# CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
21 dc9da5b9 Giorgos Korfiatis
# SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
22 dc9da5b9 Giorgos Korfiatis
# LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
23 dc9da5b9 Giorgos Korfiatis
# USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED
24 dc9da5b9 Giorgos Korfiatis
# AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
25 dc9da5b9 Giorgos Korfiatis
# LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
26 dc9da5b9 Giorgos Korfiatis
# ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
27 dc9da5b9 Giorgos Korfiatis
# POSSIBILITY OF SUCH DAMAGE.
28 dc9da5b9 Giorgos Korfiatis
#
29 dc9da5b9 Giorgos Korfiatis
# The views and conclusions contained in the software and
30 dc9da5b9 Giorgos Korfiatis
# documentation are those of the authors and should not be
31 dc9da5b9 Giorgos Korfiatis
# interpreted as representing official policies, either expressed
32 dc9da5b9 Giorgos Korfiatis
# or implied, of GRNET S.A.
33 dc9da5b9 Giorgos Korfiatis
34 2e7924de Giorgos Korfiatis
import copy
35 aa27f246 Giorgos Korfiatis
from astakos.im.models import (
36 aa27f246 Giorgos Korfiatis
    Resource, AstakosUserQuota, AstakosUser,
37 aa27f246 Giorgos Korfiatis
    Project, ProjectMembership, ProjectResourceGrant, ProjectApplication)
38 ec5e00aa Giorgos Korfiatis
import astakos.quotaholder_app.callpoint as qh
39 2e7924de Giorgos Korfiatis
from astakos.quotaholder_app.exception import NoCapacityError
40 ae16bcad Giorgos Korfiatis
from django.db.models import Q
41 dc9da5b9 Giorgos Korfiatis
42 dc9da5b9 Giorgos Korfiatis
43 dc9da5b9 Giorgos Korfiatis
def from_holding(holding):
44 68b991bc Giorgos Korfiatis
    limit, usage_min, usage_max = holding
45 dc9da5b9 Giorgos Korfiatis
    body = {'limit':       limit,
46 68b991bc Giorgos Korfiatis
            'usage':       usage_max,
47 68b991bc Giorgos Korfiatis
            'pending':     usage_max-usage_min,
48 dc9da5b9 Giorgos Korfiatis
            }
49 dc9da5b9 Giorgos Korfiatis
    return body
50 dc9da5b9 Giorgos Korfiatis
51 dc9da5b9 Giorgos Korfiatis
52 dc9da5b9 Giorgos Korfiatis
def limits_only(holding):
53 68b991bc Giorgos Korfiatis
    limit, usage_min, usage_max = holding
54 dc9da5b9 Giorgos Korfiatis
    return limit
55 dc9da5b9 Giorgos Korfiatis
56 dc9da5b9 Giorgos Korfiatis
57 dc9da5b9 Giorgos Korfiatis
def transform_data(holdings, func=None):
58 dc9da5b9 Giorgos Korfiatis
    if func is None:
59 dc9da5b9 Giorgos Korfiatis
        func = from_holding
60 dc9da5b9 Giorgos Korfiatis
61 dc9da5b9 Giorgos Korfiatis
    quota = {}
62 dc9da5b9 Giorgos Korfiatis
    for (holder, source, resource), value in holdings.iteritems():
63 dc9da5b9 Giorgos Korfiatis
        holder_quota = quota.get(holder, {})
64 dc9da5b9 Giorgos Korfiatis
        source_quota = holder_quota.get(source, {})
65 dc9da5b9 Giorgos Korfiatis
        body = func(value)
66 dc9da5b9 Giorgos Korfiatis
        source_quota[resource] = body
67 dc9da5b9 Giorgos Korfiatis
        holder_quota[source] = source_quota
68 dc9da5b9 Giorgos Korfiatis
        quota[holder] = holder_quota
69 dc9da5b9 Giorgos Korfiatis
    return quota
70 dc9da5b9 Giorgos Korfiatis
71 dc9da5b9 Giorgos Korfiatis
72 5afce44d Giorgos Korfiatis
def get_counters(users, resources=None, sources=None):
73 dc9da5b9 Giorgos Korfiatis
    uuids = [user.uuid for user in users]
74 dc9da5b9 Giorgos Korfiatis
75 5afce44d Giorgos Korfiatis
    counters = qh.get_quota(holders=uuids,
76 5afce44d Giorgos Korfiatis
                            resources=resources,
77 5afce44d Giorgos Korfiatis
                            sources=sources)
78 dc9da5b9 Giorgos Korfiatis
    return counters
79 dc9da5b9 Giorgos Korfiatis
80 dc9da5b9 Giorgos Korfiatis
81 dc9da5b9 Giorgos Korfiatis
def get_users_quotas(users, resources=None, sources=None):
82 dc9da5b9 Giorgos Korfiatis
    counters = get_counters(users, resources, sources)
83 dc9da5b9 Giorgos Korfiatis
    quotas = transform_data(counters)
84 dc9da5b9 Giorgos Korfiatis
    return quotas
85 dc9da5b9 Giorgos Korfiatis
86 dc9da5b9 Giorgos Korfiatis
87 e336910f Giorgos Korfiatis
def get_users_quota_limits(users, resources=None, sources=None):
88 dc9da5b9 Giorgos Korfiatis
    counters = get_counters(users, resources, sources)
89 dc9da5b9 Giorgos Korfiatis
    limits = transform_data(counters, limits_only)
90 e336910f Giorgos Korfiatis
    return limits
91 dc9da5b9 Giorgos Korfiatis
92 dc9da5b9 Giorgos Korfiatis
93 dc9da5b9 Giorgos Korfiatis
def get_user_quotas(user, resources=None, sources=None):
94 dc9da5b9 Giorgos Korfiatis
    quotas = get_users_quotas([user], resources, sources)
95 1e361a6d Giorgos Korfiatis
    return quotas.get(user.uuid, {})
96 dc9da5b9 Giorgos Korfiatis
97 dc9da5b9 Giorgos Korfiatis
98 271d2c4c Giorgos Korfiatis
def service_get_quotas(service, users=None):
99 a0b34382 Giorgos Korfiatis
    resources = Resource.objects.filter(service=service)
100 bb005bc2 Giorgos Korfiatis
    resource_names = [r.name for r in resources]
101 5afce44d Giorgos Korfiatis
    counters = qh.get_quota(holders=users, resources=resource_names)
102 bb005bc2 Giorgos Korfiatis
    return transform_data(counters)
103 bb005bc2 Giorgos Korfiatis
104 bb005bc2 Giorgos Korfiatis
105 9b126f13 Giorgos Korfiatis
def _level_quota_dict(quotas):
106 9b126f13 Giorgos Korfiatis
    lst = []
107 9b126f13 Giorgos Korfiatis
    for holder, holder_quota in quotas.iteritems():
108 9b126f13 Giorgos Korfiatis
        for source, source_quota in holder_quota.iteritems():
109 9b126f13 Giorgos Korfiatis
            for resource, limit in source_quota.iteritems():
110 9b126f13 Giorgos Korfiatis
                key = (holder, source, resource)
111 9b126f13 Giorgos Korfiatis
                lst.append((key, limit))
112 9b126f13 Giorgos Korfiatis
    return lst
113 9b126f13 Giorgos Korfiatis
114 9b126f13 Giorgos Korfiatis
115 e336910f Giorgos Korfiatis
def _set_user_quota(quotas):
116 9b126f13 Giorgos Korfiatis
    q = _level_quota_dict(quotas)
117 9b126f13 Giorgos Korfiatis
    qh.set_quota(q)
118 aa27f246 Giorgos Korfiatis
119 aa27f246 Giorgos Korfiatis
120 aa27f246 Giorgos Korfiatis
def get_default_quota():
121 aa27f246 Giorgos Korfiatis
    _DEFAULT_QUOTA = {}
122 aa27f246 Giorgos Korfiatis
    resources = Resource.objects.select_related('service').all()
123 aa27f246 Giorgos Korfiatis
    for resource in resources:
124 aa27f246 Giorgos Korfiatis
        capacity = resource.uplimit
125 aa27f246 Giorgos Korfiatis
        _DEFAULT_QUOTA[resource.full_name()] = capacity
126 aa27f246 Giorgos Korfiatis
127 aa27f246 Giorgos Korfiatis
    return _DEFAULT_QUOTA
128 aa27f246 Giorgos Korfiatis
129 aa27f246 Giorgos Korfiatis
130 aa27f246 Giorgos Korfiatis
SYSTEM = 'system'
131 3c22bad0 Giorgos Korfiatis
PENDING_APP_RESOURCE = 'astakos.pending_app'
132 aa27f246 Giorgos Korfiatis
133 aa27f246 Giorgos Korfiatis
134 3c22bad0 Giorgos Korfiatis
def register_pending_apps(user, quantity, force=False):
135 3c22bad0 Giorgos Korfiatis
    provision = (user.uuid, SYSTEM, PENDING_APP_RESOURCE), quantity
136 9e3af524 Giorgos Korfiatis
    try:
137 9e3af524 Giorgos Korfiatis
        s = qh.issue_commission(clientkey='astakos',
138 9e3af524 Giorgos Korfiatis
                                force=force,
139 9e3af524 Giorgos Korfiatis
                                provisions=[provision])
140 9e3af524 Giorgos Korfiatis
    except NoCapacityError as e:
141 9e3af524 Giorgos Korfiatis
        limit = e.data['limit']
142 9e3af524 Giorgos Korfiatis
        return False, limit
143 3c22bad0 Giorgos Korfiatis
    qh.resolve_pending_commission('astakos', s)
144 9e3af524 Giorgos Korfiatis
    return True, None
145 9770ba6c Giorgos Korfiatis
146 9770ba6c Giorgos Korfiatis
147 3c22bad0 Giorgos Korfiatis
def get_pending_app_quota(user):
148 3c22bad0 Giorgos Korfiatis
    quota = get_user_quotas(user)
149 3c22bad0 Giorgos Korfiatis
    return quota[SYSTEM][PENDING_APP_RESOURCE]
150 3c22bad0 Giorgos Korfiatis
151 3c22bad0 Giorgos Korfiatis
152 764d99c4 Giorgos Korfiatis
def add_base_quota(user, resource, capacity):
153 764d99c4 Giorgos Korfiatis
    resource = Resource.objects.get(name=resource)
154 3c22bad0 Giorgos Korfiatis
    user = get_user_for_update(user.id)
155 764d99c4 Giorgos Korfiatis
    obj, created = AstakosUserQuota.objects.get_or_create(
156 764d99c4 Giorgos Korfiatis
        user=user, resource=resource, defaults={
157 764d99c4 Giorgos Korfiatis
            'capacity': capacity,
158 764d99c4 Giorgos Korfiatis
        })
159 764d99c4 Giorgos Korfiatis
160 764d99c4 Giorgos Korfiatis
    if not created:
161 764d99c4 Giorgos Korfiatis
        obj.capacity = capacity
162 764d99c4 Giorgos Korfiatis
        obj.save()
163 3c22bad0 Giorgos Korfiatis
    qh_sync_locked_user(user)
164 764d99c4 Giorgos Korfiatis
165 764d99c4 Giorgos Korfiatis
166 764d99c4 Giorgos Korfiatis
def remove_base_quota(user, resource):
167 3c22bad0 Giorgos Korfiatis
    user = get_user_for_update(user.id)
168 764d99c4 Giorgos Korfiatis
    AstakosUserQuota.objects.filter(
169 764d99c4 Giorgos Korfiatis
        user=user, resource__name=resource).delete()
170 3c22bad0 Giorgos Korfiatis
    qh_sync_locked_user(user)
171 764d99c4 Giorgos Korfiatis
172 764d99c4 Giorgos Korfiatis
173 aa27f246 Giorgos Korfiatis
def initial_quotas(users):
174 103086a4 Giorgos Korfiatis
    users = list(users)
175 aa27f246 Giorgos Korfiatis
    initial = {}
176 aa27f246 Giorgos Korfiatis
    default_quotas = get_default_quota()
177 aa27f246 Giorgos Korfiatis
178 aa27f246 Giorgos Korfiatis
    for user in users:
179 aa27f246 Giorgos Korfiatis
        uuid = user.uuid
180 aa27f246 Giorgos Korfiatis
        source_quota = {SYSTEM: dict(default_quotas)}
181 aa27f246 Giorgos Korfiatis
        initial[uuid] = source_quota
182 aa27f246 Giorgos Korfiatis
183 aa27f246 Giorgos Korfiatis
    objs = AstakosUserQuota.objects.select_related()
184 aa27f246 Giorgos Korfiatis
    orig_quotas = objs.filter(user__in=users)
185 aa27f246 Giorgos Korfiatis
    for user_quota in orig_quotas:
186 aa27f246 Giorgos Korfiatis
        uuid = user_quota.user.uuid
187 aa27f246 Giorgos Korfiatis
        user_init = initial.get(uuid, {})
188 003909e3 Giorgos Korfiatis
        source_quota = user_init.get(SYSTEM, {})
189 aa27f246 Giorgos Korfiatis
        resource = user_quota.resource.full_name()
190 003909e3 Giorgos Korfiatis
        source_quota[resource] = user_quota.capacity
191 003909e3 Giorgos Korfiatis
        user_init[SYSTEM] = source_quota
192 aa27f246 Giorgos Korfiatis
        initial[uuid] = user_init
193 aa27f246 Giorgos Korfiatis
194 aa27f246 Giorgos Korfiatis
    return initial
195 aa27f246 Giorgos Korfiatis
196 aa27f246 Giorgos Korfiatis
197 aa27f246 Giorgos Korfiatis
def get_grant_source(grant):
198 aa27f246 Giorgos Korfiatis
    return SYSTEM
199 aa27f246 Giorgos Korfiatis
200 aa27f246 Giorgos Korfiatis
201 cb14cc6c Giorgos Korfiatis
def astakos_users_quotas(users, initial=None):
202 103086a4 Giorgos Korfiatis
    users = list(users)
203 aa27f246 Giorgos Korfiatis
    if initial is None:
204 aa27f246 Giorgos Korfiatis
        quotas = initial_quotas(users)
205 aa27f246 Giorgos Korfiatis
    else:
206 aa27f246 Giorgos Korfiatis
        quotas = copy.deepcopy(initial)
207 aa27f246 Giorgos Korfiatis
208 aa27f246 Giorgos Korfiatis
    ACTUALLY_ACCEPTED = ProjectMembership.ACTUALLY_ACCEPTED
209 aa27f246 Giorgos Korfiatis
    objs = ProjectMembership.objects.select_related('project', 'person')
210 aa27f246 Giorgos Korfiatis
    memberships = objs.filter(person__in=users,
211 aa27f246 Giorgos Korfiatis
                              state__in=ACTUALLY_ACCEPTED,
212 aa27f246 Giorgos Korfiatis
                              project__state=Project.APPROVED)
213 aa27f246 Giorgos Korfiatis
214 aa27f246 Giorgos Korfiatis
    project_ids = set(m.project_id for m in memberships)
215 aa27f246 Giorgos Korfiatis
    objs = ProjectApplication.objects.select_related('project')
216 aa27f246 Giorgos Korfiatis
    apps = objs.filter(project__in=project_ids)
217 aa27f246 Giorgos Korfiatis
218 aa27f246 Giorgos Korfiatis
    project_dict = {}
219 aa27f246 Giorgos Korfiatis
    for app in apps:
220 aa27f246 Giorgos Korfiatis
        project_dict[app.project] = app
221 aa27f246 Giorgos Korfiatis
222 aa27f246 Giorgos Korfiatis
    objs = ProjectResourceGrant.objects.select_related()
223 aa27f246 Giorgos Korfiatis
    grants = objs.filter(project_application__in=apps)
224 aa27f246 Giorgos Korfiatis
225 aa27f246 Giorgos Korfiatis
    for membership in memberships:
226 aa27f246 Giorgos Korfiatis
        uuid = membership.person.uuid
227 aa27f246 Giorgos Korfiatis
        userquotas = quotas.get(uuid, {})
228 aa27f246 Giorgos Korfiatis
229 aa27f246 Giorgos Korfiatis
        application = project_dict[membership.project]
230 aa27f246 Giorgos Korfiatis
231 aa27f246 Giorgos Korfiatis
        for grant in grants:
232 aa27f246 Giorgos Korfiatis
            if grant.project_application_id != application.id:
233 aa27f246 Giorgos Korfiatis
                continue
234 aa27f246 Giorgos Korfiatis
235 aa27f246 Giorgos Korfiatis
            source = get_grant_source(grant)
236 aa27f246 Giorgos Korfiatis
            source_quotas = userquotas.get(source, {})
237 aa27f246 Giorgos Korfiatis
238 aa27f246 Giorgos Korfiatis
            resource = grant.resource.full_name()
239 aa27f246 Giorgos Korfiatis
            prev = source_quotas.get(resource, 0)
240 aa27f246 Giorgos Korfiatis
            new = prev + grant.member_capacity
241 aa27f246 Giorgos Korfiatis
            source_quotas[resource] = new
242 aa27f246 Giorgos Korfiatis
            userquotas[source] = source_quotas
243 aa27f246 Giorgos Korfiatis
        quotas[uuid] = userquotas
244 aa27f246 Giorgos Korfiatis
245 aa27f246 Giorgos Korfiatis
    return quotas
246 aa27f246 Giorgos Korfiatis
247 aa27f246 Giorgos Korfiatis
248 3adbd562 Giorgos Korfiatis
def list_user_quotas(users):
249 e336910f Giorgos Korfiatis
    qh_quotas = get_users_quotas(users)
250 3adbd562 Giorgos Korfiatis
    astakos_initial = initial_quotas(users)
251 e336910f Giorgos Korfiatis
    return qh_quotas, astakos_initial
252 e336910f Giorgos Korfiatis
253 e336910f Giorgos Korfiatis
254 e336910f Giorgos Korfiatis
# Syncing to quotaholder
255 e336910f Giorgos Korfiatis
256 3c22bad0 Giorgos Korfiatis
def get_users_for_update(user_ids):
257 3c22bad0 Giorgos Korfiatis
    uids = sorted(user_ids)
258 3c22bad0 Giorgos Korfiatis
    objs = AstakosUser.forupdate
259 3c22bad0 Giorgos Korfiatis
    return list(objs.filter(id__in=uids).order_by('id').select_for_update())
260 3c22bad0 Giorgos Korfiatis
261 3c22bad0 Giorgos Korfiatis
262 3c22bad0 Giorgos Korfiatis
def get_user_for_update(user_id):
263 3c22bad0 Giorgos Korfiatis
    return get_users_for_update([user_id])[0]
264 3c22bad0 Giorgos Korfiatis
265 3c22bad0 Giorgos Korfiatis
266 3c22bad0 Giorgos Korfiatis
def qh_sync_locked_users(users):
267 3c22bad0 Giorgos Korfiatis
    astakos_quotas = astakos_users_quotas(users)
268 3c22bad0 Giorgos Korfiatis
    _set_user_quota(astakos_quotas)
269 3c22bad0 Giorgos Korfiatis
270 3c22bad0 Giorgos Korfiatis
271 3c22bad0 Giorgos Korfiatis
def qh_sync_users(users):
272 3c22bad0 Giorgos Korfiatis
    uids = [user.id for user in users]
273 3c22bad0 Giorgos Korfiatis
    users = get_users_for_update(uids)
274 3c22bad0 Giorgos Korfiatis
    qh_sync_locked_users(users)
275 3c22bad0 Giorgos Korfiatis
276 3c22bad0 Giorgos Korfiatis
277 3c22bad0 Giorgos Korfiatis
def qh_sync_users_diffs(users, sync=True):
278 e336910f Giorgos Korfiatis
    uids = [user.id for user in users]
279 e336910f Giorgos Korfiatis
    if sync:
280 3c22bad0 Giorgos Korfiatis
        users = get_users_for_update(uids)
281 e336910f Giorgos Korfiatis
282 cb14cc6c Giorgos Korfiatis
    astakos_quotas = astakos_users_quotas(users)
283 3c22bad0 Giorgos Korfiatis
    qh_limits = get_users_quota_limits(users)
284 3c22bad0 Giorgos Korfiatis
    diff_quotas = {}
285 3c22bad0 Giorgos Korfiatis
    for holder, local in astakos_quotas.iteritems():
286 3c22bad0 Giorgos Korfiatis
        registered = qh_limits.get(holder, None)
287 3c22bad0 Giorgos Korfiatis
        if local != registered:
288 3c22bad0 Giorgos Korfiatis
            diff_quotas[holder] = dict(local)
289 3c22bad0 Giorgos Korfiatis
290 3c22bad0 Giorgos Korfiatis
    if sync:
291 3c22bad0 Giorgos Korfiatis
        _set_user_quota(diff_quotas)
292 3c22bad0 Giorgos Korfiatis
    return qh_limits, diff_quotas
293 3adbd562 Giorgos Korfiatis
294 3c22bad0 Giorgos Korfiatis
295 3c22bad0 Giorgos Korfiatis
def qh_sync_locked_user(user):
296 3c22bad0 Giorgos Korfiatis
    qh_sync_locked_users([user])
297 3adbd562 Giorgos Korfiatis
298 e336910f Giorgos Korfiatis
299 e336910f Giorgos Korfiatis
def qh_sync_user(user):
300 e336910f Giorgos Korfiatis
    qh_sync_users([user])
301 e336910f Giorgos Korfiatis
302 e336910f Giorgos Korfiatis
303 3c22bad0 Giorgos Korfiatis
def members_to_sync(project):
304 3c22bad0 Giorgos Korfiatis
    objs = ProjectMembership.objects.select_related('person')
305 3c22bad0 Giorgos Korfiatis
    memberships = objs.filter(project=project,
306 3c22bad0 Giorgos Korfiatis
                              state__in=ProjectMembership.ACTUALLY_ACCEPTED)
307 3c22bad0 Giorgos Korfiatis
    return set(m.person for m in memberships)
308 e336910f Giorgos Korfiatis
309 e336910f Giorgos Korfiatis
310 e336910f Giorgos Korfiatis
def qh_sync_project(project):
311 3c22bad0 Giorgos Korfiatis
    users = members_to_sync(project)
312 3c22bad0 Giorgos Korfiatis
    qh_sync_users(users)
313 9747707e Giorgos Korfiatis
314 9747707e Giorgos Korfiatis
315 9747707e Giorgos Korfiatis
def qh_add_resource_limit(resource, diff):
316 ae16bcad Giorgos Korfiatis
    objs = AstakosUser.forupdate.filter(Q(email_verified=True) &
317 ae16bcad Giorgos Korfiatis
                                        ~Q(policy=resource))
318 3c22bad0 Giorgos Korfiatis
    users = objs.order_by('id').select_for_update()
319 ae16bcad Giorgos Korfiatis
    uuids = [u.uuid for u in users]
320 ae16bcad Giorgos Korfiatis
    qh.add_resource_limit(holders=uuids, sources=[SYSTEM],
321 ae16bcad Giorgos Korfiatis
                          resources=[resource.name], diff=diff)
322 9747707e Giorgos Korfiatis
323 9747707e Giorgos Korfiatis
324 9747707e Giorgos Korfiatis
def qh_sync_new_resource(resource, limit):
325 9747707e Giorgos Korfiatis
    users = AstakosUser.forupdate.filter(
326 3c22bad0 Giorgos Korfiatis
        email_verified=True).order_by('id').select_for_update()
327 9747707e Giorgos Korfiatis
328 ae16bcad Giorgos Korfiatis
    resource_name = resource.name
329 9747707e Giorgos Korfiatis
    data = []
330 9747707e Giorgos Korfiatis
    for user in users:
331 9747707e Giorgos Korfiatis
        uuid = user.uuid
332 ae16bcad Giorgos Korfiatis
        key = uuid, SYSTEM, resource_name
333 9747707e Giorgos Korfiatis
        data.append((key, limit))
334 9747707e Giorgos Korfiatis
335 9747707e Giorgos Korfiatis
    qh.set_quota(data)