def get_course_by_id(category_id, course_id):
try:
course = session.query(Course).filter_by(
id=course_id, category_id=category_id).one()
except:
return error_message(404, "Course not found.")
return data_message(200, {"Course": course.serialize},
"Successfully returned the selected course.")
def delete_course(category_id, course_id):
try:
course = session.query(Course).filter_by(
id=course_id, category_id=category_id).one()
except:
return error_message(404, "Cannot delete: Course not found.")
session.delete(course)
session.commit()
return data_message(200, None, "Course was successfully deleted.")
def delete_category(category_id):
try:
category = session.query(Category).filter_by(id=category_id).one()
except:
return error_message(404, "Cannot delete: Category not found.")
session.query(Course).filter_by(category_id=category_id).delete()
session.delete(category)
session.commit()
return data_message(200, None,
"Category and sub-courses was successfully deleted.")
def add_category():
name = request.form.get('name')
if name:
category = Category(name=name)
session.add(category)
session.commit()
else:
return error_message(400, "Course name is required.")
return data_message(200, {"Category": category.serialize},
"Successfully added a category.")
def get_courses_by_category_id(category_id):
try:
category = session.query(Category).filter_by(id=category_id).one()
except:
return error_message(404, "Category not found.")
courses = session.query(Course).filter_by(category_id=category_id).all()
return data_message(
200, {
"Category": category.serialize,
"Courses": [c.serialize for c in courses]
}, "Successfully returned all courses by given category.")
def gconnect():
code = request.data
try:
# Upgrade the authorization code into a credentials object
oauth_flow = flow_from_clientsecrets('client_secrets.json', scope='')
oauth_flow.redirect_uri = 'postmessage'
credentials = oauth_flow.step2_exchange(code)
except FlowExchangeError:
return error_message(401, "Failed to upgrade the authorization code.")
# Check if the access token is valid
access_token = credentials.access_token
url = ('https://www.googleapis.com/oauth2/v1/tokeninfo?access_token=%s' %
access_token)
h = httplib2.Http()
result = json.loads(h.request(url, 'GET')[1])
# If there was an error in the access token info, abort
if result.get('error') is not None:
return error_message(500, result.get('error'))
# Verify that the access token is used for the intended user.
gplus_id = credentials.id_token['sub']
if result['user_id'] != gplus_id:
return error_message(401,
"Token's user ID doesn't match give user ID.")
# Verify that the access token is valid for this app.
if result['issued_to'] != CLIENT_ID:
return error_message(401, "Token's client ID does not match app's.")
# Get user info
userinfo_url = "https://www.googleapis.com/oauth2/v1/userinfo"
params = {'access_token': credentials.access_token, 'alt': 'json'}
answer = requests.get(userinfo_url, params=params)
data = answer.json()
name = data["name"]
picture = data["picture"]
email = data["email"]
user = session.query(User).filter_by(email=email).first()
if not user:
user = User(username=name, picture=picture, email=email)
session.add(user)
session.commit()
# Make token
token = user.generate_auth_token(600)
return data_message(200, {'token': token.decode('ascii')},
"Successfully generated token."), 200
def edit_category(category_id):
try:
category = session.query(Category).filter_by(id=category_id).one()
except:
return error_message(404, "Cannot update: Category not found.")
name = request.form.get('name')
if name:
category.name = name
session.add(category)
session.commit()
else:
return error_message(400, "Course name is required.")
return data_message(200, {"Category": category.serialize},
"Successfully updated the category.")
def edit_course(category_id, course_id):
try:
course = session.query(Course).filter_by(
id=course_id, category_id=category_id).one()
except:
return error_message(404, "Cannot update: Course not found.")
if request.form.get(
'name'
): # if 'name' is a non-empty value then update else keep current value
course.name = request.form('name')
course.description = request.form.get('description')
course.img_url = request.form.get('img-url')
course.intro_video_url = request.form.get('intro-video-url')
session.add(course)
session.commit()
return data_message(200, {"Course": course.serialize},
"Successfully updated the course.")
def add_course(category_id):
try:
category = session.query(Category).filter_by(id=category_id).one()
except:
return error_message(
404, "Cannot add new course to this category: Category not found.")
name = request.form.get('name')
if name:
course = Course(name=name,
description=request.form.get('description'),
img_url=request.form.get('img-url'),
intro_video_url=request.form.get('intro-video-url'),
category_id=category.id)
session.add(course)
session.commit()
else:
return error_message(400, "Course name is required.")
return data_message(200, {"Course": course.serialize},
"Successfully added a course.")
def get_all_categories():
categories = session.query(Category).all()
return data_message(200, {"Categories": [c.serialize for c in categories]},
"Successfully returned all categories.")
