Actions.py: created generic funtion for delete local:account
[myslice.git] / portal / actions.py
1 from django.http                 import HttpResponse
2 from manifold.core.query         import Query
3 from manifold.manifoldapi        import execute_query,execute_admin_query
4 from portal.models               import PendingUser, PendingSlice
5 import json
6
7 # Thierry: moving this right into the code so 
8 # most people can use myslice without having to install sfa
9 # XXX tmp sfa dependency, should be moved to SFA gateway
10 #from sfa.util.xrn                import Xrn 
11
12
13 # Get the list of authorities
14
15 def authority_get_pis(request, authority_hrn):
16     query = Query.get('authority').filter_by('authority_hrn', '==', authority_hrn).select('pi_users')
17     results = execute_query(request, query)
18     # NOTE: temporarily commented. Because results is giving empty list. 
19     # Needs more debugging
20     #if not results:
21     #    raise Exception, "Authority not found: %s" % authority_hrn
22     #result, = results
23     #return result['pi_users']
24     return results
25
26 def authority_get_pi_emails(request, authority_hrn):
27     return ['jordan.auge@lip6.fr', 'loic.baron@lip6.fr']
28
29     pi_users = authority_get_pis(request,authority_hrn)
30     pi_user_hrns = [ hrn for x in pi_users for hrn in x['pi_users'] ]
31     query = Query.get('user').filter_by('user_hrn', 'included', pi_user_hrns).select('email')
32     results = execute_query(request, query)
33     print "mails",  [result['email'] for result in results]
34     return [result['email'] for result in results]
35
36 # SFA add record (user, slice)
37
38 def sfa_add_user(request, user_params):
39     query = Query.create('user').set(user_params).select('user_hrn')
40     results = execute_query(request, query)
41     if not results:
42         raise Exception, "Could not create %s. Already exists ?" % user_params['hrn']
43     return results
44
45 def sfa_add_slice(request, slice_params):
46     query = Query.create('slice').set(slice_params).select('slice_hrn')
47     results = execute_query(request, query)
48     if not results:
49         raise Exception, "Could not create %s. Already exists ?" % slice_params['hrn']
50     return results
51
52 # Propose hrn
53
54 def manifold_add_user(request, user_params):
55     # user_params: email, password e.g., user_params = {'email':'aa@aa.com','password':'demo'}
56     query = Query.create('local:user').set(user_params).select('email')
57     results = execute_admin_query(request, query)
58     if not results:
59         raise Exception, "Failed creating manifold user: %s" % user_params['email']
60     result, = results
61     return result['email']
62
63 def manifold_update_user(request, user_params):
64     # user_params: password, config e.g., 
65     query = Query.update('local:user').filter_by('email', '==', request.user.email).set(user_params).select('email')
66     results = execute_query(request,query)
67     # NOTE: results remains empty and goes to Exception. However, it updates the manifold DB.
68     # That's why I commented the exception part. -- Yasin 
69     #if not results:
70     #    raise Exception, "Failed updating manifold user: %s" % user_params['email']
71     #result, = results
72     return results
73
74 def manifold_add_account(request, account_params):
75     query = Query.create('local:account').set(account_params).select(['user', 'platform'])
76     results = execute_admin_query(request,query)
77     if not results:
78         raise Exception, "Failed creating manifold account on platform %s for user: %s" % (account_params['platform'], account_params['user'])
79     result, = results
80     return result['user_id']
81
82 def manifold_update_account(request,account_params):
83     # account_params: config
84     query = Query.update('local:account').filter_by('platform', '==', 'myslice').set(account_params).select('user_id')
85     results = execute_query(request,query)
86     # NOTE: results remains empty and goes to Exception. However, it updates the manifold DB.
87     # That's why I commented the exception part. -- Yasin 
88     #if not results:
89     #    raise Exception, "Failed updating manifold account: config %s" % account_params['config']
90     #result, = results
91     return results
92
93 #explicitly mention the platform_id
94 def manifold_delete_account(request, platform_id, account_params):
95     query = Query.delete('local:account').filter_by('platform_id', '==', platform_id).set(account_params).select('user_id')
96     results = execute_query(request,query)
97     return results
98
99
100 #not tested
101 def manifold_add_platform(request, platform_params):
102     query = Query.create('local:platform').set(platform_params).select(['user', 'platform'])
103     results = execute_admin_query(request,query)
104     if not results:
105         raise Exception, "Failed creating manifold  platform %s for user: %s" % (platform_params['platform'], platform_params['user'])
106     result, = results
107     return result['platform_id']
108
109
110 def make_request_user(user):
111     request = {}
112     request['type']          = 'user'
113     request['id']            = user.id
114     request['timestamp']     = user.created # XXX in DB ?
115     request['authority_hrn'] = user.authority_hrn
116     request['first_name']    = user.first_name
117     request['last_name']     = user.last_name
118     request['email']         = user.email
119     request['login']         = user.login
120     request['keypair']       = user.keypair
121     return request
122
123 def make_request_slice(slice):
124     request = {}
125     request['type'] = 'slice'
126     request['id'] = slice.id
127     request['timestamp'] = slice.created
128     request['authority_hrn'] = slice.authority_hrn
129     request['slice_name'] = slice.slice_name
130     request['number_of_nodes'] = slice.number_of_nodes
131     request['type_of_nodes'] = slice.type_of_nodes
132     request['purpose'] = slice.purpose
133     return request
134
135 def make_requests(pending_users, pending_slices):
136     print "pending users =", pending_users
137     print "pending slices =", pending_slices
138
139     requests = []
140     for user in pending_users:
141         requests.append(make_request_user(user))
142     for slice in pending_slices:
143         requests.append(make_request_slice(slice))
144     return requests   
145
146 def get_request_by_id(ids):
147     sorted_ids = { 'user': [], 'slice': [] }
148     for type__id in ids:
149         type, id = type__id.split('__')
150         sorted_ids[type].append(id)
151         
152     if not ids:
153         pending_users  = PendingUser.objects.all()
154         pending_slices = PendingSlice.objects.all()
155     else:
156         pending_users  = PendingUser.objects.filter(id__in=sorted_ids['user']).all()
157         pending_slices = PendingSlice.objects.filter(id__in=sorted_ids['slice']).all()
158
159     return make_requests(pending_users, pending_slices)
160
161 def get_request_by_authority(authority_hrns):
162     if not authority_hrns:
163         pending_users  = PendingUser.objects.all()
164         pending_slices = PendingSlice.objects.all()
165     else:
166         pending_users  = PendingUser.objects.filter(authority_hrn__in=authority_hrns).all()
167         pending_slices = PendingSlice.objects.filter(authority_hrn__in=authority_hrns).all()
168
169     return make_requests(pending_users, pending_slices)
170     
171 # XXX Is it in sync with the form fields ?
172
173 def portal_validate_request(wsgi_request, request_ids):
174     status = {}
175
176     if not isinstance(request_ids, list):
177         request_ids = [request_ids]
178
179     requests = get_request_by_id(request_ids)
180     for request in requests:
181         # type, id, timestamp, details, allowed -- MISSING: authority_hrn
182         # CAREFUL about details
183         # user  : first name, last name, email, password, keypair
184         # slice : number of nodes, type of nodes, purpose
185         
186         request_status = {}
187
188         print "REQUEST", request
189         if request['type'] == 'user':
190
191             try:
192                 hrn = "%s.%s" % (request['authority_hrn'], request['login'])
193                 # XXX tmp sfa dependency
194                 from sfa.util.xrn import Xrn 
195                 urn = Xrn(hrn, request['type']).get_urn()
196
197                 sfa_user_params = {
198                     'hrn'        : hrn, 
199                     'urn'        : urn,
200                     'type'       : request['type'],
201                     'keys'       : [json.loads(request['keypair'])['user_public_key']],
202                     'first_name' : request['first_name'],
203                     'last_name'  : request['last_name'],
204                     'email'      : request['email'],
205                     #'slices'    : None,
206                     #'researcher': None,
207                     #'pi'        : None,
208                     'enabled'    : True
209                 }
210                 # ignored in request: id, timestamp, password
211
212                 sfa_add_user(wsgi_request, sfa_user_params)
213
214                 # XXX Remove from database
215
216
217                 request_status['SFA user'] = {'status': True }
218
219             except Exception, e:
220                 request_status['SFA user'] = {'status': False, 'description': str(e)}
221
222             # MANIFOLD user should be added beforehand, during registration
223             #try:
224             #    manifold_user_params = { key: request[key] for key in MANIFOLD_USER_KEYS }
225             #    # XXX # manifold_add_user(manifold_user_params)
226             #    request_status['MySlice user'] = {'status': True }
227             #except Exception, e:
228             #    request_status['MySlice user'] = {'status': False, 'description': str(e)}
229
230             # XXX
231             #manifold_account_params = { key: request[key] for key in MANIFOLD_ACCOUNT_KEYS }
232             #manifold_add_account(manifold_account_params)
233             #request_status['MySlice testbed accounts'] = {'status': False }
234
235         elif request['type'] == 'slice':
236             try:
237                 hrn = "%s.%s" % (request['authority_hrn'], request['slice_name'])
238                 # XXX tmp sfa dependency
239                 from sfa.util.xrn import Xrn 
240                 urn = Xrn(hrn, request['type']).get_urn()
241
242                 sfa_slice_params = {
243                     'hrn'        : hrn, 
244                     'urn'        : urn,
245                     'type'       : request['type'],
246                     #'slices'    : None,
247                     #'researcher': None,
248                     #'pi'        : None,
249                     'enabled'    : True
250                 }
251                 # ignored in request: id, timestamp,  number_of_nodes, type_of_nodes, purpose
252
253                 sfa_add_slice(wsgi_request, sfa_slice_params)
254
255                 # XXX Remove from database
256
257             
258                 request_status['SFA slice'] = {'status': True }
259
260             except Exception, e:
261                 request_status['SFA slice'] = {'status': False, 'description': str(e)}
262
263         status['%s__%s' % (request['type'], request['id'])] = request_status
264
265     return status
266
267
268 def validate_action(request, **kwargs):
269     ids = filter(None, kwargs['id'].split('/'))
270     status = portal_validate_request(request, ids)
271     json_answer = json.dumps(status)
272     return HttpResponse (json_answer, mimetype="application/json")
273
274 # Django and ajax
275 # http://djangosnippets.org/snippets/942/