道喜技术日记 .^. 天天红玉世界. Rails技术系列：使用命令script/runner实现输出文件csv

Rails技术系列：使用命令script/runner实现输出文件csv

由Gudao Luo在2009-07-10 at 21:05发表的

export-csv-in-console-2009-07-10 2231

使用命令script/runner实现输出文件csv

具体实现步骤

安装Rails框架插件fastercsv
sudo gem install fastercsv

创建Rails应用软件
rails demo && cd demo
ruby script/generate scaffold post title:string body:text published:boolean
rake db:migrate && rake db:fixtures:load

实现输出文件csv代码
vim lib/export_csv.rb

文件lib/export_csv.rb代码清单

require 'fastercsv'FasterCSV.open("posts.csv", "w") do |csv|
  Post.all.each do |object|
    csv << object.attributes.values
  end
end

运行输出文件csv的代码
script/runner lib/export_csv.rb

查看导入数据库数据
cat cat test/fixtures/posts.yml

文件test/fixtures/posts.yml数据清单

# Read about fixtures at http://ar.rubyonrails.org/classes/Fixtures.html
one:
  title: MyString
  body: MyText
  published: false
two:
  title: MyString
  body: MyText
  published: false

使用终端查看导出文件csv数据
cat posts.csv

文件posts.csv数据清单

Fri Jul 10 20:14:57 UTC 2009,MyString,MyText,false,953125641,Fri Jul 10 20:14:57 UTC 2009
Fri Jul 10 20:14:57 UTC 2009,MyString,MyText,false,996332877,Fri Jul 10 20:14:57 UTC 2009

使用OpenOffcie查看导出文件csv数据
open posts.csv

说明
- quickly-export-a-table-to-csv-in-the-rails-console-with-fastercsv

Tags: Rails, console, csv, export, terminal

Hierarchy: previous, next

Comments

There are 0 comments on this post. Post yours →

Post a comment

Required fields in bold.