{"id":6015,"date":"2020-11-07T00:12:37","date_gmt":"2020-11-06T15:12:37","guid":{"rendered":"http:\/\/blog.jansnap.com\/?p=6015"},"modified":"2021-12-17T22:42:45","modified_gmt":"2021-12-17T13:42:45","slug":"ruby%2023%20%e3%81%a7%e3%80%8c%e3%80%8d%e3%82%84%e3%80%8c%22%e3%80%8d%e3%81%8c%e5%90%ab%e3%81%be%e3%82%8c%e3%82%8bcsv%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab%e3%82%92mysql%e3%81%ab%e5%85%a5%e3%82%8c%e3%82","status":"publish","type":"post","link":"https:\/\/blog.jansnap.com\/?p=6015","title":{"rendered":"Ruby 2.3 \u3067\u300c’\u300d\u3084\u300c”\u300d\u304c\u542b\u307e\u308c\u308bCSV\u30d5\u30a1\u30a4\u30eb\u3092MySQL\u306b\u5165\u308c\u308b"},"content":{"rendered":"\n

<\/span>\n\u6982\u8981<\/span><\/h2>\n\n\n\n
  • Ruby2.3\u3067\u300c'<\/code>\u300d\u3084\u300c\"<\/code>\u300d\u304c\u542b\u307e\u308c\u308bCSV\u30d5\u30a1\u30a4\u30eb\u3092CSV\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u4f7f\u3063\u3066MySQL\u306b\u5165\u308c\u308b\u5834\u5408\u3001\u4ee5\u4e0b\u306e2\u70b9\u306e\u6ce8\u610f\u304c\u5fc5\u8981\u3002\n\n
      \n
    • CSV\u30d5\u30a1\u30a4\u30eb\u306b\u300c\u201d\u300d\u304c\u5165\u3063\u3066\u3044\u308b\u3068\u3001\u30d5\u30a1\u30a4\u30eb\u8aad\u307f\u8fbc\u307f\u6642\u306b\u300c\"<\/code>\u300d\u304c\u5165\u3063\u3066\u3044\u308b\u3068 Illegal Quoting<\/code> \u30a8\u30e9\u30fc\u306b\u306a\u308b\u306e\u3067\u3001quote_char: \"\\x00\"<\/code>\u3092\u6307\u5b9a\u3059\u308b\n\n
        \n
      • Ruby 2.4 \u304b\u3089\u306f\u3001CSV\u30e2\u30b8\u30e5\u30fc\u30eb\u306b liberal_parsing<\/code> \u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u4f7f\u3048\u308b\u304c\u30012.3\u4ee5\u524d\u3067\u306f\u4f7f\u3048\u306a\u3044<\/li>\n
      • \u666e\u901a\u306f\u30d5\u30a1\u30a4\u30eb\u5185\u306b\u5b58\u5728\u3057\u306a\u3044\u306f\u305a\u306e\"\\x00\"<\/code>\u3092\u6307\u5b9a\u3059\u308b\u306e\u304c\u30df\u30bd<\/li>\n<\/ul>\n<\/li>\n
      • \u300c'<\/code>\u300d\u306fMySQL\u306b\u5165\u308c\u308b\u6642\u306b\u300c\\\\'<\/code>\u300d\u306b\u30a8\u30b9\u30b1\u30fc\u30d7\u51e6\u7406\u3092\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u306e\u3067\u3001gsub\u3067\u7f6e\u63db\u3059\u308b<\/li>\n<\/ul>\n<\/li><\/ul>\n\n\n\n

        <\/span>\n\u74b0\u5883<\/span><\/h2>\n\n\n\n
        • ruby 2.3.8p459 (2018-10-18 revision 65136) [x86_64-linux]<\/li><\/ul>\n\n\n\n

          <\/span>\n\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\uff08TSV\u30d5\u30a1\u30a4\u30eb\u7528)<\/span><\/h2>\n\n\n\n
          require \"csv\"\n\nsummary = {}\nCSV.foreach(\"myfile.tsv\", col_sep: \"\\t\", quote_char: \"\\x00\", encoding: \"UTF-8\", headers: :first_row) do |row|\n    summary = {\n        :col1 => row[0].to_s,\n        :col2 => row[1].to_s.gsub(\"'\", \"\\\\\\\\'\"),\n        :col3 => row[2].to_f,\n    }\n    puts summary\n    # MyModel.replace(summary)\nend<\/code><\/pre>\n\n\n\n
          <\/span>\n\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf(TSV\u5f62\u5f0f)<\/span><\/h2>\n\n\n\n
          col1    col2    col3\nhomemade cookies    Aunt Stella's cookies   123\nnickname    Louis \"Satchmo\" Armstrong   456\nyard-pound system   4' 10\"  147.32\nyard-pound system 2 4\u2032 10\u2033  147.32<\/code><\/pre>\n\n\n\n
          <\/span>\n\u5b9f\u884c\u3057\u3066\u8868\u793a\u3092\u78ba\u8a8d<\/span><\/h2>\n\n\n\n
          {:col1=>\"homemade cookies\", :col2=>\"Aunt Stella\\\\'s cookies\", :col3=>123.0}\n{:col1=>\"nickname\", :col2=>\"Louis \\\"Satchmo\\\" Armstrong\", :col3=>456.0}\n{:col1=>\"yard-pound system\", :col2=>\"4\\\\' 10\\\"\", :col3=>147.32}\n{:col1=>\"yard-pound system 2\", :col2=>\"4\u2032 10\u2033\", :col3=>147.32}<\/code><\/pre>\n\n\n\n
          <\/span>\n\u88dc\u8db3<\/span><\/h2>\n\n\n\n
          • \n\\\\\\\\<\/code>\u304c\\\\<\/code>\u306b\u7f6e\u63db\u3055\u308c\u3066\\<\/code>\u306b\u7f6e\u63db\u3055\u308c\u308b\u6240\u304c\u3084\u3084\u3053\u3057\u3044\u3002<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"
            Ruby2.3\u3067\u300c’\u300d\u3084\u300c”\u300d\u304c\u542b\u307e\u308c\u308bCSV\u30d5\u30a1\u30a4\u30eb\u3092CSV\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u4f7f\u3063\u3066MySQL\u306b\u5165\u308c\u308b\u5834\u5408\u3001\u4ee5\u4e0b\u306e2\u70b9\u306e\u6ce8\u610f\u304c\u5fc5\u8981\u3002
            \nCSV\u30d5\u30a1\u30a4\u30eb\u306b\u300c\u201d\u300d\u304c\u5165\u3063\u3066\u3044\u308b\u3068\u3001\u30d5\u30a1\u30a4\u30eb\u8aad\u307f\u8fbc\u307f\u6642\u306b\u300c”\u300d\u304c\u5165\u3063\u3066\u3044\u308b\u3068 Illegal Quoting \u30a8\u30e9\u30fc\u306b\u306a\u308b\u306e\u3067\u3001quote_char: “\\x00″\u3092\u6307\u5b9a\u3059\u308b<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4093,4120,4119,4122,4121],"tags":[4091,4116,4115,4118,4117],"class_list":["post-6015","post","type-post","status-publish","format-standard","hentry","category-csv","category-mysql","category-ruby","category-ruby23","category-4121","tag-csv","tag-mysql","tag-ruby","tag-ruby23","tag-4117"],"_links":{"self":[{"href":"https:\/\/blog.jansnap.com\/index.php?rest_route=\/wp\/v2\/posts\/6015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.jansnap.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.jansnap.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jansnap.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jansnap.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6015"}],"version-history":[{"count":2,"href":"https:\/\/blog.jansnap.com\/index.php?rest_route=\/wp\/v2\/posts\/6015\/revisions"}],"predecessor-version":[{"id":6279,"href":"https:\/\/blog.jansnap.com\/index.php?rest_route=\/wp\/v2\/posts\/6015\/revisions\/6279"}],"wp:attachment":[{"href":"https:\/\/blog.jansnap.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jansnap.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jansnap.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}