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=["フランス", "ドイツ", "スペイン", "中国", "ロシア", "韓国"])
