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 DISTINCT * 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 select_course_type_accuracy(course_type):
if course_type == None:
return None
if course_type == "":
return []
sql = "SELECT DISTINCT * FROM COURSE WHERE course_type= %s;"
courses = []
conn = set_conect()
cursor = conn.cursor()
try:
cursor.execute(sql, (course_type))
result = cursor.fetchall()
conn.commit()
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_course_type_accuracy error")
return None
finally:
cursor.close()
conn.close()
return courses
def select_all_course():
sql = "SELECT DISTINCT * FROM COURSE ORDER BY course_type;"
courses = []
conn = set_conect()
cursor = conn.cursor()
try:
cursor.execute(sql)
conn.commit()
result = cursor.fetchall()
for row in result:
c = Course(course_name=str(row[1]),
course_type=str(row[2]),
course_url=str(row[3]),
platform_name=str(row[4]))
c.id = row[0]
courses.append(c)
except:
print("select_all_course error")
return None
finally:
cursor.close()
conn.close()
return courses