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