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 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_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_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_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 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_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 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 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 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_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_update2(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(3, c))
#print(db.select_all_course()[3].course_name)
self.assertFalse(db.update_course_table(None, None))
self.assertFalse(db.update_course_table(1, None))
self.assertFalse(db.update_course_table(None, c))
def test_insertmany3(self):
s = None
self.assertFalse(db.insert_courses_table(s))
def test_insertmany2(self):
s = []
self.assertFalse(db.insert_courses_table(s))
