{"id":45275,"date":"2023-08-08T21:44:01","date_gmt":"2023-04-22T18:37:52","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/"},"modified":"2024-04-30T17:39:00","modified_gmt":"2024-04-30T09:39:00","slug":"45275-2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/","title":{"rendered":""},"content":{"rendered":"<h2>\u80cc\u666f<\/h2>\n<p>Rails\u3067CSV\u3092\u8fd4\u3059\u6642\u300110\u4e07\u30c7\u30fc\u30bf\u304f\u3089\u3044\u306e\u3082\u306e\u3092\u666e\u901a\u306b\u51e6\u7406\u3059\u308b\u3068\u30e1\u30e2\u30ea\u3092\u98df\u3044\u6f70\u3057\u305f\u308a\u3001\u51e6\u7406\u304c\u9045\u304b\u3063\u305f\u308a\u3059\u308b\u3002<br \/>\n\u305d\u3053\u3067\u89e3\u6c7a\u7b56\u3092\u63a2\u3057\u3066\u3044\u305f\u3089\u3001Rust\u3067Rails\u306e\u4ee3\u308f\u308a\u306bCSV\u3092\u4f5c\u308b\u3068\u3044\u3046\u7d20\u6674\u3089\u3057\u3044\u8a18\u4e8b\u306b\u51fa\u4f1a\u3063\u305f\u3002<br \/>\n\u3053\u306e\u8a18\u4e8b\u306fPostgres\u3084Nginx\u3092\u4f7f\u3063\u3066\u305f\u304c\u3001\u79c1\u306fMySQL\u3092\u4f7f\u3063\u3066\u304a\u308a\u3001Rails\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u5185\u3067\u5b8c\u7d50\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u3001\u53c2\u8003\u306b\u3057\u306a\u304c\u3089\u8a66\u9a13\u7684\u306b\u4f5c\u3063\u3066\u898b\u305f\u3002<\/p>\n<h2>\u304a\u65ad\u308a<\/h2>\n<p>Rails\u3092\u3059\u3067\u306b\u7406\u89e3\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u524d\u63d0\u306b\u9032\u3081\u307e\u3059\u3002<br \/>\n\u521d\u5fc3\u8005\u306e\u65b9\u3078\u74b0\u5883\u69cb\u7bc9\u5468\u308a\u3092\u6700\u5f8c\u306e\u65b9\u306b\u304a\u307e\u3051\u3068\u3057\u3066\u66f8\u3044\u3066\u304a\u304d\u307e\u3059\u306e\u3067\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<br \/>\n\u7b46\u8005\u306fRust\u521d\u5fc3\u8005\u3067\u3059\u306e\u3067\u30a2\u30c9\u30d0\u30a4\u30b9\u3092\u9802\u3051\u308b\u3068\u3068\u3066\u3082\u52a9\u304b\u308a\u307e\u3059\u3002<\/p>\n<h2>\u74b0\u5883<\/h2>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Ruby 2.3.3<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Rust 1.14.0<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Rails 5.0.1<\/ul>\n<p>Gemfile\u306f\u57fa\u672c\u30c7\u30d5\u30a9\u30eb\u30c8<\/p>\n<pre class=\"post-pre\"><code><span class=\"n\">source<\/span> <span class=\"s1\">'https:\/\/rubygems.org'<\/span>\r\n\r\n<span class=\"n\">git_source<\/span><span class=\"p\">(<\/span><span class=\"ss\">:github<\/span><span class=\"p\">)<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">repo_name<\/span><span class=\"o\">|<\/span>\r\n  <span class=\"n\">repo_name<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">repo_name<\/span><span class=\"si\">}<\/span><span class=\"s2\">\/<\/span><span class=\"si\">#{<\/span><span class=\"n\">repo_name<\/span><span class=\"si\">}<\/span><span class=\"s2\">\"<\/span> <span class=\"k\">unless<\/span> <span class=\"n\">repo_name<\/span><span class=\"p\">.<\/span><span class=\"nf\">include?<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"\/\"<\/span><span class=\"p\">)<\/span>\r\n  <span class=\"s2\">\"https:\/\/github.com\/<\/span><span class=\"si\">#{<\/span><span class=\"n\">repo_name<\/span><span class=\"si\">}<\/span><span class=\"s2\">.git\"<\/span>\r\n<span class=\"k\">end<\/span>\r\n\r\n\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'rails'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'~&gt; 5.0.1'<\/span>\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'mysql2'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'&gt;= 0.3.18'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'&lt; 0.5'<\/span>\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'puma'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'~&gt; 3.0'<\/span>\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'sass-rails'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'~&gt; 5.0'<\/span>\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'uglifier'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'&gt;= 1.3.0'<\/span>\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'coffee-rails'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'~&gt; 4.2'<\/span>\r\n\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'jquery-rails'<\/span>\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'turbolinks'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'~&gt; 5'<\/span>\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'jbuilder'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'~&gt; 2.5'<\/span>\r\n\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'ffi'<\/span>\r\n\r\n<span class=\"n\">group<\/span> <span class=\"ss\">:development<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:test<\/span> <span class=\"k\">do<\/span>\r\n  <span class=\"n\">gem<\/span> <span class=\"s1\">'byebug'<\/span><span class=\"p\">,<\/span> <span class=\"ss\">platform: :mri<\/span>\r\n<span class=\"k\">end<\/span>\r\n\r\n<span class=\"n\">group<\/span> <span class=\"ss\">:development<\/span> <span class=\"k\">do<\/span>\r\n  <span class=\"n\">gem<\/span> <span class=\"s1\">'web-console'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'&gt;= 3.3.0'<\/span>\r\n  <span class=\"n\">gem<\/span> <span class=\"s1\">'listen'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'~&gt; 3.0.5'<\/span>\r\n  <span class=\"n\">gem<\/span> <span class=\"s1\">'spring'<\/span>\r\n  <span class=\"n\">gem<\/span> <span class=\"s1\">'spring-watcher-listen'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'~&gt; 2.0.0'<\/span>\r\n<span class=\"k\">end<\/span>\r\n\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'tzinfo-data'<\/span><span class=\"p\">,<\/span> <span class=\"ss\">platforms: <\/span><span class=\"p\">[<\/span><span class=\"ss\">:mingw<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:mswin<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:x64_mingw<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:jruby<\/span><span class=\"p\">]<\/span>\r\n<\/code><\/pre>\n<p>cargo\u306e\u8a2d\u5b9a\u306f\u4ee5\u4e0b\u306e\u901a\u308a\uff08CSV\u30af\u30ec\u30fc\u30c8\u3092\u4f7f\u3063\u305f\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u6700\u5f8c\u306e\u65b9\u306b\u3042\u308b\u8ffd\u8a18\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044)<\/p>\n<pre class=\"post-pre\"><code><span class=\"nn\">[dependencies]<\/span>\r\n<span class=\"py\">mysql<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"9.0.1\"<\/span>\r\n<span class=\"py\">libc<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"0.2.0\"<\/span>\r\n\r\n<span class=\"nn\">[lib]<\/span>\r\n<span class=\"py\">name<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"csv\"<\/span>\r\n<span class=\"py\">crate-type<\/span> <span class=\"p\">=<\/span> <span class=\"nn\">[\"dylib\"]<\/span>\r\n<\/code><\/pre>\n<h2>Rails\u5074\u306e\u8a2d\u5b9a<\/h2>\n<p>bundle exec rails new . -BTf -d mysql \u3067new\u3057\u305f\u6642\u306e\u8a2d\u5b9a\u3068\u3059\u308b\u3002<\/p>\n<h3>\u30c7\u30fc\u30bf\u306e\u4f5c\u6210<\/h3>\n<p>bundle exec rails g model csv_tests \u3067Model\u3092\u4f5c\u6210\u3002<br \/>\nmigration\u30d5\u30a1\u30a4\u30eb\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3059\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">class<\/span> <span class=\"nc\">CreateCsvTests<\/span> <span class=\"o\">&lt;<\/span> <span class=\"no\">ActiveRecord<\/span><span class=\"o\">::<\/span><span class=\"no\">Migration<\/span><span class=\"p\">[<\/span><span class=\"mf\">5.0<\/span><span class=\"p\">]<\/span>\r\n  <span class=\"k\">def<\/span> <span class=\"nf\">change<\/span>\r\n    <span class=\"n\">create_table<\/span> <span class=\"ss\">:csv_tests<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">t<\/span><span class=\"o\">|<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:name<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:hoge<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:foo<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:hogefoo<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:hogehoge<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:foofoo<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:namehoge<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:namefoo<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:namehogefoo<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:namehogehoge<\/span>\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">string<\/span> <span class=\"ss\">:namefoofoo<\/span>\r\n\r\n      <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">timestamps<\/span>\r\n    <span class=\"k\">end<\/span>\r\n  <span class=\"k\">end<\/span>\r\n<span class=\"k\">end<\/span>\r\n<\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u3092\u5165\u308c\u308b\u305f\u3081\u3002seeds.rb\u30d5\u30a1\u30a4\u30eb\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3059\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"mi\">500_000<\/span><span class=\"p\">.<\/span><span class=\"nf\">times<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">i<\/span><span class=\"o\">|<\/span>\r\n  <span class=\"n\">t<\/span> <span class=\"o\">=<\/span> <span class=\"no\">CsvTest<\/span><span class=\"p\">.<\/span><span class=\"nf\">new<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">name<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">...<\/span><span class=\"mi\">100<\/span><span class=\"p\">).<\/span><span class=\"nf\">map<\/span><span class=\"p\">{<\/span> <span class=\"p\">(<\/span><span class=\"mi\">65<\/span> <span class=\"o\">+<\/span> <span class=\"nb\">rand<\/span><span class=\"p\">(<\/span><span class=\"mi\">26<\/span><span class=\"p\">)).<\/span><span class=\"nf\">chr<\/span> <span class=\"p\">}.<\/span><span class=\"nf\">join<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">hoge<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">...<\/span><span class=\"mi\">100<\/span><span class=\"p\">).<\/span><span class=\"nf\">map<\/span><span class=\"p\">{<\/span> <span class=\"p\">(<\/span><span class=\"mi\">65<\/span> <span class=\"o\">+<\/span> <span class=\"nb\">rand<\/span><span class=\"p\">(<\/span><span class=\"mi\">26<\/span><span class=\"p\">)).<\/span><span class=\"nf\">chr<\/span> <span class=\"p\">}.<\/span><span class=\"nf\">join<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">foo<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">...<\/span><span class=\"mi\">100<\/span><span class=\"p\">).<\/span><span class=\"nf\">map<\/span><span class=\"p\">{<\/span> <span class=\"p\">(<\/span><span class=\"mi\">65<\/span> <span class=\"o\">+<\/span> <span class=\"nb\">rand<\/span><span class=\"p\">(<\/span><span class=\"mi\">26<\/span><span class=\"p\">)).<\/span><span class=\"nf\">chr<\/span> <span class=\"p\">}.<\/span><span class=\"nf\">join<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">hogefoo<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">...<\/span><span class=\"mi\">100<\/span><span class=\"p\">).<\/span><span class=\"nf\">map<\/span><span class=\"p\">{<\/span> <span class=\"p\">(<\/span><span class=\"mi\">65<\/span> <span class=\"o\">+<\/span> <span class=\"nb\">rand<\/span><span class=\"p\">(<\/span><span class=\"mi\">26<\/span><span class=\"p\">)).<\/span><span class=\"nf\">chr<\/span> <span class=\"p\">}.<\/span><span class=\"nf\">join<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">hogehoge<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">...<\/span><span class=\"mi\">100<\/span><span class=\"p\">).<\/span><span class=\"nf\">map<\/span><span class=\"p\">{<\/span> <span class=\"p\">(<\/span><span class=\"mi\">65<\/span> <span class=\"o\">+<\/span> <span class=\"nb\">rand<\/span><span class=\"p\">(<\/span><span class=\"mi\">26<\/span><span class=\"p\">)).<\/span><span class=\"nf\">chr<\/span> <span class=\"p\">}.<\/span><span class=\"nf\">join<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">foofoo<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">...<\/span><span class=\"mi\">100<\/span><span class=\"p\">).<\/span><span class=\"nf\">map<\/span><span class=\"p\">{<\/span> <span class=\"p\">(<\/span><span class=\"mi\">65<\/span> <span class=\"o\">+<\/span> <span class=\"nb\">rand<\/span><span class=\"p\">(<\/span><span class=\"mi\">26<\/span><span class=\"p\">)).<\/span><span class=\"nf\">chr<\/span> <span class=\"p\">}.<\/span><span class=\"nf\">join<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">namehoge<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">...<\/span><span class=\"mi\">100<\/span><span class=\"p\">).<\/span><span class=\"nf\">map<\/span><span class=\"p\">{<\/span> <span class=\"p\">(<\/span><span class=\"mi\">65<\/span> <span class=\"o\">+<\/span> <span class=\"nb\">rand<\/span><span class=\"p\">(<\/span><span class=\"mi\">26<\/span><span class=\"p\">)).<\/span><span class=\"nf\">chr<\/span> <span class=\"p\">}.<\/span><span class=\"nf\">join<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">namefoo<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">...<\/span><span class=\"mi\">100<\/span><span class=\"p\">).<\/span><span class=\"nf\">map<\/span><span class=\"p\">{<\/span> <span class=\"p\">(<\/span><span class=\"mi\">65<\/span> <span class=\"o\">+<\/span> <span class=\"nb\">rand<\/span><span class=\"p\">(<\/span><span class=\"mi\">26<\/span><span class=\"p\">)).<\/span><span class=\"nf\">chr<\/span> <span class=\"p\">}.<\/span><span class=\"nf\">join<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">namehogefoo<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">...<\/span><span class=\"mi\">100<\/span><span class=\"p\">).<\/span><span class=\"nf\">map<\/span><span class=\"p\">{<\/span> <span class=\"p\">(<\/span><span class=\"mi\">65<\/span> <span class=\"o\">+<\/span> <span class=\"nb\">rand<\/span><span class=\"p\">(<\/span><span class=\"mi\">26<\/span><span class=\"p\">)).<\/span><span class=\"nf\">chr<\/span> <span class=\"p\">}.<\/span><span class=\"nf\">join<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">namehogehoge<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">...<\/span><span class=\"mi\">100<\/span><span class=\"p\">).<\/span><span class=\"nf\">map<\/span><span class=\"p\">{<\/span> <span class=\"p\">(<\/span><span class=\"mi\">65<\/span> <span class=\"o\">+<\/span> <span class=\"nb\">rand<\/span><span class=\"p\">(<\/span><span class=\"mi\">26<\/span><span class=\"p\">)).<\/span><span class=\"nf\">chr<\/span> <span class=\"p\">}.<\/span><span class=\"nf\">join<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">namefoofoo<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">...<\/span><span class=\"mi\">100<\/span><span class=\"p\">).<\/span><span class=\"nf\">map<\/span><span class=\"p\">{<\/span> <span class=\"p\">(<\/span><span class=\"mi\">65<\/span> <span class=\"o\">+<\/span> <span class=\"nb\">rand<\/span><span class=\"p\">(<\/span><span class=\"mi\">26<\/span><span class=\"p\">)).<\/span><span class=\"nf\">chr<\/span> <span class=\"p\">}.<\/span><span class=\"nf\">join<\/span>\r\n  <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"nf\">save!<\/span>\r\n  <span class=\"k\">if<\/span><span class=\"p\">(<\/span><span class=\"n\">i<\/span> <span class=\"o\">%<\/span> <span class=\"mi\">1000<\/span> <span class=\"o\">==<\/span> <span class=\"mi\">0<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"nb\">puts<\/span> <span class=\"s2\">\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">i<\/span><span class=\"si\">}<\/span><span class=\"s2\">\u500b\u4fdd\u5b58\u5b8c\u4e86\"<\/span>\r\n  <span class=\"k\">end<\/span>\r\n<span class=\"k\">end<\/span>\r\n<\/code><\/pre>\n<p>\u30e9\u30f3\u30c0\u30e0\u306a\u6587\u5b57\u5217\u3092\u4f5c\u308b\u969b\u3001Ruby\u3067\u30e9\u30f3\u30c0\u30e0\u306a\u6587\u5b57\u5217\u3092\u751f\u6210\u3059\u308b\u65b9\u6cd5\u3092\u53c2\u8003\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u6700\u5f8c\u306bDB\u306e\u63a5\u7d9a\u8a2d\u5b9a\u3092\u4fee\u6b63\u3059\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"na\">default<\/span><span class=\"pi\">:<\/span> <span class=\"nl\">&amp;default<\/span>\r\n  <span class=\"na\">adapter<\/span><span class=\"pi\">:<\/span> <span class=\"s\">mysql2<\/span>\r\n  <span class=\"na\">encoding<\/span><span class=\"pi\">:<\/span> <span class=\"s\">utf8<\/span>\r\n  <span class=\"na\">pool<\/span><span class=\"pi\">:<\/span> <span class=\"m\">5<\/span>\r\n  <span class=\"na\">username<\/span><span class=\"pi\">:<\/span> <span class=\"s\">root<\/span>\r\n  <span class=\"na\">password<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">socket<\/span><span class=\"pi\">:<\/span> <span class=\"s\">\/tmp\/mysql.sock<\/span>\r\n\r\n<span class=\"na\">development<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"s\">&lt;&lt;<\/span><span class=\"pi\">:<\/span> <span class=\"nv\">*default<\/span>\r\n  <span class=\"na\">database<\/span><span class=\"pi\">:<\/span> <span class=\"s\">csv_test_development<\/span>\r\n<\/code><\/pre>\n<p>\u3053\u3053\u307e\u3067\u8a2d\u5b9a\u3057\u305f\u3089\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code>$ bundle exec rails db:create\r\n$ bundle exec rails db:migrate\r\n$ bundle exec rails db:seed\r\n# seed\u306f50\u4e07\u4ef6\u306e\u30c7\u30fc\u30bf\u3092\u5165\u308c\u8fbc\u3080\u306e\u3067\u304b\u306a\u308a\u6642\u9593\u304c\u304b\u304b\u308b\r\n<\/code><\/pre>\n<h3>\u30eb\u30fc\u30c6\u30a3\u30f3\u30b0\u304b\u3089\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u306e\u8a2d\u5b9a<\/h3>\n<p>\u30eb\u30fc\u30c6\u30a3\u30f3\u30b0\u306e\u8a2d\u5b9a\u306f<\/p>\n<pre class=\"post-pre\"><code><span class=\"no\">Rails<\/span><span class=\"p\">.<\/span><span class=\"nf\">application<\/span><span class=\"p\">.<\/span><span class=\"nf\">routes<\/span><span class=\"p\">.<\/span><span class=\"nf\">draw<\/span> <span class=\"k\">do<\/span>\r\n  <span class=\"n\">root<\/span> <span class=\"ss\">to: <\/span><span class=\"s1\">'csv#index'<\/span>\r\n  <span class=\"n\">get<\/span> <span class=\"ss\">:ruby<\/span><span class=\"p\">,<\/span> <span class=\"ss\">to: <\/span><span class=\"s1\">'csv#ruby'<\/span>\r\n  <span class=\"n\">get<\/span> <span class=\"ss\">:rust<\/span><span class=\"p\">,<\/span> <span class=\"ss\">to: <\/span><span class=\"s1\">'csv#rust'<\/span>\r\n<span class=\"k\">end<\/span>\r\n<\/code><\/pre>\n<p>\u6b21\u306b\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u306e\u8a2d\u5b9a\u3092\u3059\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nb\">require<\/span> <span class=\"s1\">'csv'<\/span>\r\n<span class=\"nb\">require<\/span> <span class=\"s1\">'ffi'<\/span>\r\n\r\n<span class=\"k\">class<\/span> <span class=\"nc\">CsvController<\/span> <span class=\"o\">&lt;<\/span> <span class=\"no\">ApplicationController<\/span>\r\n  <span class=\"k\">def<\/span> <span class=\"nf\">index<\/span>\r\n  <span class=\"k\">end<\/span>\r\n\r\n  <span class=\"k\">def<\/span> <span class=\"nf\">ruby<\/span>\r\n    <span class=\"n\">start_time<\/span> <span class=\"o\">=<\/span> <span class=\"no\">Time<\/span><span class=\"p\">.<\/span><span class=\"nf\">now<\/span>\r\n\r\n    <span class=\"n\">ruby_csv<\/span> <span class=\"o\">=<\/span> <span class=\"no\">CSV<\/span><span class=\"p\">.<\/span><span class=\"nf\">generate<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">csv<\/span><span class=\"o\">|<\/span>\r\n      <span class=\"n\">data_column<\/span> <span class=\"o\">=<\/span> <span class=\"no\">CsvTest<\/span><span class=\"p\">.<\/span><span class=\"nf\">column_names<\/span>\r\n      <span class=\"n\">data_column<\/span><span class=\"p\">.<\/span><span class=\"nf\">delete<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"created_at\"<\/span><span class=\"p\">)<\/span>\r\n      <span class=\"n\">data_column<\/span><span class=\"p\">.<\/span><span class=\"nf\">delete<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"updated_at\"<\/span><span class=\"p\">)<\/span>\r\n      <span class=\"n\">csv<\/span> <span class=\"o\">&lt;&lt;<\/span> <span class=\"n\">data_column<\/span>\r\n      <span class=\"no\">CsvTest<\/span><span class=\"p\">.<\/span><span class=\"nf\">all<\/span><span class=\"p\">.<\/span><span class=\"nf\">each<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">data<\/span><span class=\"o\">|<\/span>\r\n        <span class=\"n\">csv<\/span> <span class=\"o\">&lt;&lt;<\/span> <span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">attributes<\/span><span class=\"p\">.<\/span><span class=\"nf\">values_at<\/span><span class=\"p\">(<\/span><span class=\"o\">*<\/span><span class=\"n\">data_column<\/span><span class=\"p\">)<\/span>\r\n      <span class=\"k\">end<\/span>\r\n    <span class=\"k\">end<\/span>\r\n\r\n    <span class=\"nb\">puts<\/span> <span class=\"s1\">'------------------------------------------------------------'<\/span>\r\n    <span class=\"nb\">puts<\/span> <span class=\"s1\">'\u51e6\u7406\u306b\u304b\u304b\u3063\u305f\u6642\u9593'<\/span>\r\n    <span class=\"nb\">puts<\/span> <span class=\"no\">Time<\/span><span class=\"p\">.<\/span><span class=\"nf\">now<\/span> <span class=\"o\">-<\/span> <span class=\"n\">start_time<\/span>\r\n    <span class=\"nb\">puts<\/span> <span class=\"s1\">'------------------------------------------------------------'<\/span>\r\n\r\n    <span class=\"n\">respond_to<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"nb\">format<\/span><span class=\"o\">|<\/span>\r\n      <span class=\"nb\">format<\/span><span class=\"p\">.<\/span><span class=\"nf\">csv<\/span> <span class=\"p\">{<\/span> <span class=\"n\">send_data<\/span> <span class=\"n\">ruby_csv<\/span> <span class=\"p\">}<\/span>\r\n    <span class=\"k\">end<\/span>\r\n  <span class=\"k\">end<\/span>\r\n\r\n  <span class=\"k\">module<\/span> <span class=\"nn\">CSVmaker<\/span>\r\n    <span class=\"kp\">extend<\/span> <span class=\"no\">FFI<\/span><span class=\"o\">::<\/span><span class=\"no\">Library<\/span>\r\n    <span class=\"n\">ffi_lib<\/span> <span class=\"no\">Rails<\/span><span class=\"p\">.<\/span><span class=\"nf\">root<\/span> <span class=\"o\">+<\/span> <span class=\"s1\">'rust\/target\/release\/libcsv.dylib'<\/span>\r\n    <span class=\"n\">attach_function<\/span> <span class=\"ss\">:make_csv<\/span><span class=\"p\">,<\/span> <span class=\"p\">[],<\/span> <span class=\"ss\">:string<\/span>\r\n  <span class=\"k\">end<\/span>\r\n\r\n  <span class=\"k\">def<\/span> <span class=\"nf\">rust<\/span>\r\n    <span class=\"n\">start_time<\/span> <span class=\"o\">=<\/span> <span class=\"no\">Time<\/span><span class=\"p\">.<\/span><span class=\"nf\">now<\/span>\r\n\r\n    <span class=\"n\">rust_csv<\/span> <span class=\"o\">=<\/span> <span class=\"no\">CSVmaker<\/span><span class=\"p\">.<\/span><span class=\"nf\">make_csv<\/span>\r\n\r\n    <span class=\"nb\">puts<\/span> <span class=\"s1\">'------------------------------------------------------------'<\/span>\r\n    <span class=\"nb\">puts<\/span> <span class=\"s1\">'\u51e6\u7406\u306b\u304b\u304b\u3063\u305f\u6642\u9593'<\/span>\r\n    <span class=\"nb\">puts<\/span> <span class=\"no\">Time<\/span><span class=\"p\">.<\/span><span class=\"nf\">now<\/span> <span class=\"o\">-<\/span> <span class=\"n\">start_time<\/span>\r\n    <span class=\"nb\">puts<\/span> <span class=\"s1\">'------------------------------------------------------------'<\/span>\r\n\r\n    <span class=\"n\">respond_to<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"nb\">format<\/span><span class=\"o\">|<\/span>\r\n      <span class=\"nb\">format<\/span><span class=\"p\">.<\/span><span class=\"nf\">csv<\/span> <span class=\"p\">{<\/span> <span class=\"n\">send_data<\/span> <span class=\"n\">rust_csv<\/span> <span class=\"p\">}<\/span>\r\n    <span class=\"k\">end<\/span>\r\n  <span class=\"k\">end<\/span>\r\n<span class=\"k\">end<\/span>\r\n<\/code><\/pre>\n<p>\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u5185\u3067require\u3084module\u3092\u5b9a\u7fa9\u3059\u308b\u306e\u306f\u30ca\u30f3\u30bb\u30f3\u30b9\u3060\u304c\u3001\u5b9f\u9a13\u3067\u4f5c\u3063\u3066\u3044\u308b\u306e\u3067\u4eca\u56de\u306f\u3053\u306e\u3088\u3046\u306b\u3057\u305f\u3002<\/p>\n<p>\u4eca\u56de\u306e\u3088\u3046\u306a\u5358\u7d14\u306a\u6e2c\u5b9a\u3060\u3068CPU\u72b6\u614b\u3068\u304b\u306b\u51e6\u7406\u6642\u9593\u304c\u4f9d\u5b58\u3057\u305f\u308a\u3059\u308b\u306e\u3067\u3042\u307e\u308a\u826f\u304f\u306f\u306a\u3044\u304c\u3001\u51e6\u7406\u6642\u9593\u306e\u5dee\u306f\u304b\u306a\u308a\u306e\u5dee\u306b\u306a\u308b\u3068\u601d\u3063\u305f\u306e\u3067\u5358\u7d14\u306a\u6e2c\u5b9a\u306b\u3057\u3066\u3044\u308b\u3002<\/p>\n<p>module CSVmaker \u306f\u5f8c\u3005\u4f5c\u308bRust\u306e\u95a2\u6570\u3092\u4f7f\u3046\u3082\u306e\u3060\u3068\u8003\u3048\u3066\u304f\u308c\u308c\u3070\u826f\u3044(\u8a73\u3057\u304f\u306fRuby ffi\u3078)\u3002<\/p>\n<p>libcsv.dylib \u3053\u308c\u306fOS\u306b\u3088\u3063\u3066\u7570\u306a\u308b\u3068\u601d\u3046\u3002\u3053\u308c\u306b\u95a2\u3057\u3066\u306fRust\u5074\u306e\u8aac\u660e\u306e\u6642\u306b\u89e6\u308c\u308b\u3002<\/p>\n<h3>View\u306e\u8a2d\u5b9a<\/h3>\n<p>CSV\u5468\u308a\u306e\u6a5f\u80fd\u306a\u3069\u306f\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u306b\u3082\u305f\u305b\u305f\u306e\u3067\u307b\u3068\u3093\u3069\u3084\u308b\u3053\u3068\u306f\u306a\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code>&lt;%= link_to 'csv download(ver: ruby)', ruby_path(format: :csv) %&gt;\r\n&lt;%= link_to 'csv download(ver: rust)', rust_path(format: :csv) %&gt;\r\n<\/code><\/pre>\n<p>\u3053\u308c\u3067Rails\u5074\u306e\u8a2d\u5b9a\u306f\u5b8c\u4e86\u3002<\/p>\n<h2>Rust\u5074<\/h2>\n<p>Rails\u306e\u30eb\u30fc\u30c8\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3067 cargo new rust \u3068\u3059\u308b\u3002<br \/>\n\u305d\u3057\u3066\u751f\u6210\u3055\u308c\u305f\u30c7\u30a3\u30ec\u30af\u30c8\u306ecargo.toml\u3092\u6b21\u306e\u3088\u3046\u306b\u4fee\u6b63\u3059\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nn\">[package]<\/span>\r\n<span class=\"err\">\u3053\u3053\u306f\u7279\u306b\u3044\u3058\u3089\u306a\u3044<\/span>\r\n\r\n<span class=\"nn\">[dependencies]<\/span>\r\n<span class=\"py\">mysql<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"9.0.1\"<\/span>\r\n<span class=\"py\">libc<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"0.2.0\"<\/span>\r\n\r\n<span class=\"nn\">[lib]<\/span>\r\n<span class=\"py\">name<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"csv\"<\/span>\r\n<span class=\"py\">crate-type<\/span> <span class=\"p\">=<\/span> <span class=\"nn\">[\"dylib\"]<\/span>\r\n<\/code><\/pre>\n<p>\u6b21\u306b rust\/src\/lib.rs \u3092\u6b21\u306e\u3088\u3046\u306b\u3059\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">extern<\/span> <span class=\"n\">crate<\/span> <span class=\"n\">mysql<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">extern<\/span> <span class=\"n\">crate<\/span> <span class=\"n\">libc<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">libc<\/span><span class=\"p\">::<\/span><span class=\"o\">*<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">std<\/span><span class=\"p\">::<\/span><span class=\"nn\">ffi<\/span><span class=\"p\">::{<\/span><span class=\"n\">CString<\/span><span class=\"p\">};<\/span>\r\n\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">CsvTest<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">id<\/span><span class=\"p\">:<\/span> <span class=\"nb\">i32<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">hoge<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">foo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">hogefoo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">hogehoge<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">foofoo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">namehoge<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">namefoo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">namehogefoo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">namehogehoge<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">namefoofoo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"nd\">#[no_mangle]<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">extern<\/span> <span class=\"k\">fn<\/span> <span class=\"nf\">make_csv<\/span><span class=\"p\">()<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"o\">*<\/span><span class=\"k\">const<\/span> <span class=\"nb\">c_char<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"c\">\/\/ DB\u306e\u63a5\u7d9a<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">pool<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">mysql<\/span><span class=\"p\">::<\/span><span class=\"nn\">Pool<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"s\">\"mysql:\/\/root@localhost:3306\/csv_test_development\"<\/span><span class=\"p\">)<\/span><span class=\"nf\">.unwrap<\/span><span class=\"p\">();<\/span>\r\n\r\n    <span class=\"c\">\/\/ SELECT\u30af\u30a8\u30ea<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">select_all<\/span><span class=\"p\">:<\/span> <span class=\"nb\">Vec<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">CsvTest<\/span><span class=\"o\">&gt;<\/span> <span class=\"o\">=<\/span>\r\n        <span class=\"n\">pool<\/span><span class=\"nf\">.prep_exec<\/span><span class=\"p\">(<\/span><span class=\"s\">\"SELECT id, name, hoge, foo, hogefoo, hogehoge, foofoo, namehoge, namefoo, namehogefoo, namehogehoge, namefoofoo from csv_tests\"<\/span><span class=\"p\">,<\/span> <span class=\"p\">())<\/span>\r\n        <span class=\"nf\">.map<\/span><span class=\"p\">(|<\/span><span class=\"n\">result<\/span><span class=\"p\">|<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"n\">result<\/span><span class=\"nf\">.map<\/span><span class=\"p\">(|<\/span><span class=\"n\">x<\/span><span class=\"p\">|<\/span> <span class=\"n\">x<\/span><span class=\"nf\">.unwrap<\/span><span class=\"p\">())<\/span><span class=\"nf\">.map<\/span><span class=\"p\">(|<\/span><span class=\"n\">row<\/span><span class=\"p\">|<\/span> <span class=\"p\">{<\/span>\r\n                <span class=\"k\">let<\/span> <span class=\"p\">(<\/span><span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">,<\/span> <span class=\"n\">hoge<\/span><span class=\"p\">,<\/span> <span class=\"n\">foo<\/span><span class=\"p\">,<\/span> <span class=\"n\">hogefoo<\/span><span class=\"p\">,<\/span> <span class=\"n\">hogehoge<\/span><span class=\"p\">,<\/span> <span class=\"n\">foofoo<\/span><span class=\"p\">,<\/span> <span class=\"n\">namehoge<\/span><span class=\"p\">,<\/span> <span class=\"n\">namefoo<\/span><span class=\"p\">,<\/span> <span class=\"n\">namehogefoo<\/span><span class=\"p\">,<\/span> <span class=\"n\">namehogehoge<\/span><span class=\"p\">,<\/span> <span class=\"n\">namefoofoo<\/span><span class=\"p\">)<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">mysql<\/span><span class=\"p\">::<\/span><span class=\"nf\">from_row<\/span><span class=\"p\">(<\/span><span class=\"n\">row<\/span><span class=\"p\">);<\/span>\r\n                <span class=\"n\">CsvTest<\/span> <span class=\"p\">{<\/span>\r\n                    <span class=\"n\">id<\/span><span class=\"p\">:<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"n\">name<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">hoge<\/span><span class=\"p\">:<\/span> <span class=\"n\">hoge<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">foo<\/span><span class=\"p\">:<\/span> <span class=\"n\">foo<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">hogefoo<\/span><span class=\"p\">:<\/span> <span class=\"n\">hogefoo<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">hogehoge<\/span><span class=\"p\">:<\/span> <span class=\"n\">hogehoge<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">foofoo<\/span><span class=\"p\">:<\/span> <span class=\"n\">foofoo<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">namehoge<\/span><span class=\"p\">:<\/span> <span class=\"n\">namehoge<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">namefoo<\/span><span class=\"p\">:<\/span> <span class=\"n\">namefoo<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">namehogefoo<\/span><span class=\"p\">:<\/span> <span class=\"n\">namehogefoo<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">namehogehoge<\/span><span class=\"p\">:<\/span> <span class=\"n\">namehogehoge<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">namefoofoo<\/span><span class=\"p\">:<\/span> <span class=\"n\">namefoofoo<\/span><span class=\"p\">,<\/span>\r\n                <span class=\"p\">}<\/span>\r\n            <span class=\"p\">})<\/span><span class=\"nf\">.collect<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"p\">})<\/span><span class=\"nf\">.unwrap<\/span><span class=\"p\">();<\/span>\r\n\r\n    <span class=\"c\">\/\/ CSV\u306e\u4f5c\u6210<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"k\">mut<\/span> <span class=\"n\">rust_csv<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"n\">rust_csv<\/span> <span class=\"o\">=<\/span> <span class=\"nd\">format!<\/span><span class=\"p\">(<\/span><span class=\"s\">\"<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">id<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">name<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">hoge<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">foo<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">hogefoo<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">hogehoge<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">foofoo<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">namehoge<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">namefoo<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">namehogefoo<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">namehogehoge<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">namefoofoo<\/span><span class=\"se\">\\\"\\n<\/span><span class=\"s\">\"<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"k\">for<\/span> <span class=\"n\">i<\/span> <span class=\"n\">in<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">select_all<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">let<\/span> <span class=\"n\">record<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span> <span class=\"o\">=<\/span> <span class=\"nd\">format!<\/span><span class=\"p\">(<\/span><span class=\"s\">\"<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s\">{}<\/span><span class=\"se\">\\\"\\n<\/span><span class=\"s\">\"<\/span><span class=\"p\">,<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.id<\/span><span class=\"nf\">.to_string<\/span><span class=\"p\">(),<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.name<\/span><span class=\"p\">,<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.hoge<\/span><span class=\"p\">,<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.foo<\/span><span class=\"p\">,<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.hogefoo<\/span><span class=\"p\">,<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.hogehoge<\/span><span class=\"p\">,<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.foofoo<\/span><span class=\"p\">,<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.namehoge<\/span><span class=\"p\">,<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.namefoo<\/span><span class=\"p\">,<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.namehogefoo<\/span><span class=\"p\">,<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.namehogehoge<\/span><span class=\"p\">,<\/span>\r\n                                     <span class=\"n\">i<\/span><span class=\"py\">.namefoofoo<\/span>\r\n        <span class=\"p\">);<\/span>\r\n\r\n        <span class=\"n\">rust_csv<\/span><span class=\"nf\">.push_str<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">record<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"nn\">CString<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"n\">rust_csv<\/span><span class=\"p\">)<\/span><span class=\"nf\">.unwrap<\/span><span class=\"p\">()<\/span><span class=\"nf\">.into_raw<\/span><span class=\"p\">()<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>struct\u306f\u69cb\u9020\u4f53\u306a\u306e\u3067\u8aac\u660e\u306fRust\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u304a\u9858\u3044\u3059\u308b\u3002<\/p>\n<p>make_csv\u95a2\u6570\u306b\u3064\u3044\u3066<\/p>\n<blockquote><p>let pool = mysql::Pool::new(&#8220;mysql:\/\/root@localhost:3306\/csv_test_development&#8221;).unwrap();<\/p><\/blockquote>\n<p>\u3053\u308c\u306fDB\u3078\u306e\u63a5\u7d9a\u3092\u884c\u3046\u3002\u74b0\u5883\u306b\u3088\u3063\u3066\u306f\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u5fc5\u8981\u306b\u306a\u3063\u305f\u308a\u306a\u3069\u3042\u308b\u3068\u601d\u3046\u306e\u3067new\u4ee5\u4e0b\u3092\u500b\u4eba\u306e\u8a2d\u5b9a\u306b\u5408\u308f\u305b\u3066\u4fee\u6b63\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/p>\n<blockquote><p>let select_all = &#8230;<\/p><\/blockquote>\n<p>\u3053\u3053\u306f\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u307b\u307c\u771f\u4f3c\u3066\u3044\u308b\u3002<br \/>\n\u8a73\u3057\u304f\u306f http:\/\/blackbeam.org\/doc\/mysql\/index.html<\/p>\n<blockquote><p>\/\/ CSV\u306e\u4f5c\u6210 \u4ee5\u4e0b<\/p><\/blockquote>\n<p>\u3053\u3061\u3089\u306fCSV\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u5408\u308f\u3057\u3066\u6587\u5b57\u5217\u3092\u751f\u6210\u3057\u3066\u3044\u308b\u3002<\/p>\n<blockquote><p>CString::new(rust_csv).unwrap().into_raw()<\/p><\/blockquote>\n<p>\u3053\u3061\u3089\u306fC\u306e\u6587\u5b57\u5217\u306b\u4fee\u6b63\u3057\u3066Ruby\u306b\u6e21\u3059\u305f\u3081\u306e\u3082\u306e\u3067\u3042\u308b\u3002<br \/>\npub extern fn make_csv() -&gt; *const c_char<br \/>\n\u3053\u308c\u306e\u8fd4\u308a\u5024\u306e\u578b\u3092string\u306b\u3059\u308b\u3068Ruby\u3067\u547c\u3073\u51fa\u3057\u305f\u6642\u30bb\u30b0\u30e1\u30f3\u30c8\u30d5\u30a9\u30eb\u30c8\u3068\u306a\u308b\u3002<\/p>\n<h3>build<\/h3>\n<p>rust\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3067 cargo build &#8211;release \u3068\u3059\u308b\u3002<br \/>\n\u5b8c\u4e86\u3057\u305f\u3089 ls target\/release \u3068\u3057\u3066 libcsv.dylib \u306e\u3088\u3046\u306a\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308b\u304b\u78ba\u8a8d\u3092\u3059\u308b\u3002<br \/>\n\u305f\u3060\u3057\u3001\u3053\u308c\u306fOS\u306b\u3088\u3063\u3066\u62e1\u5f35\u5b50\u304c\u9055\u3063\u305f\u308a\u3059\u308b\u3068\u601d\u3046\u3002<br \/>\nMac\u3067\u306flibcsv.dylib\u3060\u3063\u305f\u3002<\/p>\n<p>\u3053\u308c\u3092\u3055\u304d\u307b\u3069Rails\u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u5185\u306b\u5b9a\u7fa9\u3057\u3066module\u3067\u8aad\u307f\u8fbc\u3080\u3002<\/p>\n<blockquote><p>module CSVmaker<br \/>\nextend FFI::Library<br \/>\nffi_lib Rails.root + &#8216;rust\/target\/release\/libcsv.dylib&#8217;<br \/>\nattach_function :make_csv, [], :string<br \/>\nend<\/p><\/blockquote>\n<p>\u3053\u3046\u3059\u308b\u3053\u3068\u3067Rust\u306e\u95a2\u6570\u3092Ruby\u3067\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/p>\n<h2>\u5b9f\u9a13<\/h2>\n<p>\u4ee5\u4e0a\u3067\u8a2d\u5b9a\u306f\u5b8c\u4e86\u3057\u305f\u306e\u3067 bundle exec rails s \u3068\u3057\u3066\u3001\u30b5\u30fc\u30d0\u3092\u7acb\u3061\u4e0a\u3052\u308b\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8 2017-01-30 13.47.46.png\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d5e3837434c4406cf4837\/57-0.png\" alt=\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8 2017-01-30 13.47.46.png\" \/><\/div>\n<p>\u3053\u306e\u3088\u3046\u306a\u753b\u9762\u304c\u51fa\u3066\u304f\u308b\u306e\u3067\u5f8c\u306f\u30ea\u30f3\u30af\u3092\u62bc\u3059\u3002<br \/>\n\u7121\u4e8bCSV\u304c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u305f\u3089Rails\u3092\u7acb\u3061\u4e0a\u3052\u305f\u30bf\u30fc\u30df\u30ca\u30eb\u306b\u884c\u304f\u3068\u4f55\u79d2\u304b\u304b\u3063\u305f\u304b\u3092\u898b\u308b\u4e8b\u304c\u3067\u304d\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code>------------------------------------------------------------\r\n\u51e6\u7406\u306b\u304b\u304b\u3063\u305f\u6642\u9593\r\n10.226519\r\n------------------------------------------------------------\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>------------------------------------------------------------\r\n\u51e6\u7406\u306b\u304b\u304b\u3063\u305f\u6642\u9593\r\n146.68222\r\n------------------------------------------------------------\r\n<\/code><\/pre>\n<p>\u4e0a\u304cRust\u306e\u51e6\u7406\u3067\u4e0b\u304cRuby\u306e\u51e6\u7406\u3002<\/p>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>Ruby\u306750\u4e07\u30ec\u30b3\u30fc\u30c9\u3067\u306eCSV\u51e6\u7406\u3092\u3057\u305f\u6642\u30e1\u30e2\u30ea\u3092\u30d0\u30ab\u98df\u3044\u3057\u3066\u3044\u305f\u306e\u3067\u5927\u304d\u3044\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u306f\u6975\u529bRuby\u3092\u907f\u3051\u305f\u307b\u3046\u304c\u3044\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<br \/>\n\u4eca\u56de\u306f\u5b9f\u9a13\u7684\u306b\u4f5c\u3063\u3066\u307f\u307e\u3057\u305f\u304c\u3001\u672c\u683c\u7684\u306b\u4f5c\u308c\u3070\u4e00\u90e8\u306e\u51e6\u7406\u3092Rust\u306b\u4efb\u305b\u308b\u306e\u306f\u3042\u308a\u3060\u3068\u601d\u3044\u307e\u3057\u305f\u3002<\/p>\n<h2>\u304a\u307e\u3051(Rails\u306e\u74b0\u5883\u69cb\u7bc9)<\/h2>\n<p>\u307e\u305a\u3001rbenv\u306a\u3069\u3067ruby2.3.3\u3092\u5165\u308c\u307e\u3059\u3002<br \/>\n\u6b21\u306b gem install bundle \u3068\u3057\u307e\u3059\u3002<\/p>\n<p>\u304a\u597d\u304d\u306a\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3067<\/p>\n<pre class=\"post-pre\"><code><span class=\"n\">source<\/span> <span class=\"s1\">'https:\/\/rubygems.org'<\/span>\r\n\r\n<span class=\"n\">gem<\/span> <span class=\"s1\">'rails'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'~&gt; 5.0.1'<\/span>\r\n<\/code><\/pre>\n<p>\u3092\u4f5c\u308a\u307e\u3059\u3002<br \/>\nbundle install &#8211;path vendor\/bundle \u3068\u3057\u307e\u3059\u3002<br \/>\npath\u3092\u6307\u5b9a\u3057\u305f\u969b\u3001gitignore\u3067 vendor\/bundle \u3068\u3057\u3066\u304b\u3089Git\u306b\u5165\u308c\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>bundle exec rails new . -BTf -d mysql \u3068\u3059\u308c\u3070\u4eca\u56de\u4f7f\u3046\u74b0\u5883\u306e\u51fa\u6765\u4e0a\u304c\u308a\u3067\u3059\u3002<\/p>\n<blockquote><p>bundle\u306f gem install \u3068\u306f\u7570\u306a\u308b\u306e\u3067 rails s \u306a\u3069\u306e\u3088\u3046\u306a\u30b3\u30de\u30f3\u30c9\u3092\u6253\u3064\u6642\u306f\u982d\u306b bundle exec \u3068\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p><\/blockquote>\n<h2>\u8ffd\u8a182017\/01\/30 19:00<\/h2>\n<p>CSV\u306e\u3068\u3053\u308d\u3092Ruby\u3067\u306f\u6a19\u6e96\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u4f7f\u3063\u3066\u3044\u305f\u304c\u3001Rust\u3067\u306f\u72ec\u81ea\u306b\u51e6\u7406\u3057\u305f\u5f62\u3068\u306a\u3063\u3066\u3044\u308b\u306e\u3067Ruby\u306e\u65b9\u3092Rust\u306b\u5408\u308f\u305b\u3066\u307f\u305f\u3002<\/p>\n<pre class=\"post-pre\"><code>    <span class=\"n\">ruby_csv<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">\"<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">id<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">name<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">hoge<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">foo<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">hogefoo<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">hogehoge<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">foofoo<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">namehoge<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">namefoo<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">namehogefoo<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">namehogehoge<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">namefoofoo<\/span><span class=\"se\">\\\"\\n<\/span><span class=\"s2\">\"<\/span>\r\n    <span class=\"no\">CsvTest<\/span><span class=\"p\">.<\/span><span class=\"nf\">all<\/span><span class=\"p\">.<\/span><span class=\"nf\">each<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">data<\/span><span class=\"o\">|<\/span>\r\n      <span class=\"n\">ruby_csv<\/span> <span class=\"o\">&lt;&lt;<\/span> <span class=\"s2\">\"<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">id<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">name<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">hoge<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">foo<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">hogefoo<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">hogehoge<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">foofoo<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">namehoge<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">namefoo<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">namehogefoo<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">namehogehoge<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">,<\/span><span class=\"se\">\\\"<\/span><span class=\"si\">#{<\/span><span class=\"n\">data<\/span><span class=\"p\">.<\/span><span class=\"nf\">namefoofoo<\/span><span class=\"si\">}<\/span><span class=\"se\">\\\"\\n<\/span><span class=\"s2\">\"<\/span>\r\n    <span class=\"k\">end<\/span>\r\n<\/code><\/pre>\n<p>CSV.generate \u306e\u90e8\u5206\u3092\u4e0a\u8a18\u306e\u3088\u3046\u306b\u7f6e\u304d\u63db\u3048\u307e\u3057\u305f\u3002<br \/>\n\u3053\u3061\u3089\u3067\u5b9f\u9a13\u3057\u305f\u3068\u3053\u308d<\/p>\n<pre class=\"post-pre\"><code>------------------------------------------------------------\r\n\u51e6\u7406\u306b\u304b\u304b\u3063\u305f\u6642\u9593\r\n73.224735\r\n------------------------------------------------------------\r\n<\/code><\/pre>\n<p>\u3068\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u516c\u5f0fCSV\u30e9\u30a4\u30d6\u30e9\u30ea\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u66f8\u3044\u3066\u3042\u308b<\/p>\n<blockquote><p>\u4e0d\u6b63\u306a CSV \u30c7\u30fc\u30bf\u3092\u4e0e\u3048\u305f\u304f\u306a\u3044\u3002\u3042\u308b\u30d5\u30a3\u30fc\u30eb\u30c9\u304c\u4e0d\u6b63\u3067\u3042\u308b\u3053\u3068\u304c\u78ba\u5b9a\u3059 \u308b\u306e\u306f\u30d5\u30a1\u30a4\u30eb\u3092\u5168\u3066\u8aad\u307f\u8fbc\u3093\u3060\u5f8c\u3067\u3059\u3002\u3053\u308c\u306f\u591a\u304f\u306e\u6642\u9593\u3084\u30e1\u30e2\u30ea\u3092\u6d88\u8cbb\u3057 \u307e\u3059\u3002<\/p><\/blockquote>\n<p>\u3053\u3053\u306e\u90e8\u5206\u306e\u51e6\u7406\u306e\u305f\u3081\u30e1\u30e2\u30ea\u3084\u51e6\u7406\u6642\u9593\u3092\u6d88\u8cbb\u3057\u3066\u3044\u305f\u307f\u305f\u3044\u3067\u3059\u3002<\/p>\n<h2>\u8ffd\u8a182017\/02\/02 14:00<\/h2>\n<h3>\u3054\u6307\u6458\u3044\u305f\u3060\u3044\u305fCSV\u30af\u30ec\u30fc\u30c8\u3092\u7528\u3044\u3066\u306e\u51e6\u7406ver<\/h3>\n<blockquote><p>Rails\u5074\u306e\u5909\u66f4\u70b9\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p><\/blockquote>\n<p>Cargo.toml\u306b\u8ffd\u8a18\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u306e\u3067\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nn\">[dependencies]<\/span>\r\n<span class=\"py\">mysql<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"9.0.1\"<\/span>\r\n<span class=\"py\">libc<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"0.2.0\"<\/span>\r\n<span class=\"py\">csv<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"0.14\"<\/span>\r\n<span class=\"py\">rustc-serialize<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"0.3.22\"<\/span>\r\n\r\n<span class=\"nn\">[lib]<\/span>\r\n<span class=\"py\">name<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"csv\"<\/span>\r\n<span class=\"py\">crate-type<\/span> <span class=\"p\">=<\/span> <span class=\"nn\">[\"dylib\"]<\/span>\r\n<\/code><\/pre>\n<p>\u6b21\u306b rust\/src\/lib.rs \u306e\u4fee\u6b63\u3092\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">extern<\/span> <span class=\"n\">crate<\/span> <span class=\"n\">mysql<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">extern<\/span> <span class=\"n\">crate<\/span> <span class=\"n\">libc<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">extern<\/span> <span class=\"n\">crate<\/span> <span class=\"n\">csv<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">extern<\/span> <span class=\"n\">crate<\/span> <span class=\"n\">rustc_serialize<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">libc<\/span><span class=\"p\">::<\/span><span class=\"o\">*<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">std<\/span><span class=\"p\">::<\/span><span class=\"nn\">ffi<\/span><span class=\"p\">::{<\/span><span class=\"n\">CString<\/span><span class=\"p\">};<\/span>\r\n\r\n<span class=\"nd\">#[derive(RustcEncodable)]<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">CsvTest<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">id<\/span><span class=\"p\">:<\/span> <span class=\"nb\">i32<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">hoge<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">foo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">hogefoo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">hogehoge<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">foofoo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">namehoge<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">namefoo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">namehogefoo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">namehogehoge<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">namefoofoo<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"nd\">#[no_mangle]<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">extern<\/span> <span class=\"k\">fn<\/span> <span class=\"nf\">make_csv<\/span><span class=\"p\">()<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"o\">*<\/span><span class=\"k\">const<\/span> <span class=\"nb\">c_char<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"c\">\/\/ DB\u306e\u63a5\u7d9a<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">pool<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">mysql<\/span><span class=\"p\">::<\/span><span class=\"nn\">Pool<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"s\">\"mysql:\/\/root@localhost:3306\/csv_test_development\"<\/span><span class=\"p\">)<\/span><span class=\"nf\">.unwrap<\/span><span class=\"p\">();<\/span>\r\n\r\n    <span class=\"c\">\/\/ SELECT<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">select_all<\/span><span class=\"p\">:<\/span> <span class=\"nb\">Vec<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">CsvTest<\/span><span class=\"o\">&gt;<\/span> <span class=\"o\">=<\/span>\r\n        <span class=\"n\">pool<\/span><span class=\"nf\">.prep_exec<\/span><span class=\"p\">(<\/span><span class=\"s\">\"SELECT id, name, hoge, foo, hogefoo, hogehoge, foofoo, namehoge, namefoo, namehogefoo, namehogehoge, namefoofoo from csv_tests\"<\/span><span class=\"p\">,<\/span> <span class=\"p\">())<\/span>\r\n        <span class=\"nf\">.map<\/span><span class=\"p\">(|<\/span><span class=\"n\">result<\/span><span class=\"p\">|<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"n\">result<\/span><span class=\"nf\">.map<\/span><span class=\"p\">(|<\/span><span class=\"n\">x<\/span><span class=\"p\">|<\/span> <span class=\"n\">x<\/span><span class=\"nf\">.unwrap<\/span><span class=\"p\">())<\/span><span class=\"nf\">.map<\/span><span class=\"p\">(|<\/span><span class=\"n\">row<\/span><span class=\"p\">|<\/span> <span class=\"p\">{<\/span>\r\n                <span class=\"k\">let<\/span> <span class=\"p\">(<\/span><span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">,<\/span> <span class=\"n\">hoge<\/span><span class=\"p\">,<\/span> <span class=\"n\">foo<\/span><span class=\"p\">,<\/span> <span class=\"n\">hogefoo<\/span><span class=\"p\">,<\/span> <span class=\"n\">hogehoge<\/span><span class=\"p\">,<\/span> <span class=\"n\">foofoo<\/span><span class=\"p\">,<\/span> <span class=\"n\">namehoge<\/span><span class=\"p\">,<\/span> <span class=\"n\">namefoo<\/span><span class=\"p\">,<\/span> <span class=\"n\">namehogefoo<\/span><span class=\"p\">,<\/span> <span class=\"n\">namehogehoge<\/span><span class=\"p\">,<\/span> <span class=\"n\">namefoofoo<\/span><span class=\"p\">)<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">mysql<\/span><span class=\"p\">::<\/span><span class=\"nf\">from_row<\/span><span class=\"p\">(<\/span><span class=\"n\">row<\/span><span class=\"p\">);<\/span>\r\n                <span class=\"n\">CsvTest<\/span> <span class=\"p\">{<\/span>\r\n                    <span class=\"n\">id<\/span><span class=\"p\">:<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"n\">name<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">hoge<\/span><span class=\"p\">:<\/span> <span class=\"n\">hoge<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">foo<\/span><span class=\"p\">:<\/span> <span class=\"n\">foo<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">hogefoo<\/span><span class=\"p\">:<\/span> <span class=\"n\">hogefoo<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">hogehoge<\/span><span class=\"p\">:<\/span> <span class=\"n\">hogehoge<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">foofoo<\/span><span class=\"p\">:<\/span> <span class=\"n\">foofoo<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">namehoge<\/span><span class=\"p\">:<\/span> <span class=\"n\">namehoge<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">namefoo<\/span><span class=\"p\">:<\/span> <span class=\"n\">namefoo<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">namehogefoo<\/span><span class=\"p\">:<\/span> <span class=\"n\">namehogefoo<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">namehogehoge<\/span><span class=\"p\">:<\/span> <span class=\"n\">namehogehoge<\/span><span class=\"p\">,<\/span>\r\n                    <span class=\"n\">namefoofoo<\/span><span class=\"p\">:<\/span> <span class=\"n\">namefoofoo<\/span><span class=\"p\">,<\/span>\r\n                <span class=\"p\">}<\/span>\r\n            <span class=\"p\">})<\/span><span class=\"nf\">.collect<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"p\">})<\/span><span class=\"nf\">.unwrap<\/span><span class=\"p\">();<\/span>\r\n\r\n    <span class=\"c\">\/\/ CSV\u306e\u4f5c\u6210<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"k\">mut<\/span> <span class=\"n\">rust_csv<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">csv<\/span><span class=\"p\">::<\/span><span class=\"nn\">Writer<\/span><span class=\"p\">::<\/span><span class=\"nf\">from_memory<\/span><span class=\"p\">();<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">header<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"s\">\"id\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"name\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"hoge\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"foo\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"hogefoo\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"hogehoge\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"foofoo\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"namehoge\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"namefoo\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"namehogefoo\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"namehogehoge\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"namefoofoo\"<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"n\">rust_csv<\/span><span class=\"nf\">.encode<\/span><span class=\"p\">(<\/span><span class=\"n\">header<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"k\">for<\/span> <span class=\"n\">i<\/span> <span class=\"n\">in<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">select_all<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">rust_csv<\/span><span class=\"nf\">.encode<\/span><span class=\"p\">(<\/span><span class=\"n\">i<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"nn\">CString<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"n\">rust_csv<\/span><span class=\"nf\">.as_string<\/span><span class=\"p\">())<\/span><span class=\"nf\">.unwrap<\/span><span class=\"p\">()<\/span><span class=\"nf\">.into_raw<\/span><span class=\"p\">()<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u4e3b\u306a\u5909\u66f4\u70b9\u306fCSV\u306e\u4f5c\u6210\u306e\u3068\u3053\u308d\u3067\u3059\u3002<br \/>\nCSV\u30af\u30ec\u30fc\u30c8\u3092\u4f7f\u3046\u305f\u3081\u306b<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">extern<\/span> <span class=\"n\">crate<\/span> <span class=\"n\">csv<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">extern<\/span> <span class=\"n\">crate<\/span> <span class=\"n\">rustc_serialize<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<p>\u3068\u30d5\u30a1\u30a4\u30eb\u306e\u5148\u982d\u306b\u66f8\u304d\u3001\u69cb\u9020\u4f53\u306e\u4e0a\u306b #[derive(RustcEncodable)] \u3092\u3064\u3051\u307e\u3059\u3002<br \/>\n\u3042\u3068\u306f CSV\u30af\u30ec\u30fc\u30c8\u306e\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8 \u3092\u53c2\u8003\u306b\u3057\u306a\u304c\u3089CSV\u306e\u4f5c\u6210\u90e8\u5206\u3092\u5909\u66f4\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u4fee\u6b63\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3089 rust \u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3067 $ cargo build &#8211;release \u3068\u3057\u3066 Rails \u30b5\u30fc\u30d0\u3092\u7acb\u3061\u4e0a\u3052\u308b\u3060\u3051\u3067\u3059\u3002<\/p>\n<p>\u3053\u3061\u3089\u3067CSV\u3092\u843d\u3068\u3057\u305f\u3068\u3053\u308d<\/p>\n<pre class=\"post-pre\"><code>------------------------------------------------------------\r\n\u51e6\u7406\u306b\u304b\u304b\u3063\u305f\u6642\u9593\r\n10.199653\r\n------------------------------------------------------------\r\n<\/code><\/pre>\n<p>\u3068\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u4eca\u56de\u306e\u6e2c\u5b9a\u6cd5\u304cCPU\u306e\u72b6\u614b\u306a\u3069\u306b\u8a08\u6e2c\u6642\u9593\u304c\u4f9d\u5b58\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u8003\u616e\u3057\u3066\u3082\u5341\u5206\u306b\u65e9\u304fCSV\u51e6\u7406\u304c\u51fa\u6765\u3066\u3044\u308b\u3068\u8003\u3048\u3089\u308c\u307e\u3059\u3002<br \/>\nRails\u3067\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u306b\u306a\u308a\u3084\u3059\u3044\u30d3\u30b8\u30cd\u30b9\u30ed\u30b8\u30c3\u30af\u90e8\u5206\u3092Rust\u306b\u4efb\u305b\u3066\u307f\u308b\u3068\u826f\u3055\u305d\u3046\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u80cc\u666f Rails\u3067CSV\u3092\u8fd4\u3059\u6642\u300110\u4e07\u30c7\u30fc\u30bf\u304f\u3089\u3044\u306e\u3082\u306e\u3092\u666e\u901a\u306b\u51e6\u7406\u3059\u308b\u3068\u30e1\u30e2\u30ea\u3092\u98df\u3044\u6f70\u3057\u305f\u308a\u3001\u51e6\u7406\u304c\u9045\u304b\u3063 [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-45275","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>- Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:description\" content=\"\u80cc\u666f Rails\u3067CSV\u3092\u8fd4\u3059\u6642\u300110\u4e07\u30c7\u30fc\u30bf\u304f\u3089\u3044\u306e\u3082\u306e\u3092\u666e\u901a\u306b\u51e6\u7406\u3059\u308b\u3068\u30e1\u30e2\u30ea\u3092\u98df\u3044\u6f70\u3057\u305f\u308a\u3001\u51e6\u7406\u304c\u9045\u304b\u3063 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-22T18:37:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-30T09:39:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d5e3837434c4406cf4837\/57-0.png\" \/>\n<meta name=\"author\" content=\"\u6e05, \u626c\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u626c\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/\",\"name\":\"- Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-04-22T18:37:52+00:00\",\"dateModified\":\"2024-04-30T09:39:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\",\"name\":\"\u6e05, \u626c\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u626c\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"- Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/","og_locale":"zh_CN","og_type":"article","og_description":"\u80cc\u666f Rails\u3067CSV\u3092\u8fd4\u3059\u6642\u300110\u4e07\u30c7\u30fc\u30bf\u304f\u3089\u3044\u306e\u3082\u306e\u3092\u666e\u901a\u306b\u51e6\u7406\u3059\u308b\u3068\u30e1\u30e2\u30ea\u3092\u98df\u3044\u6f70\u3057\u305f\u308a\u3001\u51e6\u7406\u304c\u9045\u304b\u3063 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-04-22T18:37:52+00:00","article_modified_time":"2024-04-30T09:39:00+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d5e3837434c4406cf4837\/57-0.png"}],"author":"\u6e05, \u626c","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u626c","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"6 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/","name":"- Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-04-22T18:37:52+00:00","dateModified":"2024-04-30T09:39:00+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461","name":"\u6e05, \u626c","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","caption":"\u6e05, \u626c"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/45275-2\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/45275","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=45275"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/45275\/revisions"}],"predecessor-version":[{"id":93329,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/45275\/revisions\/93329"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=45275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=45275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=45275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}