def mysql_data(data):
handle = MysqlHandle()
for mysqlData in data:
for courseData in mysqlData:
sql="INSERT INTO cs_cnow(cid,ctime,teacher,classroom,week,class) VALUES('%s','%s','%s','%s','%s','%s')" %(courseData[0],courseData[1],courseData[2],courseData[3],courseData[4],courseData[5])
if handle.execute_sql(sql) == False :
print "error"
return
handle.close_sql()
preResult.append((cid, preRow, _group))
_group += 1
return preResult
else:
return False
if __name__ == "__main__":
handle = MysqlHandle()
for row in read_file():
courseInfo = get_course_info(get_html(courseurl % row[1]))
sql = sql = (
"INSERT INTO cs_course(cid,examway,credit,faculty,cname,detail) VALUES('%s','%s','%s','%s','%s','%s')"
% (
courseInfo["cid"],
courseInfo["examway"],
courseInfo["credit"],
courseInfo["faculty"],
courseInfo["cname"],
courseInfo["detail"],
)
)
if handle.execute_sql(sql) == False:
print "error"
pre = get_pre(get_html(courseurl % row[1]), courseInfo["cid"])
if pre != False:
for row in pre:
sql = "INSERT INTO cs_pre(aim,pre,_group) VALUES('%s','%s','%s')" % (row[0], row[1], row[2])
if handle.execute_sql(sql) == False:
print "error"
