{"id":8680,"date":"2016-10-19T23:20:09","date_gmt":"2016-10-19T14:20:09","guid":{"rendered":"http:\/\/www.skyarch.net\/blog\/?p=8680"},"modified":"2016-10-19T23:20:09","modified_gmt":"2016-10-19T14:20:09","slug":"rails%e3%81%aeseeds-rb%e3%81%ab%e5%86%aa%e7%ad%89%e6%80%a7%e3%82%92%e6%8c%81%e3%81%9f%e3%81%9b%e3%82%8b%e3%81%9f%e3%82%81%e3%81%ae%e3%82%b9%e3%82%af%e3%83%aa%e3%83%97%e3%83%88%e3%82%92%e6%9b%b8","status":"publish","type":"post","link":"https:\/\/www.skyarch.net\/blog\/rails%e3%81%aeseeds-rb%e3%81%ab%e5%86%aa%e7%ad%89%e6%80%a7%e3%82%92%e6%8c%81%e3%81%9f%e3%81%9b%e3%82%8b%e3%81%9f%e3%82%81%e3%81%ae%e3%82%b9%e3%82%af%e3%83%aa%e3%83%97%e3%83%88%e3%82%92%e6%9b%b8\/","title":{"rendered":"Rails\u306eseeds.rb\u306b\u51aa\u7b49\u6027\u3092\u6301\u305f\u305b\u308b\u305f\u3081\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u66f8\u3044\u305f"},"content":{"rendered":"<p>Rails\u3067\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u3084\u30de\u30b9\u30bf\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306b\u3001seeds.rb\u3092\u4f7f\u3046\u3068\u601d\u3044\u307e\u3059\u3002<br \/>\n\u3057\u304b\u3057\u3001\u305d\u306e\u307e\u307e\u4f7f\u3046\u306e\u3067\u306f\u4e0d\u4fbf\u3060\u3063\u305f\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u3088\u3046\u306b\u6539\u826f\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u30fb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30ec\u30b3\u30fc\u30c9\u3092ID\u3067\u691c\u7d22\u3057\u3001\u898b\u3064\u304b\u308c\u3070\u65e2\u5b58\u306e\u30c7\u30fc\u30bf\u3092seeds.rb\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3067\u66f4\u65b0<br \/>\n\u30fb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30ec\u30b3\u30fc\u30c9\u3092ID\u3067\u691c\u7d22\u3057\u3001\u898b\u3064\u304b\u3089\u306a\u304b\u3063\u305f\u5834\u5408\u3001seeds.rb\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u633f\u5165<br \/>\n\u30fbseeds.rb\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u4ee5\u5916\u306eID\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u5168\u524a\u9664<\/p>\n<p>\u4f8b\u3048\u3070item_kind\u3068user\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u308b\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"brush: ruby; title: ; notranslate\" title=\"\">\r\ndef insert_and_delete_unnecessary_record(model_snake_case_name, seed_data)\r\n  current_model = eval(model_snake_case_name.camelize)\r\n  current_ids = current_model.all.ids\r\n  inserted_ids = &#x5B;]\r\n  seed_data.each do |row|\r\n    inserted_ids &lt;&lt; row&#x5B;:id]\r\n    new_seed_data = current_model.find_or_initialize_by(id: row&#x5B;:id])\r\n    row.delete(:id)\r\n    row.each do |key, value|\r\n      value = &quot;'#{value}'&quot; if value.is_a? String\r\n      value = 'nil' if value == nil\r\n      eval(&quot;new_seed_data.#{key} = #{value}&quot;)\r\n    end\r\n    new_seed_data.save!\r\n  end\r\n\r\n  current_ids.each do |id|\r\n    unless inserted_ids.include?(id)\r\n      current_model.destroy(id)\r\n    end\r\n  end\r\nend\r\n\r\nseed_item_kind = &#x5B;\r\n    {id: 1, name: '\u5bb6\u96fb'},\r\n    {id: 2, name: '\u30b2\u30fc\u30e0'},\r\n    {id: 3, name: '\u30b9\u30dd\u30fc\u30c4'},\r\n    {id: 4, name: '\u30d1\u30bd\u30b3\u30f3'}\r\n]\r\n\r\ninsert_and_delete_unnecessary_record('item_kind',\u3000'seed_item_kind')\r\n\r\n\r\nseed_user = &#x5B;\r\n    {id: 1, name: '\u7530\u4e2d', age: 20},\r\n    {id: 2, name: '\u5c71\u4e2d', age: 30},\r\n    {id: 3, name: '\u4f50\u85e4', age: 40},\r\n    {id: 4, name: '\u5c0f\u7530', age: 26}\r\n]\r\n\r\ninsert_and_delete_unnecessary_record('user', 'seed_user')\r\n<\/pre>\n<p>insert_and_delete_unnecessary_record\u95a2\u6570\u3092seeds.rb\u306e\u4e00\u756a\u4e0a\u306b\u30b3\u30d4\u30da\u3057\u307e\u3059\u3002<br \/>\n\u305d\u3057\u3066\u3001\u5909\u6570\u306b\u914d\u5217\u3068\u3057\u3066\u30ab\u30e9\u30e0\u3092\u30ad\u30fc\u3001\u30d0\u30ea\u30e5\u30fc\u3092\u305d\u306e\u30ab\u30e9\u30e0\u306e\u5024\u3068\u3057\u3066\u5165\u308c\u307e\u3059\u3002<br \/>\n\u6700\u5f8c\u306b\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u3066insert_and_delete_unnecessary_record\u95a2\u6570\u3092\u547c\u3073\u51fa\u305b\u3070\u3001\u914d\u5217\u3068\u3057\u3066\u5b9a\u7fa9\u3057\u305f\u30c7\u30fc\u30bf\u304c\u305d\u306e\u307e\u307e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u767b\u9332\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"brush: ruby; title: ; notranslate\" title=\"\">\r\ninsert_and_delete_unnecessary_record(\u30c6\u30fc\u30d6\u30eb\u540d,\u3000\u914d\u5217\u3092\u5b9a\u7fa9\u3057\u305f\u5909\u6570\u540d)\r\n<\/pre>\n<p>\u3061\u306a\u307f\u306b\u3001<a href=\"https:\/\/github.com\/james2m\/seedbank\">seedbank<\/a>\u3092\u4f7f\u3046\u3068<br \/>\n\u30fb\u30d5\u30a1\u30a4\u30eb\u3092\u5206\u5272\u3067\u304d\u308b<br \/>\n\u30fb\u30c7\u30fc\u30bf\u9593\u306e\u4f9d\u5b58\u3092\u7ba1\u7406\u3067\u304d\u308b<br \/>\n\u30fb\u74b0\u5883\u3054\u3068\u306bseed\u30d5\u30a1\u30a4\u30eb\u3092\u5206\u3051\u3089\u308c\u308b<\/p>\n<p>\u304c\u3067\u304d\u308b\u306e\u3067\u3001\u4e0a\u8a18\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3068\u5408\u308f\u305b\u3066\u4f7f\u3046\u3068\u4fbf\u5229\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Rails\u3067\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u3084\u30de\u30b9\u30bf\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306b\u3001seeds.rb\u3092\u4f7f\u3046\u3068\u601d\u3044\u307e\u3059\u3002 \u3057\u304b\u3057\u3001\u305d\u306e\u307e\u307e\u4f7f\u3046\u306e\u3067\u306f\u4e0d\u4fbf\u3060\u3063\u305f\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u3088\u3046\u306b\u6539\u826f\u3057\u307e\u3057\u305f\u3002 \u30fb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30ec\u30b3\u30fc\u30c9\u3092ID\u3067\u691c\u7d22\u3057\u3001\u898b\u3064\u304b\u308c&#8230;<\/p>\n","protected":false},"author":1,"featured_media":8689,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"ja","_original_post":"8680","footnotes":""},"categories":[23,9],"tags":[174,172,173],"class_list":{"0":"post-8680","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-23","8":"category-dev","9":"tag-ruby-on-rails","10":"tag-seeds-rb","11":"tag-173","12":"ja"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/8680","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/comments?post=8680"}],"version-history":[{"count":5,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/8680\/revisions"}],"predecessor-version":[{"id":12415,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/8680\/revisions\/12415"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/media\/8689"}],"wp:attachment":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/media?parent=8680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/categories?post=8680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/tags?post=8680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}