-
Notifications
You must be signed in to change notification settings - Fork 4
/
tcu_course_crawler.rb
106 lines (91 loc) · 3.83 KB
/
tcu_course_crawler.rb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
module CourseCrawler::Crawlers
class TcuCourseCrawler < CourseCrawler::Base
def initialize year: nil, term: nil, update_progress: nil, after_each: nil
@year = year || current_year
@term = term || current_term
@update_progress_proc = update_progress
@after_each_proc = after_each
@query_url = 'https://sap.tcu.edu.tw/cosintro/qry_smtrcos.asp'
@ic = Iconv.new('utf-8//IGNORE//translit', 'big5')
end
def courses
@courses = []
r = RestClient.get(@query_url)
doc = Nokogiri::HTML(@ic.iconv(r))
doc.css('select[name="cos_dept"] option').map{|opt| [opt[:value], opt.text]}.each do |dept_c, dept_n|
r = RestClient.post("https://sap.tcu.edu.tw/cosintro/qry_smtrcos_list.asp", {
"cos_smtr" => "#{@year-1911}#{@term}",
"qrytype" => "1",
"cos_dept" => dept_c,
"cos_year" => "%",
# "tchname" => "",
# "day1" => "",
# "times" => "",
# "cosname" => "",
# "tchname2" => "",
})
doc = Nokogiri::HTML(@ic.iconv(r))
doc.css('table tr[bgcolor="White"]').map{|tr| tr}.each do |tr|
data = tr.css('td:not(:last-child)').map{|td| td.text}
# data[9] = tr.css('td:last-child')
time_period_regex = /[星][期](?<day>\d)[第](?<period>\d+[~∼]?\d?\d?)/
course_time_location = Hash[ data[8].scan(time_period_regex) ]
# 把 course_time_location 轉成資料庫可以儲存的格式
course_days, course_periods, course_locations = [], [], []
course_time_location.each do |k, v|
(v.split(/[~∼]/)[0].to_i..v.split(/[~∼]/)[1].to_i).each do |i|
next if i > 8 # 不要處裡進修部
course_days << k[0].to_i
course_periods << i # 1~12
course_locations << data[7]
end
end
course = {
year: @year, # 西元年
term: @term, # 學期 (第一學期=1,第二學期=2)
name: data[3].split('開課教師:')[0], # 課程名稱
lecturer: data[3].split('開課教師:')[1], # 授課教師
credits: data[5].to_i, # 學分數
serial_no: data[0],
code: "#{@year}-#{@term}-#{data[2]}",
general_code: data[2], # 選課代碼
# url: data[9], # 課程大綱之類的連結(抓下來的是HTML語法,網頁要用POST的才能顯示)
required: data[6].include?('必'), # 必修或選修
department: dept_n + data[4], # 開課系所
# department_code: dept_c,
day_1: course_days[0],
day_2: course_days[1],
day_3: course_days[2],
day_4: course_days[3],
day_5: course_days[4],
day_6: course_days[5],
day_7: course_days[6],
day_8: course_days[7],
day_9: course_days[8],
period_1: course_periods[0],
period_2: course_periods[1],
period_3: course_periods[2],
period_4: course_periods[3],
period_5: course_periods[4],
period_6: course_periods[5],
period_7: course_periods[6],
period_8: course_periods[7],
period_9: course_periods[8],
location_1: course_locations[0],
location_2: course_locations[1],
location_3: course_locations[2],
location_4: course_locations[3],
location_5: course_locations[4],
location_6: course_locations[5],
location_7: course_locations[6],
location_8: course_locations[7],
location_9: course_locations[8],
}
@after_each_proc.call(course: course) if @after_each_proc
@courses << course
end
end
@courses
end
end
end