-
Notifications
You must be signed in to change notification settings - Fork 5
/
auth.py
384 lines (329 loc) · 14.3 KB
/
auth.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
import csv
import datetime
import json
import logging
import os
import re
import urllib
import urlparse
import webapp2
import local_config
import gsdata
from pytz.gae import pytz
from webapp2_extras import sessions
from collections import defaultdict
from logger import LogAccess
from google.appengine.api import users
from google.appengine.ext import ndb
from google.appengine.ext import webapp
from google.appengine.ext.ndb import msgprop
from protorpc import messages
from google.appengine.api import memcache
mem = memcache.Client()
#-----------------------------------------------------------------------------
# BigQuery authentication
def build_bq_client():
from googleapiclient.discovery import build
from oauth2client.appengine import AppAssertionCredentials
import httplib2
SCOPE = 'https://www.googleapis.com/auth/bigquery'
credentials = AppAssertionCredentials(scope=SCOPE)
http = credentials.authorize(httplib2.Http())
bigquery_service = build('bigquery', 'v2', http=http)
return bigquery_service
#-----------------------------------------------------------------------------
class GeneralFunctions(object):
@staticmethod
def TheNow():
tz = pytz.timezone('US/Eastern')
n = datetime.datetime.utcnow().replace(tzinfo = pytz.utc)
return n.astimezone(tz)
#-----------------------------------------------------------------------------
def auth_and_role_required(role=''):
def role_required_decorator(handler):
"""
Decorator that checks if there's a user associated with the current session,
and that the user has authorization to see the specified course_id content.
Will fail if there's no session present.
Also requires the user to hold a particular role, if specified.
"""
def check_login(self, *args, **kwargs):
redirect = self.do_auth()
if redirect:
return redirect()
if ('org' in kwargs) and ('number' in kwargs) and ('semester' in kwargs):
course_id = '/'.join([kwargs[x] for x in ['org', 'number', 'semester']])
else:
course_id = None
if not self.is_user_authorized_for_course(course_id):
return self.no_auth_sorry()
if role:
if not self.does_user_have_role(role, course_id):
return self.no_auth_sorry()
LogAccess(self.user, self.request, course_id)
return handler(self, *args, **kwargs)
return check_login
return role_required_decorator
def auth_required(handler):
"""
Decorator that checks if there's a user associated with the current session.
Will also fail if there's no session present.
"""
def check_login(self, *args, **kwargs):
redirect = self.do_auth()
if redirect:
return redirect()
if ('org' in kwargs) and ('number' in kwargs) and ('semester' in kwargs):
course_id = '/'.join([kwargs[x] for x in ['org', 'number', 'semester']])
else:
course_id = None
if not self.is_user_authorized_for_course(course_id):
return self.no_auth_sorry()
self.common_data['is_instructor'] = self.does_user_have_role('instructor', course_id)
if not self.request.path == '/get/LogEntries':
LogAccess(self.user, self.request, course_id)
return handler(self, *args, **kwargs)
return check_login
#-----------------------------------------------------------------------------
class AuthenticatedHandler(webapp2.RequestHandler, GeneralFunctions):
CAS_URL = local_config.CAS_URL
AUTH_METHOD = local_config.AUTH_METHOD
AUTHORIZED_USERS = local_config.STAFF_USERS
def do_auth(self):
user = self.Authenticate()
self.user = user
self.common_data['user'] = self.user
if user is None:
return self.do_cas_redirect
return None
def is_superuser(self):
return self.user in self.AUTHORIZED_USERS
def no_auth_sorry(self):
self.response.write("Sorry, %s is not authorized to use this service" % self.user)
def get_staff_table(self, reload=False, ignore_cache=False):
'''
Get staff user table, a list of dicts.
dicts should have "username", "role", and "course_id" as keys. May also have "notes" key.
'''
data = self.get_data('ndb:staff', ignore_cache=True)['data']
# do initial load if empty
if reload or (len(data)==0):
self.import_staff_table(overwrite=True)
data = self.get_data('ndb:staff')['data']
cnt = 1
toremove = []
for elem in data:
elem['sid'] = cnt
if not elem['username'] or (elem['username'].startswith('-')): # drop all entris with username starting with dash
toremove.append(elem)
cnt += 1
for elem in toremove: # remove after labeling all the sid's
data.remove(elem)
return data
def import_staff_table(self, source=None, overwrite=False):
'''
Import staff table from specifid source, into this app's NDB StaffUser model set.
'''
if source is None:
source = getattr(local_config, 'STAFF_COURSE_TABLE', None)
data = self.get_data(source, ignore_cache=True)['data']
if len(data)==0:
msg = "[auth.import_staff_table] ERROR! No data loaded for staff table from %s" % source
logging.error(msg)
raise Exception(msg)
self.import_data_to_ndb(data, 'staff', overwrite)
self.get_staff_course_table(ignore_cache=True) # reload, to refill cache
def disable_staff_table_entry(self, index):
'''
"delete" (really, disable) a staff table entry by prepending the username with a minnus sign.
Works only with the google spreadsheet staff backend.
'''
scdt = getattr(local_config, 'STAFF_COURSE_TABLE', None)
m = re.match('docs:([^:]+):([^:]+)', scdt)
if not m:
logging.error('Attempted to disable staff table entry index=%s, but not using google spreadsheet backend!' % index)
return
fname = m.group(1)
sheet = m.group(2)
stable = self.get_staff_table()
theent = None
for ent in stable:
if ent['sid']==index:
theent = ent
if theent is None:
logging.error('Attempted to disable non-existent staff entry, or one already disabled, index=%s' % index)
return
gsdata.modify_datasheet_acell(fname, sheet, "A%d" % (index+1), "-" + theent['username'])
# flush cache, to force reload
memset = 'docs:%s.%s' % (fname, sheet)
mem.delete(memset)
def add_staff_table_entry(self, data):
'''
Add staff table entry.
Works only with the google spreadsheet staff backend.
'''
scdt = getattr(local_config, 'STAFF_COURSE_TABLE', None)
m = re.match('docs:([^:]+):([^:]+)', scdt)
if not m:
logging.error('Attempted to add staff table entry %s, but not using google spreadsheet backend!' % data)
return
fname = m.group(1)
sheet = m.group(2)
stable = self.get_staff_table()
fields = ['username', 'role', 'course_id', 'notes']
newrow = [data[x] for x in fields]
newpos = stable[-1]['sid']+1
gsdata.append_row_to_datasheet(fname, sheet, newrow)
# flush cache, to force reload
memset = 'docs:%s.%s' % (fname, sheet)
mem.delete(memset)
def get_staff_course_table(self, ignore_cache=False):
'''
Create the local "staff_course_table" which has (username, course_id) in staff_course_table['user_course']
and (username) in staff_course_table['user'].
'''
memset = 'staff_course_table'
staff_course_table = mem.get(memset)
scdt = getattr(local_config, 'STAFF_COURSE_TABLE', None)
if (ignore_cache) or ((not staff_course_table) and (scdt is not None) and (scdt)):
staff = self.get_staff_table()
staff_course_table = {'user_course': {}, 'user': defaultdict(list)}
for k in staff:
staff_course_table['user_course'][(k['username'], k['course_id'])] = k
staff_course_table['user'][k['username']].append(k)
mem.set(memset, staff_course_table, time=3600*12)
logging.info('staff_course_table = %s' % staff_course_table.keys())
return staff_course_table
def is_pm(self):
'''
pm = project manager
'''
return self.does_user_have_role('pm')
def does_user_have_role(self, role, course_id=None):
'''
Return True if user has specified role.
'''
if self.is_superuser():
return True
staff_course_table = self.get_staff_course_table()
users = staff_course_table['user']
if not self.user in users:
return False
for uent in users[self.user]: # each entry is a dict, with keys course_id, role, and notes
if uent['role']==role:
if course_id is None:
return True
if not uent['course_id']: # if empty, then role is global across all courses
return True
if uent['course_id']==course_id:
return True
return False
def is_user_authorized_for_course(self, course_id=None, user=None):
'''
Return True if user is authorized for the course.
'''
if (not user) and self.is_superuser():
return True
if not user:
user = self.user
staff_course_table = self.get_staff_course_table()
# logging.info('user=%s, cid = %s' % (self.user, course_id))
# logging.info('sct_user=%s' % staff_course_table['user'])
if staff_course_table is None or not staff_course_table:
return False
if course_id and ((user, course_id) in staff_course_table['user_course']):
return True
if (course_id is None) and (user in staff_course_table['user']):
return True
for uent in staff_course_table['user'].get(user, []):
if 'pm' in uent['role'].split(','):
return True
return False
def dispatch(self):
# Get a session store for this request.
self.session_store = sessions.get_store(request=self.request)
if hasattr(self, 'common_init'):
self.common_init()
try:
# Dispatch the request.
webapp2.RequestHandler.dispatch(self)
finally:
# Save all sessions.
self.session_store.save_sessions(self.response)
@webapp2.cached_property
def session(self):
# Returns a session using the default cookie key.
return self.session_store.get_session()
def GoogleAuthenticate(self):
user = users.get_current_user()
if user:
greeting = ('Welcome, %s! (<a href="%s">sign out</a>)' %
(user.nickname(), users.create_logout_url('/')))
else:
greeting = ('<a href="%s">Sign in or register</a>.' %
users.create_login_url('/'))
logging.info(greeting)
return user.nickname()
def Authenticate(self):
if 'google' in self.AUTH_METHOD:
return self.GoogleAuthenticate()
elif self.AUTH_METHOD=='local':
return self.AUTHORIZED_USERS[0]
# If the request contains a login ticket, try to validate it
ticket = self.request.get('ticket', None)
if ticket is None and ('ticket' in self.session):
ticket = self.session['ticket']
if ticket is not None:
if 'validated' in self.session:
return self.session['validated']
netid = self.Validate(ticket)
logging.info('[Authenticate] ticket=%s, userid=%s' % (ticket, netid))
if netid is not None:
self.session['ticket'] = ticket
self.session['validated'] = netid
return netid
return None
def Validate(self, ticket):
val_url = self.CAS_URL + "validate" + '?service=' + urllib.quote(self.ServiceURL()) + '&ticket=' + urllib.quote(ticket)
r = urllib.urlopen(val_url).readlines() # returns 2 lines
logging.info('[validate] r=%s' % r)
if len(r) == 2 and re.match("yes", r[0]) != None:
return r[1].strip()
return None
def ServiceURL(self):
ruri = self.request.uri
if ruri:
# ret = 'http://' + self.request.host + ruri
ret = self.request.path_url
ret = re.sub(r'ticket=[^&]*&?', '', ret)
ret = re.sub(r'\?&?$|&$', '', ret)
#ret = ret + '?' + self.request.query_string
if self.request.get('auth', ''):
self.session['auth_query'] = json.dumps(dict(self.request.GET.copy()))
#if 'ticket' in qs:
# qs.pop('ticket')
#ret = ret + '?' + urllib.urlencode(qs)
logging.info('[ServiceURL] %s' % ret)
return ret
#$url = preg_replace('/ticket=[^&]*&?/', '', $url);
#return preg_replace('/?&?$|&$/', '', $url);
logging.info('[ServiceURL] no REQUEST_URI')
return "something is badly wrong"
def do_cas_redirect(self):
if 'google' in self.AUTH_METHOD:
return self.redirect("/login")
login_url = self.CAS_URL + 'login' + '?service=' + urllib.quote(self.ServiceURL())
logging.info('no auth, reditecting to %s' % login_url)
return self.redirect(login_url)
def sample_get_do_auth(self, msg=''):
user = self.Authenticate()
if user is None:
return self.do_cas_redirect()
def add_origin(self):
origin = self.request.headers.get('Origin', None)
if origin is None:
self.response.headers.add_header("Access-Control-Allow-Origin", "*")
else:
self.response.headers['Access-Control-Allow-Origin'] = origin
self.response.headers['Access-Control-Allow-Headers'] = 'Origin, X-Requested-With, Content-Type, Accept, X-CSRFToken'
self.response.headers['Access-Control-Allow-Methods'] = 'POST, GET, PUT, DELETE'