Closed supercaracal closed 7 years ago
japan_masters_swimming=# select * from swimmers where name like '%ここまで%'; id | team_id | name | created_at | updated_at -------+---------+------------------------------------------------------------------------------------+----------------------------+---------------------------- 11662 | 1277 | ------------------------------------------------------------ここまで入賞長岡三重子 | 2016-11-14 11:29:17.287194 | 2016-11-14 11:29:17.287194 11686 | 1200 | ------------------------------------------------------------ここまで入賞棚橋梢 | 2016-11-14 11:29:18.688296 | 2016-11-14 11:29:18.688296 11687 | 1750 | ------------------------------------------------------------ここまで入賞長谷川ゆり | 2016-11-14 11:29:18.725835 | 2016-11-14 11:29:18.725835 11844 | 457 | ------------------------------------------------------------ここまで入賞細萱瑞穂 | 2016-11-14 11:30:52.007591 | 2016-11-14 11:30:52.007591 11846 | 457 | ------------------------------------------------------------ここまで入賞涌嶋由紀子 | 2016-11-14 11:30:52.021547 | 2016-11-14 11:30:52.021547 11847 | 350 | ------------------------------------------------------------ここまで入賞磯山嘉光 | 2016-11-14 11:31:12.268815 | 2016-11-14 11:31:12.268815 11873 | 17 | ------------------------------------------------------------ここまで入賞方山嘉子 | 2016-11-14 11:31:35.875961 | 2016-11-14 11:31:35.875961 11890 | 1279 | ------------------------------------------------------------ここまで入賞溝田美保子 | 2016-11-14 11:31:36.589527 | 2016-11-14 11:31:36.589527 11912 | 1924 | ------------------------------------------------------------ここまで入賞林拓哉 | 2016-11-14 11:32:02.345627 | 2016-11-14 11:32:02.345627 11917 | 902 | ------------------------------------------------------------ここまで入賞渡辺隼平 | 2016-11-14 11:32:02.403302 | 2016-11-14 11:32:02.403302 12945 | 96 | ------------------------------------------------------------ここまで入賞秋山瞳 | 2016-11-14 11:43:27.67704 | 2016-11-14 11:43:27.67704 12961 | 204 | ------------------------------------------------------------ここまで入賞吉田慶子 | 2016-11-14 11:46:26.848893 | 2016-11-14 11:46:26.848893 12963 | 457 | ------------------------------------------------------------ここまで入賞篠木香穂 | 2016-11-14 11:46:26.870566 | 2016-11-14 11:46:26.870566 12976 | 1575 | ------------------------------------------------------------ここまで入賞長田和也 | 2016-11-14 11:47:57.782422 | 2016-11-14 11:47:57.782422 13055 | 1089 | ------------------------------------------------------------ここまで入賞須川明子 | 2016-11-14 11:52:50.379135 | 2016-11-14 11:52:50.379135 (15 rows)
Trim ------------------------------------------------------------ここまで入賞
------------------------------------------------------------ここまで入賞
https://github.com/supercaracal/japan-masters-swimming/blob/master/lib/tasks/import/tdsystem_scraper.rb#L7
Trim
------------------------------------------------------------ここまで入賞