心智圖資源庫 有效票價統計
這是一篇關於有效票價統計的心智圖,主要內容包括:流程,資料庫,執行方式。歡迎按讚收藏~
編輯於2024-03-08 13:58:29This is a mind map about bacteria, and its main contents include: overview, morphology, types, structure, reproduction, distribution, application, and expansion. The summary is comprehensive and meticulous, suitable as review materials.
This is a mind map about plant asexual reproduction, and its main contents include: concept, spore reproduction, vegetative reproduction, tissue culture, and buds. The summary is comprehensive and meticulous, suitable as review materials.
This is a mind map about the reproductive development of animals, and its main contents include: insects, frogs, birds, sexual reproduction, and asexual reproduction. The summary is comprehensive and meticulous, suitable as review materials.
This is a mind map about bacteria, and its main contents include: overview, morphology, types, structure, reproduction, distribution, application, and expansion. The summary is comprehensive and meticulous, suitable as review materials.
This is a mind map about plant asexual reproduction, and its main contents include: concept, spore reproduction, vegetative reproduction, tissue culture, and buds. The summary is comprehensive and meticulous, suitable as review materials.
This is a mind map about the reproductive development of animals, and its main contents include: insects, frogs, birds, sexual reproduction, and asexual reproduction. The summary is comprehensive and meticulous, suitable as review materials.
有效票價統計
執行方式
頁面選取抓票管道 點選新增統計任務開始執行
資料庫
redis
key
字首:行程類型~出發機場~到達機場~起飛時間~航司~
fare:info:1~CEI~DMK~2024-03-11~FD~
目前只統計行程類型是單程的數據
mysql
統計任務
id
trip_type
statistics_status
data_status
enable_status
cap_channel
抓取頻道
create_time
last_update_time
任務結果
id
task_id
trip_type
cap_channel
carrier
air_line
valid_fare_days
valid_routing_number
data_status
enable_status
create_time
last_update_time
流程
1. 取得傳入的抓票管道 根據抓票管道取得所有相關的抓取策略列表
不傳預設查所有管道
2. 根據查詢出的抓取策略清單 分別取得策略清單中的白名單列表
建立 抓票管道 - 航司 - 航線 關係列表
3. 根據 航司 - 航線關係清單 日期用 * 通配表示 根據key規則 批量一次性拼接一個抓票頻道下的所有主key 存入set
4. 將主key set 透過mget一次去redis中mget所有key 取得一個回傳列表
5. 過濾這個返回清單 根據航線分組
組內有幾個數據代表這個航線有幾天的票
組內資料每一條的routing size總和代表行程有效數
6. 產生該策略下的統計結果資料 入庫
如果有多個抓票管道則重複2~6步驟 入庫每個策略下的統計結果