def setup(teacher):
title = curses.wrapper(get_input, 'Enter your course title: ')
Course.insert({
Course.title: title,
Course.teacher: teacher,
}).execute()
curses.wrapper(show_message, 'your course request successfully saved!')
def create_new_course(payload):
courses = []
result = {
"success": True,
}
try:
body = json.loads(request.data)
name = body['name']
description = body['description']
price = body['price']
new_course = Course(name=name,
description=description,
price=price)
new_course.insert()
courses.append(new_course.format())
except Exception as e:
print(e)
abort(500)
result['courses'] = courses
return jsonify(result)
def create_courses():
body = request.get_json()
crs_title = body.get('title')
crs_code = body.get('code')
crs_desc = body.get('desc')
crs_book = body.get('book')
crs_lec = int(body.get('lec'))
crs_room = int(body.get('room'))
error = False
try:
# instantiate course object
crs = Course(crs_code, crs_title, crs_desc, crs_book, crs_lec,
crs_room)
crs.insert()
courses = Course.query.order_by(Course.crs_id).all()
courses_list = [course.format for course in courses]
except Exception as e:
db.session.rollback()
error = True
print(sys.exc_info())
finally:
db.session.close()
if error:
abort(422)
else:
return redirect('/courses')
def add_course(permission):
body = request.get_json()
try:
course = Course(body['course_name'], body['domain_id'],
body['platform_id'], body['website'],
body['price_per_month'], body['duration_months'])
course.insert()
return jsonify({'success': True, 'course_id': course.id})
except:
abort(422)
def add_course(request):
course = request.get_json()
title = course['title']
description = course['description']
duration = course['duration']
tuition = course['tuition']
minimum_skill = course['minimumSkill']
scholarships_available = course['scholarshipsAvailable']
bootcamp_id = course['bootcampId']
upvotes = rand_upvote()
new_course = Course(title, description, duration, tuition, minimum_skill,
scholarships_available, upvotes, bootcamp_id)
print(course)
new_course.insert()
return new_course
def create_courses(payload):
print(payload.get('sub'))
body = request.get_json()
new_name = body.get('name', None)
new_state = body.get('state', None)
new_image_link = body.get('image_link', None)
try:
course = Course(name=new_name,
state=new_state,
image_link=new_image_link)
course.insert()
added_id = Course.query.filter(
Course.name == new_name).one_or_none().format().get('id')
print('added_id', added_id)
return jsonify({'added_name': new_name})
except BaseException:
abort(422)
def db_test_init():
bootcamp = Bootcamp(
"Devworks Bootcamp", "Devworks is a full stack JavaScript Bootcamp " +
"located in the heart of Boston that focuses " +
"on the technologies you need to get a high " +
"paying job as a web developer", "https://devworks.com",
"(111) 111-1111", "*****@*****.**",
"233 Bay State Rd Boston MA 02215",
["Web Development", "UI/UX", "Business"], False, 89, "/img-2.jpg")
bootcamp.insert()
course = Course(
"Full Stack Web Development",
"In this course you will learn full stack " +
"web development, first learning all about " +
"the frontend with HTML/CSS/JS/Vue and then " +
"the backend with Node.js/Express/MongoDB", 12, 10000, "intermediate",
True, 93, 1)
course.insert()
def post(self):
parser = reqparse.RequestParser()
parser.add_argument('cid', type=str)
parser.add_argument('cname', type=str)
parser.add_argument('chours', type=int)
parser.add_argument('credit', type=float)
parser.add_argument('precid', type=str)
args = parser.parse_args()
for key,value in args.iteritems():
if key == 'precid':
continue
if value is None:
return {'error':"Please input field: %s" % key},400
course = Course(**args)
try:
insert_row = course.insert()
if insert_row == 1:
return course,201
except IntegrityError ,e:
#insert duplicate primary_key entry
if e[0] == 1062:
return {'primary error': e[1]},400
def seed():
"""Seed the database."""
#level 1
course1 = Course(course_id='ARAB 100', name='Writing Skills', level=1)
course2 = Course(course_id='CHEM101',
name='General Chemistry (1)',
level=1)
course3 = Course(course_id='ENGS 100', name='English', level=1)
course4 = Course(course_id='MATH 101',
name='Differential Calculus',
level=1)
#level 2
course5 = Course(course_id='CI 101', name='University Skills', level=2)
course6 = Course(course_id='CT 101', name='IT Skills', level=2)
course7 = Course(course_id='ENGS 110', name='English', level=2)
course8 = Course(course_id='ENT 101', name='Entrepreneurship', level=2)
course9 = Course(course_id='EPH 101',
name='Fitness and Health Education',
level=2)
course10 = Course(course_id='STAT 101',
name='An Introduction to Probability & Statistics',
level=2)
#level 3
course11 = Course(course_id='CSC 111',
name='Computer Programming (1)',
level=3)
course12 = Course(course_id='MATH106', name='INTEGRAL CALCULUS', level=3)
course13 = Course(course_id='MATH151',
name='DISCRETE MATHEMATICS',
level=3)
course14 = Course(course_id='PHYS103', name='GENERAL PHYSICS (1)', level=3)
#level 4
course15 = Course(course_id='CENX303',
name='Computer Communications & Networks',
level=4)
course16 = Course(course_id='CSC 113',
name='Computer Programming (2)',
level=4)
course17 = Course(course_id='MATH244', name='Linear Algebra', level=4)
course18 = Course(course_id='PHYS104', name='GENERAL PHYSICS (2)', level=4)
course19 = Course(course_id='SWE 211',
name='Introduction to Software Engineering',
level=4)
#level 5
course20 = Course(course_id='CSC 212', name='Data Structures', level=5)
course21 = Course(course_id='CSC 220',
name='Computer Organization',
level=5)
course22 = Course(course_id='SWE 312',
name='Software Requirements Engineering',
level=5)
course23 = Course(course_id='SWE 314',
name='Software Security Engineering',
level=5)
#level 6
course24 = Course(course_id='CSC 227', name='OPERATING SYSTEMS', level=6)
course25 = Course(course_id='IS 230',
name='INTRODUCTION TO DATABASE SYSTEMS',
level=6)
course26 = Course(course_id='SWE 321',
name='Software Design & Architecture',
level=6)
course27 = Course(course_id='SWE 333',
name='Software Quality Assurance',
level=6)
course28 = Course(course_id='SWE 381',
name='Web Application Development',
level=6)
#level 7
course29 = Course(course_id='IC 107', name='Professional Ethics', level=7)
course30 = Course(course_id='SWE 434',
name='Software Testing and Validation',
level=7)
course31 = Course(course_id='SWE 444',
name='Software Construction Laboratory',
level=7)
course32 = Course(
course_id='SWE 477',
name='Software Engineering Code of Ethics & Professional Practice',
level=7)
course33 = Course(course_id='SWE 479', name='Practical Training', level=7)
course34 = Course(course_id='SWE 482',
name='Human-Computer Interaction',
level=7)
course35 = Course(course_id='SWE 496',
name='Graduation Project (1)',
level=7)
#level 8
course36 = Course(course_id='IC 108', name='Current Issues', level=8)
course37 = Course(course_id='SWE 455',
name='Software Maintenance and Evolution',
level=8)
course38 = Course(course_id='SWE 466',
name='Software Project Management',
level=8)
course39 = Course(course_id='SWE 497',
name='Graduation Project (2)',
level=8)
course1.insert()
course2.insert()
course3.insert()
course4.insert()
course5.insert()
course6.insert()
course7.insert()
course8.insert()
course9.insert()
course10.insert()
course11.insert()
course12.insert()
course13.insert()
course14.insert()
course15.insert()
course16.insert()
course17.insert()
course18.insert()
course19.insert()
course20.insert()
course21.insert()
course22.insert()
course23.insert()
course24.insert()
course25.insert()
course26.insert()
course27.insert()
course28.insert()
course29.insert()
course30.insert()
course31.insert()
course32.insert()
course33.insert()
course34.insert()
course35.insert()
course36.insert()
course37.insert()
course38.insert()
course39.insert()
