def initcourse():
course1 = Course(course_name="PYTHON",
course_type="PYTHON",
course_url="https//www.4399.com",
platform_name="4399")
course2 = Course(course_name="C++",
course_type="C",
course_url="https//www.7k7k.com",
platform_name="7k7k")
course3 = Course(course_name="JAVA",
course_type="C",
course_url="https//www.google.com",
platform_name="4399")
course4 = Course(course_name="C",
course_type="C",
course_url="http://baiadu.com",
platform_name="baidu")
initcourses.append(course1)
initcourses.append(course2)
initcourses.append(course3)
initcourses.append(course4)
db.drop_course_table()
db.init_course_table()
mylist = getInfoFromImmocForPython()
print(initcourses) #自己随便写的测试用课程对象列表
print(mylist) #爬虫爬取的信息组成的课程对象列表
db.insert_courses_table(mylist)
# db.insert_courses_table(initcourses)
return db.select_all_course()
def test_deleteid3(self):
a = Course(course_name="这是一个测试",
course_type="ss",
course_url="4399",
platform_name="")
b = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399d",
platform_name="rt")
s = [a, b]
db.drop_course_table()
db.init_course_table()
db.insert_courses_table(s)
# print(db.select_all_course()[0].id)
self.assertFalse(db.delete_course_table2(None))
a = Course(course_name="这是一个测试",
course_type="ss",
course_url="4399",
platform_name="")
b = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399d",
platform_name="rt")
s = [a, b]
db.drop_course_table()
db.init_course_table()
db.insert_courses_table(s)
# print(db.select_all_course()[0].id)
self.assertFalse(db.delete_course_table2(None))
def test_insertmany6(self):
a = Course(course_name="这是一个测试",
course_type="ss",
course_url="4399d",
platform_name="")
b = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399d",
platform_name="rt")
s = [a, b]
self.assertFalse(db.insert_courses_table(s))
def test_delete4(self):
a = Course(course_name="这是一个测试",
course_type="ss",
course_url="4399",
platform_name="")
b = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399d",
platform_name="rt")
s = [a, b]
db.insert_courses_table(s)
self.assertFalse(db.delete_course_table(None))
def test_selectall1(self):
a = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399",
platform_name="s")
b = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399d",
platform_name="rt")
s = [a, b]
db.insert_courses_table(s)
self.assertEqual(db.select_all_course()[0].course_name, a.course_name)
def test_selectplatformname4(self):
a = Course(course_name="这是一个测试",
course_type="ss",
course_url="4399",
platform_name="")
b = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399d",
platform_name="rt")
s = [a, b]
db.insert_courses_table(s)
self.assertEqual(db.select_platform_name(None), None)
def test_selectplatformname2(self):
a = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399",
platform_name="safsd")
b = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399d",
platform_name="rt")
s = [a, b]
db.insert_courses_table(s)
self.assertEqual(
db.select_platform_name("fs")[0].course_type, a.course_type)
def many_to_many_table_add_data(self):
"""
多对多表新增
"""
course_1 = Course(course_name='语文')
course_2 = Course(course_name='数学')
course_1.student_list = [
Student(student_name="张三"),
Student(student_name="李四"),
]
course_2.student_list = [
Student(student_name="王二")
]
self.session.add_all([course_1, course_2])
self.session.commit()
def test_insert9(self):
a = Course(course_name="hh",
course_type="ss",
course_url="4399",
platform_name="sss")
db.insert_course_table(a)
self.assertFalse(db.insert_course_table(a))
def test_selectplatformcoursename2(self):
a = Course(course_name="物理",
course_type="sss",
course_url="4399",
platform_name="s")
b = Course(course_name="化学",
course_type="sss",
course_url="4399d",
platform_name="rt")
c = Course(course_name="高数",
course_type="sss",
course_url="4399s",
platform_name="rt")
s = [a, b, c]
db.insert_courses_table(s)
self.assertEqual(db.select_platform_course_name("rt", " "), [])
def test_insert6(self):
a = Course(course_name="这是一个测试这是一个测试一个测试",
course_type="ss",
course_url="4399",
platform_name="sss")
self.assertTrue(db.insert_course_table(a))
def test_insert2(self):
a = Course(course_name="",
course_type="",
course_url="",
platform_name="")
self.assertTrue(db.insert_course_table(a))
def add_course():
"""Add a running course to the database"""
print "/new-course called"
user_id = session["user_id"]
print user_id
course = request.form.get("course")
polyline = request.form.get("overview-polyline")
# print "polyline is ", polyline
directions_text = request.form.get("directions-text")
directions_distance = request.form.get("directions-distance")
start_address = request.form.get("start-address")
end_address = request.form.get("end-address")
new_course = Course(user_id=user_id, course_name=course,
add_date=datetime.now(),
start_lat=request.form.get("start-lat"),
start_long=request.form.get("start-long"),
end_lat=request.form.get("end-lat"),
end_long=request.form.get("end-long"),
course_distance=request.form.get("distance"),
favorite=request.form.get("favorite"),
polyline=polyline,
directions_text=directions_text,
directions_distance=directions_distance,
start_address=start_address,
end_address=end_address
)
new_course.add()
return "Course %s has been saved to your courses" % course
def get_course_list(self) -> Iterator[Course]:
"""Gets the list of available courses.
:raises PodcastProviderError: If an error occurs getting the course list.
:return: A list of URLs for each course podcast home.
"""
# Get list of courses from video page
get_video_service_base = self.session.get(self.video_service_base_url +
"/lectures")
# Check status code valid
if get_video_service_base.status_code != 200:
raise PodcastProviderError(
f"Could not get video service - Service responded with status code "
f"{get_video_service_base.status_code}")
# Status code valid, extract courses
get_video_service_base_soup = BeautifulSoup(
get_video_service_base.content, features="html.parser")
course_items_html = get_video_service_base_soup.find("nav", {"id": "sidebar-nav"}).ul.contents[3]\
.find_all("li", {"class": "series"})
return map(
lambda x: Course(x.a.string, x.a["href"], x.a.string[-7:].replace(
"/", "-")), course_items_html)
async def getAllCousWS():
# 载入 Course
# courses = []
# 初始化 SQL
rs = await handler.getAllCouse()
# 将结果 模型化并返回
res = []
if rs is not None:
for i in rs:
res.append(Course(**i))
# 将 course list 转变为 Cws list
cous = []
for item in res:
cous.append(CourseWithStudents(course=item, students=[]))
# 载入 Students
for item in cous:
# 初始化 SQL
rs = await handler.getStuGrade(item.course.cno)
# 将结果 模型化并返回
if rs is not None:
for i in rs:
item.students.append(Student(**i))
# 返回 Cws
return cous
def test_delete3(self):
a = Course(course_name="这是一个测试",
course_type="ss",
course_url="4399",
platform_name="")
b = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399d",
platform_name="rt")
s = [a, b]
db.insert_courses_table(s)
c = Course(course_name="测试",
course_type="ssds",
course_url="sjw",
platform_name="t")
self.assertTrue(db.delete_course_table(c))
def select_platform_course_name(platform_name, course_name):
if platform_name == None or course_name == None:
return None
if course_name == "":
return None
sql = "SELECT * FROM COURSE WHERE platform_name = %s and (course_name like %s or course_name like %s or course_name like %s or course_name= %s);"
courses = []
conn = set_conect()
cursor = conn.cursor()
try:
cursor.execute(sql,
(platform_name, '%' + course_name + '%',
'%' + course_name, course_name + '%', course_name))
conn.commit()
result = cursor.fetchall()
for row in result:
c = Course(course_name=row[1],
course_type=row[2],
course_url=row[3],
platform_name=row[4])
c.id = row[0]
courses.append(c)
except:
print("select_platform_name error")
return None
finally:
cursor.close()
conn.close()
return courses
def test_selectplatformname3(self):
a = Course(course_name="这是一个测试",
course_type="ss",
course_url="4399",
platform_name="f")
b = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399d",
platform_name="rt")
c = Course(course_name="这是s测试",
course_type="325s",
course_url="439d",
platform_name="y")
s = [a, b]
db.insert_courses_table(s)
self.assertEqual(db.select_platform_name(c.platform_name), [])
def delc():
if request.method == "POST":
course = Course(request.form['cid'], '')
course.delete_course()
return render_template('home.html')
else:
return render_template('delcourse.html')
def updatec():
if request.method == 'POST':
course = Course(request.form['cid'], request.form['cname'])
course.update_course()
return render_template('home.html')
else:
return render_template('updatecourse.html')
def add_course():
code = request.json.get('code')
name = request.json.get('name')
location = request.json.get('location')
time = request.json.get('time')
resp = {}
msg = 'Add course successful'
if (g.user.role != 0):
# abort(400)
msg = 'User has no authority'
elif (not code or not name or not location or not time):
msg = 'Course message lost'
else:
course = Course(code=code,
name=name,
location=location,
time=time,
teacher_id=g.user.id)
if (Course.query.filter_by(code=code).first() is not None):
msg = 'The course already exists'
# abort(400)
else:
db.session.add(course)
db.session.commit()
resp['msg'] = msg
return get_response(resp)
def test_delete5(self):
a = Course(course_name="这是一个测试",
course_type="ss",
course_url="4399",
platform_name="")
db.delete_all_course_table()
self.assertTrue(db.delete_course_table(a))
def test_insertmany5(self):
a = Course(course_name="这一个测试",
course_type="ss",
course_url="4399",
platform_name="")
b = None
s = [a, b]
self.assertFalse(db.insert_courses_table(s))
def save(self):
# get the course values from the ui
title = self.view.get_title()
subject = self.view.get_subject()
# store the new values in the course variable
course = Course(-1, self.semester, title, subject)
# save the changes into the db
BGModelController.add_course(course)
def generateCourse(name):
course = Course()
course.coursetitle = name
course.description = ("Welcome to the course of " + name)
course.credits = random.randint(1, 5)
course.studyID = random.choice(studies).studyID
course.teacherID = random.choice(teachers).teacherID
course.insert()
return course
def test_insert7(self):
a = Course(
course_name=
"这是ssssssssssssssssssssssssssssssssssssdddddddddddddddddddddddddddddddddddddddddddddd一个测试这s是一个测试一个测试",
course_type="ss",
course_url="4399",
platform_name="sss")
self.assertFalse(db.insert_course_table(a))
def test_update1(self):
a = Course(course_name="这是一个测试",
course_type="ss",
course_url="4399",
platform_name="")
b = Course(course_name="这是一个测试",
course_type="sss",
course_url="4399d",
platform_name="rt")
s = [a, b]
c = Course(course_name="这个测试",
course_type="sss",
course_url="4399",
platform_name="r")
db.drop_course_table()
db.init_course_table()
db.insert_courses_table(s)
self.assertTrue(db.update_course_table(1, c))
def test_insert4(self):
a = Course(
course_name=
"aaaaaaaaaa55555555555555555555ssssssssssssssssssssssssssssssssssssaasssss",
course_type="ss",
course_url="4399",
platform_name="sss")
self.assertFalse(db.insert_course_table(a))
async def getAllCous():
# 初始化 SQL
rs = await handler.getAllCouse()
# 将结果 模型化并返回
res = []
if rs is not None:
for i in rs:
res.append(Course(**i))
return res
def add_course(fields):
if 'role' not in session or not session['role'] == 'admin':
raise APIError('Insufficient permission', status_code=403)
course = Course()
for key, value in fields.items():
course.__setattr__(key, value)
db.session.add(course)
db.session.commit()
return course.dict
