Statistics
| Branch: | Tag: | Revision:

root / snf-astakos-app / astakos / im / quotas.py @ 5cdbe7cc

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 bea584e1 Giorgos Korfiatis
    Resource, AstakosUserQuota, AstakosUser, Service,
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 bea584e1 Giorgos Korfiatis
def service_get_quotas(component, users=None):
99 0e08e08e Giorgos Korfiatis
    name_values = Service.objects.filter(
100 0e08e08e Giorgos Korfiatis
        component=component).values_list('name')
101 0e08e08e Giorgos Korfiatis
    service_names = [t for (t,) in name_values]
102 0e08e08e Giorgos Korfiatis
    resources = Resource.objects.filter(service_origin__in=service_names)
103 bb005bc2 Giorgos Korfiatis
    resource_names = [r.name for r in resources]
104 5afce44d Giorgos Korfiatis
    counters = qh.get_quota(holders=users, resources=resource_names)
105 bb005bc2 Giorgos Korfiatis
    return transform_data(counters)
106 bb005bc2 Giorgos Korfiatis
107 bb005bc2 Giorgos Korfiatis
108 9b126f13 Giorgos Korfiatis
def _level_quota_dict(quotas):
109 9b126f13 Giorgos Korfiatis
    lst = []
110 9b126f13 Giorgos Korfiatis
    for holder, holder_quota in quotas.iteritems():
111 9b126f13 Giorgos Korfiatis
        for source, source_quota in holder_quota.iteritems():
112 9b126f13 Giorgos Korfiatis
            for resource, limit in source_quota.iteritems():
113 9b126f13 Giorgos Korfiatis
                key = (holder, source, resource)
114 9b126f13 Giorgos Korfiatis
                lst.append((key, limit))
115 9b126f13 Giorgos Korfiatis
    return lst
116 9b126f13 Giorgos Korfiatis
117 9b126f13 Giorgos Korfiatis
118 e336910f Giorgos Korfiatis
def _set_user_quota(quotas):
119 9b126f13 Giorgos Korfiatis
    q = _level_quota_dict(quotas)
120 9b126f13 Giorgos Korfiatis
    qh.set_quota(q)
121 aa27f246 Giorgos Korfiatis
122 aa27f246 Giorgos Korfiatis
123 aa27f246 Giorgos Korfiatis
def get_default_quota():
124 aa27f246 Giorgos Korfiatis
    _DEFAULT_QUOTA = {}
125 aa27f246 Giorgos Korfiatis
    resources = Resource.objects.select_related('service').all()
126 aa27f246 Giorgos Korfiatis
    for resource in resources:
127 aa27f246 Giorgos Korfiatis
        capacity = resource.uplimit
128 aa27f246 Giorgos Korfiatis
        _DEFAULT_QUOTA[resource.full_name()] = capacity
129 aa27f246 Giorgos Korfiatis
130 aa27f246 Giorgos Korfiatis
    return _DEFAULT_QUOTA
131 aa27f246 Giorgos Korfiatis
132 aa27f246 Giorgos Korfiatis
133 aa27f246 Giorgos Korfiatis
SYSTEM = 'system'
134 3c22bad0 Giorgos Korfiatis
PENDING_APP_RESOURCE = 'astakos.pending_app'
135 aa27f246 Giorgos Korfiatis
136 aa27f246 Giorgos Korfiatis
137 3c22bad0 Giorgos Korfiatis
def register_pending_apps(user, quantity, force=False):
138 3c22bad0 Giorgos Korfiatis
    provision = (user.uuid, SYSTEM, PENDING_APP_RESOURCE), quantity
139 9e3af524 Giorgos Korfiatis
    try:
140 9e3af524 Giorgos Korfiatis
        s = qh.issue_commission(clientkey='astakos',
141 9e3af524 Giorgos Korfiatis
                                force=force,
142 9e3af524 Giorgos Korfiatis
                                provisions=[provision])
143 9e3af524 Giorgos Korfiatis
    except NoCapacityError as e:
144 9e3af524 Giorgos Korfiatis
        limit = e.data['limit']
145 9e3af524 Giorgos Korfiatis
        return False, limit
146 3c22bad0 Giorgos Korfiatis
    qh.resolve_pending_commission('astakos', s)
147 9e3af524 Giorgos Korfiatis
    return True, None
148 9770ba6c Giorgos Korfiatis
149 9770ba6c Giorgos Korfiatis
150 3c22bad0 Giorgos Korfiatis
def get_pending_app_quota(user):
151 3c22bad0 Giorgos Korfiatis
    quota = get_user_quotas(user)
152 3c22bad0 Giorgos Korfiatis
    return quota[SYSTEM][PENDING_APP_RESOURCE]
153 3c22bad0 Giorgos Korfiatis
154 3c22bad0 Giorgos Korfiatis
155 764d99c4 Giorgos Korfiatis
def add_base_quota(user, resource, capacity):
156 764d99c4 Giorgos Korfiatis
    resource = Resource.objects.get(name=resource)
157 3c22bad0 Giorgos Korfiatis
    user = get_user_for_update(user.id)
158 764d99c4 Giorgos Korfiatis
    obj, created = AstakosUserQuota.objects.get_or_create(
159 764d99c4 Giorgos Korfiatis
        user=user, resource=resource, defaults={
160 764d99c4 Giorgos Korfiatis
            'capacity': capacity,
161 764d99c4 Giorgos Korfiatis
        })
162 764d99c4 Giorgos Korfiatis
163 764d99c4 Giorgos Korfiatis
    if not created:
164 764d99c4 Giorgos Korfiatis
        obj.capacity = capacity
165 764d99c4 Giorgos Korfiatis
        obj.save()
166 3c22bad0 Giorgos Korfiatis
    qh_sync_locked_user(user)
167 764d99c4 Giorgos Korfiatis
168 764d99c4 Giorgos Korfiatis
169 764d99c4 Giorgos Korfiatis
def remove_base_quota(user, resource):
170 3c22bad0 Giorgos Korfiatis
    user = get_user_for_update(user.id)
171 764d99c4 Giorgos Korfiatis
    AstakosUserQuota.objects.filter(
172 764d99c4 Giorgos Korfiatis
        user=user, resource__name=resource).delete()
173 3c22bad0 Giorgos Korfiatis
    qh_sync_locked_user(user)
174 764d99c4 Giorgos Korfiatis
175 764d99c4 Giorgos Korfiatis
176 aa27f246 Giorgos Korfiatis
def initial_quotas(users):
177 103086a4 Giorgos Korfiatis
    users = list(users)
178 aa27f246 Giorgos Korfiatis
    initial = {}
179 aa27f246 Giorgos Korfiatis
    default_quotas = get_default_quota()
180 aa27f246 Giorgos Korfiatis
181 aa27f246 Giorgos Korfiatis
    for user in users:
182 aa27f246 Giorgos Korfiatis
        uuid = user.uuid
183 aa27f246 Giorgos Korfiatis
        source_quota = {SYSTEM: dict(default_quotas)}
184 aa27f246 Giorgos Korfiatis
        initial[uuid] = source_quota
185 aa27f246 Giorgos Korfiatis
186 aa27f246 Giorgos Korfiatis
    objs = AstakosUserQuota.objects.select_related()
187 aa27f246 Giorgos Korfiatis
    orig_quotas = objs.filter(user__in=users)
188 aa27f246 Giorgos Korfiatis
    for user_quota in orig_quotas:
189 aa27f246 Giorgos Korfiatis
        uuid = user_quota.user.uuid
190 aa27f246 Giorgos Korfiatis
        user_init = initial.get(uuid, {})
191 003909e3 Giorgos Korfiatis
        source_quota = user_init.get(SYSTEM, {})
192 aa27f246 Giorgos Korfiatis
        resource = user_quota.resource.full_name()
193 003909e3 Giorgos Korfiatis
        source_quota[resource] = user_quota.capacity
194 003909e3 Giorgos Korfiatis
        user_init[SYSTEM] = source_quota
195 aa27f246 Giorgos Korfiatis
        initial[uuid] = user_init
196 aa27f246 Giorgos Korfiatis
197 aa27f246 Giorgos Korfiatis
    return initial
198 aa27f246 Giorgos Korfiatis
199 aa27f246 Giorgos Korfiatis
200 aa27f246 Giorgos Korfiatis
def get_grant_source(grant):
201 aa27f246 Giorgos Korfiatis
    return SYSTEM
202 aa27f246 Giorgos Korfiatis
203 aa27f246 Giorgos Korfiatis
204 cb14cc6c Giorgos Korfiatis
def astakos_users_quotas(users, initial=None):
205 103086a4 Giorgos Korfiatis
    users = list(users)
206 aa27f246 Giorgos Korfiatis
    if initial is None:
207 aa27f246 Giorgos Korfiatis
        quotas = initial_quotas(users)
208 aa27f246 Giorgos Korfiatis
    else:
209 aa27f246 Giorgos Korfiatis
        quotas = copy.deepcopy(initial)
210 aa27f246 Giorgos Korfiatis
211 aa27f246 Giorgos Korfiatis
    ACTUALLY_ACCEPTED = ProjectMembership.ACTUALLY_ACCEPTED
212 6d583e07 Giorgos Korfiatis
    objs = ProjectMembership.objects.select_related(
213 6d583e07 Giorgos Korfiatis
        'project', 'person', 'project__application')
214 6d583e07 Giorgos Korfiatis
    memberships = objs.filter(
215 6d583e07 Giorgos Korfiatis
        person__in=users,
216 6d583e07 Giorgos Korfiatis
        state__in=ACTUALLY_ACCEPTED,
217 6d583e07 Giorgos Korfiatis
        project__state=Project.NORMAL,
218 6d583e07 Giorgos Korfiatis
        project__application__state=ProjectApplication.APPROVED)
219 aa27f246 Giorgos Korfiatis
220 6d583e07 Giorgos Korfiatis
    apps = set(m.project.application_id for m in memberships)
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 6d583e07 Giorgos Korfiatis
        application = membership.project.application
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)