def run(self, **kwargs): from models.models import Role, User, Course with open('secrets.json', 'r') as secret_file: secrets = json.load(secret_file).get("ADMIN", {}) print("Adding Admin") admin = User(first_name=secrets.get("first_name", "Admin"), last_name=secrets.get("last_name", "User"), password=encrypt_password( secrets.get("password", "password")), confirmed_at=datetime.datetime.now(), active=True, email=secrets.get("email", "*****@*****.**")) db.session.add(admin) db.session.flush() db.session.add(Role(name='instructor', user_id=admin.id)) db.session.add(Role(name='admin', user_id=admin.id)) print("Adding default course") default_course = Course(name="Default Course", owner_id=admin.id, service="native") db.session.add(default_course) db.session.flush() db.session.add( Role(name='instructor', course_id=default_course.id, user_id=admin.id)) db.session.commit() print("Complete")
def addCourse(catalog_id): catalog = db_session.query(Catalog).filter( Catalog.catalog_id == catalog_id).one() school = db_session.query(School).filter( School.school_id == catalog.school_id).one() courses = db_session.query(Course).join(Catalog).filter( Catalog.catalog_id == catalog.catalog_id).all() form = initalizeCourseForm() if form.is_submitted() and form.validate_on_submit(): course = Course() course.catalog_id = catalog.catalog_id course.number = form.number.data course.name = form.name.data course.description = form.description.data course.credit_type_id = form.credit_type_id.data course.credits = form.credits.data db_session.add(course) db_session.commit() flash("Saved Successfully.") return redirect( url_for('catalog.viewCatalog', catalog_id=catalog.catalog_id)) return render_template('catalog/addCourse.html', form=form, catalog=catalog, school=school, courses=courses)
def find_course(page): finder = Finder() finder.set_data(page) name_pattern = '"(.+)"' names = finder.find_references(name_pattern) price_pattern = '(\d+) дн / (\d+) р.' prices = finder.find_references(price_pattern) i0 = 0 for name in names: print(name) c = Course(site_id=s.id, name=name) c.save() of1 = Offer(course_id=c.id, duration_hours=0, duration_days=prices[i0][0], price=prices[i0][1]) of2 = Offer(course_id=c.id, duration_hours=0, duration_days=prices[i0 + 1][0], price=prices[i0 + 1][1]) i0 += 2 of1.save() of2.save() return []
def __init__(self): self.newStudent_interest = Student_interest() self.newCourse_interest = Course_interest() self.newInterest = Interest() self.newCourse = Course() self.newStudent_subscription = Student_subscription() self.newStudent = Student() self.newInstructor = Instructor() self.newLesson = Lesson()
def __init__(self): if 'instructor' not in session: return redirect(url_for('instructor_login')) self.newInstructor = Instructor() self.newStudent_interest = Student_interest() self.newCourse_interest = Course_interest() self.newInterest = Interest() self.newCourse = Course() self.newStudent_subscription = Student_subscription()
def update_cart(self): #session['cart'] = [] data = {} data['loggedIn'] = False data['course_lessons'] = [] course = {} reverse_cart = [] if 'cart' not in session: session['cart'] = [] if 'reverse_cart' not in session: session['reverse_cart'] = [] if 'student' in session: data['loggedIn'] = True data['student'] = session['student'] if request.method == 'POST': newCourse = Course() course_id = request.form['course_id'] selCourse = newCourse.get_course_by_id(ObjectId(course_id)) course['title'] = selCourse['title'] course['cost'] = selCourse['price'] course['id'] = str(selCourse['_id']) if course not in session['cart']: session['cart'].append(course) session.modified = True #return jsonify(session) #return jsonify(session['cart']) if len(session['cart']) > 0: session['cart_total'] = 0 session['reverse_cart'] = [] for cart in session['cart']: reverse_cart.append(cart) session['cart_total'] = session['cart_total'] + cart[ 'cost'] rcount = len(reverse_cart) #return jsonify(reverse_cart) while (rcount > 0): session['reverse_cart'].append(reverse_cart.pop()) session.modified = True rcount = rcount - 1 return redirect( url_for('purchase_course', courseId=course['id'])) #return redirect(url_for('dashboard')) else: return redirect(url_for('dashboard')) else: return redirect(url_for('index'))
def __init__(self): if 'student' not in session: return redirect(url_for('index')) self.newStudent_interest = Student_interest() self.newCourse_interest = Course_interest() self.newInterest = Interest() self.newCourse = Course() self.newStudent_subscription = Student_subscription() self.newStudent = Student() self.newInstructor = Instructor() self.newLesson = Lesson() self.newStudent_question = Student_question() self.newQuestion_response = Question_response()
def __init__(self): if 'instructor' in session: self.loggedIn = True self.newStudent_interest = Student_interest() self.newCourse_interest = Course_interest() self.newInterest = Interest() self.newCourse = Course() self.newStudent_subscription = Student_subscription() self.newStudent = Student() self.newInstructor = Instructor() self.newLesson = Lesson() self.newStudent_question = Student_question() self.newQuestion_response = Question_response()
def __init__(self): if 'instructor' in session: self.loggedIn = True else: return redirect(url_for('instructor_login')) self.newStudent_interest = Student_interest() self.newCourse_interest = Course_interest() self.newInterest = Interest() self.newCourse = Course() self.newStudent_subscription = Student_subscription() self.newStudent = Student() self.newInstructor = Instructor() self.newLesson = Lesson() self.newStudent_question = Student_question() self.newQuestion_response = Question_response() self.uploadFolder = 'static/images/courses_cover_photos' self.allowedExtensions = set(['png', 'jpg', 'jpeg', 'gif', 'psd'])
def run(self, user_data_file, **kwargs): from models.models import Role, User, Course, Assignment print("Adding Admin") admin = User(first_name='Cory', last_name='Bart', password=encrypt_password('password'), confirmed_at=datetime.datetime.now(), active=True, email='*****@*****.**', gender='Male') db.session.add(admin) db.session.flush() db.session.add(Role(name='instructor', user_id=admin.id)) db.session.add(Role(name='admin', user_id=admin.id)) print("Adding some students for color") for student in ('Dan Tilden', 'Anamary Leal', 'Ellie Cayford'): first, last = student.split() email = '{}{}@vt.edu'.format(first[0].lower(), last.lower()) db.session.add(User(first_name=first, last_name=last, email=email)) print("Adding default course") default_course = Course(name="Default Course", owner_id=admin.id, service="blockpy") db.session.add(default_course) db.session.flush() print("Adding some assignments") assignment1 = Assignment(name="Example #1", body="a=b+c", course_id=default_course.id, owner_id=admin.id) db.session.add(assignment1) db.session.commit() print("Complete")
def run(self, user_data_file, **kwargs): from models.models import Role, User, Course, Assignment, CourseAssignment, AssignmentGroup, AssignmentGroupMembership print("Adding Admin") admin = User(first_name='Cory', last_name='Bart', password=encrypt_password('password'), confirmed_at=datetime.datetime.now(), active=True, email='*****@*****.**', gender='Male') db.session.add(admin) db.session.flush() db.session.add(Role(name='instructor', user_id=admin.id)) db.session.add(Role(name='admin', user_id=admin.id)) print("Adding some students for color") for student in ('Dan Tilden', 'Anamary Leal', 'Ellie Cayford'): first, last = student.split() email = '{}{}@vt.edu'.format(first[0].lower(), last.lower()) user = User(first_name=first, last_name=last, email=email) db.session.add(user) print("Adding default course") default_course = Course(name="Computational Thinking", owner_id=admin.id, service="native") db.session.add(default_course) db.session.flush() print("Adding public course") public_course = Course(name="Public Course", owner_id=admin.id, service="native", visibility='public') db.session.add(public_course) db.session.flush() db.session.add( Role(name='instructor', course_id=public_course.id, user_id=admin.id)) print("Adding local Canvas course") canvas_course = Course( name="Computational Thinking - Dev", owner_id=admin.id, service='canvas', visibility='private', external_id='cbdd860576c6c08ccb998b93009305c318bd269b') db.session.add(canvas_course) db.session.flush() print("Adding CS1 course") cs1_course = Course(name="CS 1", owner_id=user.id, service='canvas', visibility='private') db.session.add(cs1_course) db.session.flush() print("Adding some assignments") assignment1 = Assignment(name="Assignment #1", body="a=b+c", course_id=default_course.id, owner_id=admin.id) db.session.add(assignment1) assignment2 = Assignment(name="Assignment #2", body="Figure it out!", course_id=default_course.id, owner_id=admin.id) db.session.add(assignment2) assignment3 = Assignment(name="Assignment #3", body="Clue", course_id=default_course.id, owner_id=admin.id) db.session.add(assignment3) ca1 = CourseAssignment(course_id=public_course.id, assignment_id=assignment1.id) db.session.add(ca1) ca2 = CourseAssignment(course_id=public_course.id, assignment_id=assignment2.id) db.session.add(ca2) ag1 = AssignmentGroup(name="Day 1 - Decision", course_id=default_course.id) db.session.add(ag1) ag2 = AssignmentGroup(name="Day 2 - Iteration", course_id=default_course.id) db.session.add(ag2) db.session.commit() db.session.add( AssignmentGroupMembership(assignment_group_id=ag1.id, assignment_id=assignment1.id)) db.session.add( AssignmentGroupMembership(assignment_group_id=ag1.id, assignment_id=assignment2.id)) db.session.add( AssignmentGroupMembership(assignment_group_id=ag2.id, assignment_id=assignment3.id)) db.session.commit() print("Complete")
def __init__(self): self.newStudent_interest = Student_interest() self.newCourse_interest = Course_interest() self.newInterest = Interest() self.newCourse = Course() self.newStudent_subscription = Student_subscription()
'days': item[1], 'hours': item[0], 'full_price': price[i0], 'special_price': price[i0 + 1] }) i0 += 2 return result res = bp.start_parse(find_links, options=(1, 4)) s = Site(name='pedobychenie.rf') s.save() progress = 0 max_ = len(res) for link, name in res: progress += 1 print(f'{round(progress / max_ * 100, 2)}%') bp.set_url(f'https://xn--90afccar8afg8b5b.xn--p1ai{link}') prices = bp.start_parse(find_price, False) c = Course(site_id=s.id, name=name) c.save() for price in prices: Offer(course_id=c.id, duration_hours=price['hours'], duration_days=price['days'], price=price['full_price']).save()
def get(): db_session.query(Course).delete() db_session.commit() test = ["社会数理入門Ⅰ", "社会数理入門Ⅱ", "数理情報Ⅰ", "数理情報Ⅱ", "社会数理Ⅰ", "社会数理Ⅱ", "ウェルカム・レクチャー", "キャリアデザイン・セミナー"] options = webdriver.ChromeOptions() options.add_argument('--headless') options.add_argument('--no-sandbox') options.add_argument('--disable-dev-shm-usage') driver = webdriver.Chrome('chromedriver', options=options) driver.implicitly_wait(10) for j in test: CourseTitle = j driver.get("http://syllabus.aoyama.ac.jp/") driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() test2 = ["フレッシャーズ・セミナー", "自己理解", "現代社会の諸問題", "科学・技術の視点", "歴史と人間"] for i in test2: CourseTitle = i driver.get("http://syllabus.aoyama.ac.jp/") driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_rptYB_YB_0').click() driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() driver.find_element_by_id('CPH1_rptYB_YB_0').click() driver.find_element_by_id('CPH1_rptYB_YB_1').click() if (CourseTitle != "フレッシャーズ・セミナー"): driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() else: driver.find_element_by_id('CPH1_rptCP_CP_0').click() driver.find_element_by_id('CPH1_btnKensaku').click() result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = test[b+2:b+3] db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() driver.find_element_by_id('CPH1_rptCP_CP_0').click() driver.find_element_by_id('CPH1_rptCP_CP_1').click() driver.find_element_by_id('CPH1_btnKensaku').click() result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = test[b+2:b+3] db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() driver.find_element_by_id('CPH1_rptYB_YB_1').click() driver.find_element_by_id('CPH1_rptYB_YB_2').click() driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() driver.find_element_by_id('CPH1_rptYB_YB_2').click() driver.find_element_by_id('CPH1_rptYB_YB_3').click() driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() driver.find_element_by_id('CPH1_rptYB_YB_3').click() driver.find_element_by_id('CPH1_rptYB_YB_4').click() driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() CourseTitle = "健康・スポーツ演習" # 前期月 for i in range(2): driver.get("http://syllabus.aoyama.ac.jp/") semester_element = driver.find_element_by_id('CPH1_GKB') semester_select_element = Select(semester_element) driver.find_element_by_id('CPH1_rptCP_CP_' + str(i)).click() semester_select_element.select_by_value('1.1.12') driver.find_element_by_id('CPH1_rptYB_YB_0').click() driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() # 後期月 for i in range(2): driver.get("http://syllabus.aoyama.ac.jp/") semester_element = driver.find_element_by_id('CPH1_GKB') semester_select_element = Select(semester_element) driver.find_element_by_id('CPH1_rptCP_CP_' + str(i)).click() semester_select_element.select_by_value('1.2.12') driver.find_element_by_id('CPH1_rptYB_YB_0').click() driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() # 前期火 for i in range(2): driver.get("http://syllabus.aoyama.ac.jp/") semester_element = driver.find_element_by_id('CPH1_GKB') semester_select_element = Select(semester_element) driver.find_element_by_id('CPH1_rptCP_CP_' + str(i)).click() semester_select_element.select_by_value('1.1.12') driver.find_element_by_id('CPH1_rptYB_YB_1').click() driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() # 後期火 for i in range(2): driver.get("http://syllabus.aoyama.ac.jp/") semester_element = driver.find_element_by_id('CPH1_GKB') semester_select_element = Select(semester_element) driver.find_element_by_id('CPH1_rptCP_CP_' + str(i)).click() semester_select_element.select_by_value('1.2.12') driver.find_element_by_id('CPH1_rptYB_YB_1').click() driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() # 前期水 for i in range(2): driver.get("http://syllabus.aoyama.ac.jp/") semester_element = driver.find_element_by_id('CPH1_GKB') semester_select_element = Select(semester_element) driver.find_element_by_id('CPH1_rptCP_CP_' + str(i)).click() semester_select_element.select_by_value('1.1.12') driver.find_element_by_id('CPH1_rptYB_YB_2').click() driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() # 後期水 for i in range(2): driver.get("http://syllabus.aoyama.ac.jp/") semester_element = driver.find_element_by_id('CPH1_GKB') semester_select_element = Select(semester_element) driver.find_element_by_id('CPH1_rptCP_CP_' + str(i)).click() semester_select_element.select_by_value('1.2.12') driver.find_element_by_id('CPH1_rptYB_YB_2').click() driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() # 前期木 for i in range(2): driver.get("http://syllabus.aoyama.ac.jp/") semester_element = driver.find_element_by_id('CPH1_GKB') semester_select_element = Select(semester_element) driver.find_element_by_id('CPH1_rptCP_CP_' + str(i)).click() semester_select_element.select_by_value('1.1.12') driver.find_element_by_id('CPH1_rptYB_YB_3').click() driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() # 後期木 for i in range(2): driver.get("http://syllabus.aoyama.ac.jp/") semester_element = driver.find_element_by_id('CPH1_GKB') semester_select_element = Select(semester_element) driver.find_element_by_id('CPH1_rptCP_CP_' + str(i)).click() semester_select_element.select_by_value('1.2.12') driver.find_element_by_id('CPH1_rptYB_YB_3').click() driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() # 前期金 for i in range(2): driver.get("http://syllabus.aoyama.ac.jp/") semester_element = driver.find_element_by_id('CPH1_GKB') semester_select_element = Select(semester_element) driver.find_element_by_id('CPH1_rptCP_CP_' + str(i)).click() semester_select_element.select_by_value('1.1.12') driver.find_element_by_id('CPH1_rptYB_YB_4').click() driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() # 後期金 for i in range(2): driver.get("http://syllabus.aoyama.ac.jp/") semester_element = driver.find_element_by_id('CPH1_GKB') semester_select_element = Select(semester_element) driver.find_element_by_id('CPH1_rptCP_CP_' + str(i)).click() semester_select_element.select_by_value('1.2.12') driver.find_element_by_id('CPH1_rptYB_YB_4').click() driver.find_element_by_id('CPH1_KM').send_keys(CourseTitle) driver.find_element_by_id('CPH1_btnKensaku').click() html = driver.page_source.encode('utf-8') soup = BeautifulSoup(html, "html.parser") result = int(soup.select("#CPH1_lblHitMsg")[0].getText()) if (result != 0): for i in range(result): test = soup.select( "#CPH1_gvw_kensaku_lblJigen_" + str(i))[0].get_text() a = test.find("[") b = test.find("]") c = test.find("(") db_campus = test[a+1:b-a] db_day = test[b+1:b+2] db_time = mojimoji.zen_to_han(test[b+2:b+3]) db_semester = test[c+1:c+2] db_title = soup.select( "#CPH1_gvw_kensaku_lblKamoku_" + str(i))[0].get_text() db_instructer = soup.select( "#CPH1_gvw_kensaku_lblKyouin_" + str(i))[0].get_text() db_detail = "http://syllabus.aoyama.ac.jp/" + \ soup.select("#CPH1_gvw_kensaku_lnkShousai_" + str(i))[0].get("href") content = Course(db_day, db_time, db_campus, db_semester, db_title, db_instructer, db_detail, datetime.now()) db_session.add(content) db_session.commit() # new 変更! return render_template("index.html", getDB=False, errorMsg="", classroom=["A", "B", "C", "D", "E", "F"], language=["フランス", "ドイツ", "スペイン", "中国", "ロシア", "韓国"])