def add_college(parameters): response = {"message": [], "status": "failed"} csvfile = parameters['csvfile'] cl = College() result = cl.save_college(csvfile) if result: result = 'created!' response['message'] = result response['status'] = 'success' return response
def list_college(parameters): response = {"data": [], "status": "failed"} university = parameters.get('university', '') city = parameters.get('city', '') fees = parameters.get('fees', '') marks = parameters.get('marks', '') if university: university = university.split(',') if city: city = city.split(',') cl = College() result = cl.fetch_all(university, city, fees, marks) response['data'] = result response['status'] = 'success' return response
def create_college(college_id, name, city, state, longitude, latitude): """Create and return a new college""" college = College(college_id=college_id, name=name, city=city, state=state, longitude=longitude, latitude=latitude) db.session.add(college) db.session.commit() return college
def get(self): colleges = College.all() elec_engi = None for college in colleges: if college.col_name == 'College of Electrical Engineering and Computer Science': elec_engi = college break chris = User(name = 'christopher', password = '******', email = '*****@*****.**', studentid = 'b00902112', college = elec_engi, admin = bool(1)) chris.put() omar = User(name = 'omar', password = '******', email = '*****@*****.**', studentid = 't00902109', college = elec_engi, admin = bool(1)) omar.put() pitillo = User(name = 'agus', password = '******', email = '*****@*****.**', studentid = 't00901109', college = elec_engi, admin = bool(1)) pitillo.put() template_values = {'title': 'data loaded', 'message': 'users loaded', 'method': 'get', 'action': '/', 'value': 'continue' } path = os.path.join(os.path.dirname(__file__), 'html/message.html') self.response.out.write(template.render(path, template_values))
def post(self): user = User(name=self.request.get('name'), password=self.request.get('password'), email=self.request.get('email'), studentid=self.request.get('studentid'), college=College.get_by_id(int(self.request.get('college'))), admin=bool('') ) user.put() title='Thank you, ' + self.request.get('name') message='The new user was successfully created. Now you can share your resources. Enjoy.' method='get' action='/' value='continue' template_values = {'title': title, 'message': message, 'method': method, 'action': action, 'value': value} path = os.path.join(os.path.dirname(__file__), 'html/message.html') self.response.out.write(template.render(path, template_values))