def register(): db = DBConnection() d = request.args params = {k:v for k,v in d.iteritems()} params['gender'] = params.pop('gensel') params['driver'] = True if params.pop('dsel') is 'y' else False params['graduating'] = True if params.pop('gsel') is 'y' else False params['shirt'] = params.pop('ssel') params['gym'] = params.pop('msel') if len(db.get('members', fname=params['fname'], lname=params['lname'])) == 0: db.insert('members',timestamp=datetime.datetime.utcnow(),**params) return jsonify(already_inserted='false') else: return jsonify(already_inserted='true')
def register(): db = DBConnection() d = request.args params = {k: v for k, v in d.iteritems()} params['gender'] = params.pop('gensel') params['driver'] = True if params.pop('dsel') is 'y' else False params['graduating'] = True if params.pop('gsel') is 'y' else False params['shirt'] = params.pop('ssel') params['gym'] = params.pop('msel') if len(db.get('members', fname=params['fname'], lname=params['lname'])) == 0: db.insert('members', timestamp=datetime.datetime.utcnow(), **params) return jsonify(already_inserted='false') else: return jsonify(already_inserted='true')
def populate_class(): db = DBConnection() name = request.args.get("name","") links = [x['link'] for x in db.get("classes", Instructor=name)] for link in links: r = requests.get(link) soup = BeautifulSoup(r.content) print "processed, %s" % (r.status_code) rows = list(soup.find_all('tr'))[1:] rowdict = {} for row in rows[1:]: row = filter(lambda x: x != '\n', row) if len(row) == 2: rowdict.update({row[0].get_text().strip() : row[1].get_text().strip()}) print rowdict db.update("classes", {'Instructor': name, 'link':link},**rowdict) return jsonify(links=links)
def search_for_prof(): db = DBConnection() name = request.args.get("name","") classes = db.classes_for_name(name) if classes is not None: return jsonify(name=name, classes=classes) params = { "q" : name, "site" : "Directory_of_Classes", "num" : 20, "filter" : 0, "entqr" : 0, "ud" : 1, "sort" : "date%3AD%3AL%3Ad1", "output" : "xml_no_dtd", "oe" : "UTF-8", "ie" : "UTF-8", "client" : "DoC", "proxystylesheet" : "DoC", "proxyreload" : 1 } search = requests.get("http://search.columbia.edu/search", params=params) search_result = BeautifulSoup(search.content) if search_result.find(id="empty") is None: classes = [] for cls in search_result.find_all("a","l"): if "Fall 2012" in "".join(map(str, cls.contents)): x = cls.get('href') classes.append(x) db.insert('classes', Instructor = name, link=x) return jsonify(name=name, classes=classes) db.insert('classes', Instructor = name, no_classes=True) return jsonify(name=name, classes=[])
def index(): db = DBConnection() num_members = db.get('members', gym='mphc') if len(num_members) >= 50: return render_template('index.html', mphc_available=False) return render_template('index.html', mphc_available=True)
def index(): db = DBConnection() num_members = db.get('members',gym='mphc') if len(num_members) >= 50: return render_template('index.html', mphc_available=False) return render_template('index.html', mphc_available=True)