myslice prefixed queries to speed up the portal
[myslice.git] / portal / registrationview.py
1 import os.path, re
2 import json
3 from random     import randint
4 from hashlib    import md5
5
6 from django.views.generic       import View
7 from django.template.loader     import render_to_string
8
9 from django.shortcuts           import render
10 from django.contrib.auth        import get_user_model
11 from django.contrib.sites.models import Site
12
13 from unfold.page                import Page
14 from unfold.loginrequired       import FreeAccessView
15 from ui.topmenu                 import topmenu_items_live
16
17 from manifoldapi.manifoldapi    import execute_admin_query
18 from manifold.core.query        import Query
19
20 from portal.models              import PendingUser
21 from portal.actions             import create_pending_user
22
23 from myslice.theme import ThemeView
24
25 import activity.user
26
27 # since we inherit from FreeAccessView we cannot redefine 'dispatch'
28 # so let's override 'get' and 'post' instead
29 #
30 class RegistrationView (FreeAccessView, ThemeView):
31     template_name = 'registration_view.html'
32     
33     def post (self, request):
34         return self.get_or_post (request, 'POST')
35
36     def get (self, request):
37         return self.get_or_post (request, 'GET')
38
39     def get_or_post(self, wsgi_request, method):
40         """
41         """
42         errors = []
43         authority_hrn = None
44         # REGISTRY ONLY TO BE REMOVED WITH MANIFOLD-V2
45         authorities_query = Query.get('authority').select('name', 'authority_hrn')
46         authorities = execute_admin_query(wsgi_request, authorities_query)
47         if authorities is not None:
48             authorities = sorted(authorities)
49         
50         print "############ BREAKPOINT 1 #################"
51         # Page rendering
52         page = Page(wsgi_request)
53         page.add_js_files  ( [ "js/jquery.validate.js", "js/my_account.register.js", "js/jquery.qtip.min.js","js/jquery-ui.js" ] )
54         page.add_css_files ( [ "css/onelab.css", "css/registration.css", "css/jquery.qtip.min.css" ] )
55         page.add_css_files ( [ "https://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css" ] )
56         page.expose_js_metadata()
57         print "############ BREAKPOINT 2 #################"
58         if method == 'POST':
59             reg_form = {}
60             # The form has been submitted
61             
62             # get the domain url
63             current_site = Site.objects.get_current()
64             current_site = current_site.domain
65             
66             print "############ BREAKPOINT 3 #################"
67             
68             for authority in authorities:
69                 if authority['name'] == wsgi_request.POST.get('org_name', ''):
70                     authority_hrn = authority['authority_hrn']     
71
72             # Handle the case when the template uses only hrn and not name
73             if authority_hrn is None:
74                 authority_hrn = wsgi_request.POST.get('org_name', '')
75             
76             print "############ BREAKPOINT 4 #################"
77             
78             post_email = wsgi_request.POST.get('email','').lower()
79             salt = randint(1,100000)
80             email_hash = md5(str(salt)+post_email).hexdigest()
81             #email_hash = md5(post_email).digest().encode('base64')[:-1]
82             user_request = {
83                 'first_name'    : wsgi_request.POST.get('firstname',     ''),
84                 'last_name'     : wsgi_request.POST.get('lastname',      ''),
85                 'organization'  : wsgi_request.POST.get('org_name', ''),
86                 'authority_hrn' : authority_hrn, 
87                 'email'         : post_email,
88                 'password'      : wsgi_request.POST.get('password',      ''),
89                 'current_site'  : current_site,
90                 'email_hash'    : email_hash,
91                 'pi'            : '',
92                 'validation_link': 'http://' + current_site + '/portal/email_activation/'+ email_hash
93             }
94             
95             print "############ BREAKPOINT 5 #################"
96             
97             # Construct user_hrn from email (XXX Should use common code)
98             split_email = user_request['email'].split("@")[0] 
99             split_email = split_email.replace(".", "_")
100             # Replace + by _ => more convenient for testing and validate with a real email
101             split_email = split_email.replace("+", "_")
102             user_request['user_hrn'] = user_request['authority_hrn'] \
103                      + '.' + split_email
104             
105             # Validate input
106             UserModel = get_user_model()
107             if (re.search(r'^[\w+\s.@+-]+$', user_request['first_name']) == None):
108                 errors.append('First name may contain only letters, numbers, spaces and @/./+/-/_ characters.')
109             if (re.search(r'^[\w+\s.@+-]+$', user_request['last_name']) == None):
110                 errors.append('Last name may contain only letters, numbers, spaces and @/./+/-/_ characters.')
111             # Does the user exist in Manifold?
112             user_query  = Query().get('local:user').select('user_id','email')
113             user_details = execute_admin_query(wsgi_request, user_query)
114             for user_detail in user_details:
115                 if user_detail['email'] == user_request['email']:
116                     errors.append('Email already registered. <a href="/">Login</a> with your existing account. <a href="/portal/pass_reset/">Forgot your password?</a>')
117
118             # Does the user exist in sfa? [query is very slow!!]
119             #user_query  = Query().get('user').select('user_hrn','user_email')
120             # XXX Test based on the user_hrn is quick
121
122             # REGISTRY ONLY TO BE REMOVED WITH MANIFOLD-V2
123             user_query  = Query().get('myslice:user').select('user_hrn','user_email').filter_by('user_hrn','==',user_request['user_hrn'])
124             user_details_sfa = execute_admin_query(wsgi_request, user_query)
125
126             for user in user_details_sfa:
127                 if user['user_email'] == user_request['email']:
128                     errors.append('Email already registered in OneLab registry. <a href="/contact">Contact OneLab support</a> or use another email.')
129                 if user['user_hrn'] == user_request['user_hrn']:
130                     # add random number if user_hrn already exists in the registry
131                     user_request['user_hrn'] = user_request['authority_hrn'] \
132                             + '.' + split_email + str(randint(1,1000000))
133
134             # checking in django unfold db portal application pending users
135             # sqlite3 /var/unfold/unfold.sqlite3
136             # select email from portal_pendinguser;
137             if PendingUser.objects.filter(email__iexact = user_request['email']):
138                 errors.append('Account pending for validation. Please wait till your account is validated or contact OneLab support.')
139
140             # checking in django_db !!
141             # sqlite3 /var/unfold/unfold.sqlite3
142             # select email from auth_user;
143             if UserModel._default_manager.filter(email__iexact = user_request['email']): 
144                 errors.append('<a href="/contact">Contact OneLab support</a> or try with another email.')
145
146             # XXX TODO: Factorize with portal/accountview.py
147             # XXX TODO: Factorize with portal/registrationview.py
148             # XXX TODO: Factorize with portal/joinview.py
149             if 'generate' in wsgi_request.POST['question']:
150                 user_request['auth_type'] = 'managed'
151
152                 # XXX Common code, dependency ?
153                 from Crypto.PublicKey import RSA
154                 private = RSA.generate(1024)
155
156                 # Example: private_key = '-----BEGIN RSA PRIVATE KEY-----\nMIIC...'
157                 # Example: public_key = 'ssh-rsa AAAAB3...'
158                 user_request['private_key'] = private.exportKey()
159                 user_request['public_key']  = private.publickey().exportKey(format='OpenSSH')
160
161             else: 
162                 user_request['auth_type'] = 'user'
163
164                 up_file        = wsgi_request.FILES['user_public_key']
165
166                 file_content   = up_file.read().strip()
167                 file_name      = up_file.name
168                 file_extension = os.path.splitext(file_name)[1]
169
170                 ALLOWED_EXTENSIONS =  ['.pub','.txt']
171                 if file_extension not in ALLOWED_EXTENSIONS or not re.search(r'ssh-rsa',file_content):
172                     errors.append('Please upload a valid RSA public key.')
173                 # user_request['private_key'] can't be Null because all db fields are set as NOT NULL
174                 user_request['private_key'] = ""
175                 user_request['public_key']  = file_content
176                 
177             if not errors:
178                 create_pending_user(wsgi_request, user_request, user_detail)
179                 self.template_name = 'user_register_complete.html'
180                 # log user activity
181                 activity.user.registered(self.request)
182                 return render(wsgi_request, self.template, {'theme': self.theme}) 
183
184         else:
185             print "############ BREAKPOINT A #################"
186             user_request = {}
187             ## this is coming from onelab website onelab.eu
188             reg_form = {
189                 'first_name':  wsgi_request.GET.get('first_name', ''),
190                 'last_name': wsgi_request.GET.get('last_name', ''),
191                 'email': wsgi_request.GET.get('email', ''),
192                 }
193             # log user activity
194             activity.user.signup(self.request)
195             print "############ BREAKPOINT B #################"
196
197         template_env = {
198           #'topmenu_items': topmenu_items_live('Register', page),
199           'errors': errors,
200           'authorities': authorities,
201           'theme': self.theme
202           }
203         template_env.update(user_request)
204         template_env.update(reg_form)
205         template_env.update(page.prelude_env ())
206         print "############ BREAKPOINT C #################"
207         return render(wsgi_request, self.template,template_env)