Closed
Description
開発時にちょっとドキッとしてしまうので揃えておきたい。
ローカル
5.1.4@2.4.2 (main)> pp Dojo.includes(:prefecture).default_order.map { |o| [o.id, o.name] };
Dojo Load (1.0ms) SELECT "dojos".* FROM "dojos" ORDER BY "dojos"."prefecture_id" ASC
Prefecture Load (0.3ms) SELECT "prefectures".* FROM "prefectures" WHERE "prefectures"."id" IN (1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 40, 42, 45, 47)
[[64, "札幌 (北海道)"],
[100, "恵庭 (北海道)"],
[104, "札幌東 (北海道)"],
[107, "きたかみ (東北)"],
[109, "滝沢 (東北)"],
[3, "泉 (東北)"],
[4, "登米 (東北)"],
[59, "中新田 (東北)"],
[85, "名取 (東北)"],
[90, "愛子 (東北)"],
[75, "秋田 (東北)"],
[74, "山形 (東北)"],
[79, "会津 (東北)"],
[8, "守谷 (関東)"],
[65, "水戸 (関東)"],
[73, "ひたちなか (関東)"],
[89, "さくら (関東)"],
[7, "前橋 (関東)"],
[9, "さいたま (関東)"],
[10, "ひばりヶ丘 (関東)"],
[11, "飯能 (関東)"],
[12, "所沢 (関東)"],
[77, "小手指 (関東)"],
[20, "野田 (関東)"],
[21, "浦安 (関東)"],
[22, "千葉 (関東)"],
[23, "柏 (関東)"],
[24, "流山 (関東)"],
[25, "若葉 (関東)"],
[60, "市川 (関東)"],
[82, "市川真間 (関東)"],
[83, "木更津 (関東)"],
[86, "船橋＠凛童舎 (関東)"],
[112, "南柏 (関東)"],
[114, "松戸 (関東)"],
[13, "小平 (関東)"],
[14, "八王子 (関東)"],
[15, "中野 (関東)"],
[16, "すぎなみ (関東)"],
[17, "下北沢 (関東)"],
[18, "調布 (関東)"],
[19, "渋谷 (関東)"],
[58, "高田馬場 (関東)"],
[69, "西新宿 (関東)"],
[97, "秋葉原 (関東)"],
[105, "吉祥寺 (関東)"],
[117, "立川 (関東)"],
[26, "藤沢 (関東)"],
[68, "新羽 (関東)"],
[70, "横浜 (関東)"],
[76, "長津田 (関東)"],
[91, "海老名 (関東)"],
[5, "新潟 (中部)"],
[6, "金沢 (中部)"],
[28, "福井 (中部)"],
[88, "甲府 (中部)"],
[27, "塩尻 (中部)"],
[87, "安曇野 (中部)"],
[94, "諏訪湖 (中部)"],
[96, "海津 (中部)"],
[98, "浜松 (中部)"],
[30, "豊橋 (中部)"],
[31, "名古屋 (中部)"],
[32, "天白 (中部)"],
[33, "大治 (中部)"],
[71, "尾張 (中部)"],
[84, "新城 (中部)"],
[118, "安城 (中部)"],
[62, "伊勢 (近畿)"],
[37, "大津 (近畿)"],
[34, "長岡京 (近畿)"],
[39, "京都伏見 (近畿)"],
[40, "枚方 (近畿)"],
[41, "東大阪 (近畿)"],
[42, "西宮・梅田 (近畿)"],
[43, "なんば (近畿)"],
[44, "本町 (近畿)"],
[45, "西成 (近畿)"],
[46, "堺 (近畿)"],
[66, "高槻 (近畿)"],
[72, "富田林 (近畿)"],
[101, "八尾 (近畿)"],
[108, "みのお (近畿)"],
[110, "せんなん (近畿)"],
[116, "阿倍野 (近畿)"],
[48, "神戸 (近畿)"],
[49, "明石 (近畿)"],
[50, "姫路 (近畿)"],
[67, "北神戸 (近畿)"],
[119, "西神戸 (近畿)"],
[35, "奈良 (近畿)"],
[36, "生駒 (近畿)"],
[38, "熊野 (近畿)"],
[47, "和歌山 (近畿)"],
[99, "南紀田辺 (近畿)"],
[115, "大山 (中国)"],
[78, "吉賀 (中国)"],
[81, "岡山 岡南 (中国)"],
[51, "福山 (中国)"],
[52, "広島 (中国)"],
[53, "五日市 (中国)"],
[92, "光 (中国)"],
[103, "徳島 (四国)"],
[111, "三好 (四国)"],
[54, "久留米 (九州)"],
[102, "福岡 (九州)"],
[113, "ももち (九州)"],
[120, "長崎 (九州)"],
[55, "宮崎 (九州)"],
[56, "宮古島 (沖縄)"],
[57, "嘉手納 (沖縄)"],
[61, "那覇 (沖縄)"],
[106, "宜野湾 (沖縄)"]]
本番
irb(main):029:0* pp Dojo.includes(:prefecture).default_order.map { |o| [o.id, o.name] }
D, [2017-11-26T21:49:41.629374 #4] DEBUG -- : Dojo Load (2.1ms) SELECT "dojos".* FROM "dojos" ORDER BY "dojos"."prefecture_id" ASC
D, [2017-11-26T21:49:41.639895 #4] DEBUG -- : Prefecture Load (1.0ms) SELECT "prefectures".* FROM "prefectures" WHERE "prefectures"."id" IN (1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 40, 42, 45, 47)
[[64, "札幌 (北海道)"],
[100, "恵庭 (北海道)"],
[104, "札幌東 (北海道)"],
[107, "きたかみ (東北)"],
[109, "滝沢 (東北)"],
[3, "泉 (東北)"],
[85, "名取 (東北)"],
[4, "登米 (東北)"],
[59, "中新田 (東北)"],
[90, "愛子 (東北)"],
[75, "秋田 (東北)"],
[74, "山形 (東北)"],
[79, "会津 (東北)"],
[73, "ひたちなか (関東)"],
[8, "守谷 (関東)"],
[65, "水戸 (関東)"],
[89, "さくら (関東)"],
[7, "前橋 (関東)"],
[77, "小手指 (関東)"],
[9, "さいたま (関東)"],
[12, "所沢 (関東)"],
[10, "ひばりヶ丘 (関東)"],
[11, "飯能 (関東)"],
[83, "木更津 (関東)"],
[112, "南柏 (関東)"],
[25, "若葉 (関東)"],
[20, "野田 (関東)"],
[22, "千葉 (関東)"],
[24, "流山 (関東)"],
[114, "松戸 (関東)"],
[86, "船橋＠凛童舎 (関東)"],
[60, "市川 (関東)"],
[23, "柏 (関東)"],
[21, "浦安 (関東)"],
[82, "市川真間 (関東)"],
[17, "下北沢 (関東)"],
[16, "すぎなみ (関東)"],
[13, "小平 (関東)"],
[19, "渋谷 (関東)"],
[69, "西新宿 (関東)"],
[97, "秋葉原 (関東)"],
[18, "調布 (関東)"],
[14, "八王子 (関東)"],
[15, "中野 (関東)"],
[117, "立川 (関東)"],
[105, "吉祥寺 (関東)"],
[58, "高田馬場 (関東)"],
[70, "横浜 (関東)"],
[91, "海老名 (関東)"],
[26, "藤沢 (関東)"],
[68, "新羽 (関東)"],
[76, "長津田 (関東)"],
[5, "新潟 (中部)"],
[6, "金沢 (中部)"],
[28, "福井 (中部)"],
[88, "甲府 (中部)"],
[27, "塩尻 (中部)"],
[87, "安曇野 (中部)"],
[94, "諏訪湖 (中部)"],
[96, "海津 (中部)"],
[98, "浜松 (中部)"],
[33, "大治 (中部)"],
[71, "尾張 (中部)"],
[31, "名古屋 (中部)"],
[32, "天白 (中部)"],
[118, "安城 (中部)"],
[30, "豊橋 (中部)"],
[84, "新城 (中部)"],
[62, "伊勢 (近畿)"],
[37, "大津 (近畿)"],
[34, "長岡京 (近畿)"],
[39, "京都伏見 (近畿)"],
[72, "富田林 (近畿)"],
[43, "なんば (近畿)"],
[40, "枚方 (近畿)"],
[66, "高槻 (近畿)"],
[46, "堺 (近畿)"],
[42, "西宮・梅田 (近畿)"],
[45, "西成 (近畿)"],
[44, "本町 (近畿)"],
[41, "東大阪 (近畿)"],
[116, "阿倍野 (近畿)"],
[110, "せんなん (近畿)"],
[101, "八尾 (近畿)"],
[108, "みのお (近畿)"],
[48, "神戸 (近畿)"],
[67, "北神戸 (近畿)"],
[119, "西神戸 (近畿)"],
[49, "明石 (近畿)"],
[50, "姫路 (近畿)"],
[36, "生駒 (近畿)"],
[35, "奈良 (近畿)"],
[99, "南紀田辺 (近畿)"],
[47, "和歌山 (近畿)"],
[38, "熊野 (近畿)"],
[115, "大山 (中国)"],
[78, "吉賀 (中国)"],
[81, "岡山 岡南 (中国)"],
[51, "福山 (中国)"],
[52, "広島 (中国)"],
[53, "五日市 (中国)"],
[92, "光 (中国)"],
[111, "三好 (四国)"],
[103, "徳島 (四国)"],
[54, "久留米 (九州)"],
[102, "福岡 (九州)"],
[113, "ももち (九州)"],
[120, "長崎 (九州)"],
[55, "宮崎 (九州)"],
[56, "宮古島 (沖縄)"],
[57, "嘉手納 (沖縄)"],
[106, "宜野湾 (沖縄)"],
[61, "那覇 (沖縄)"]]
Metadata
Metadata
Assignees
Labels
No labels