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))
