我希望脚本保存结果为.csv或.txt文件。我的脚本必须执行选择进入mssql数据库,并发送此请求的所有字符串的电子邮件。我的代码:
require 'tiny_tds'
require 'csv'
@db_host = 'myserver.com'
@db_user = 'mylogin'
@db_pass = 'mypassword'
client = TinyTds::Client.new(:host => @db_host, :username => @db_user, :password => @db_pass)
results = client.execute(" SELECT * FROM mydatabase ")
results.each do |row|
p $rows = row.to_a
p h = $rows
CSV.open("data.csv", "wb") {|csv| h.to_a.each {|elem| csv << elem} }
end我的问题是:
生成的csv文件只包含我的请求的第一行。如何将我请求的所有字符串写入文件?
发布于 2017-02-09 18:34:54
这个怎么样?在results循环之外创建CSV。
require 'tiny_tds'
require 'csv'
db_host = 'myserver.com'
db_user = 'mylogin'
db_pass = 'mypassword'
client = TinyTds::Client.new(:host => db_host, :username => db_user, :password => db_pass)
results = client.execute("SELECT * FROM mydatabase")
CSV.open("data.csv", "wb") do |csv|
results.each do |row|
csv << row.to_a
end
end发布于 2017-02-09 18:34:43
您似乎已经在results中有了一个矩阵。因此,不是这样:
results.each do |row|
rows = row.to_a
CSV.open("data.csv", "wb") do |csv|
rows.to_a.each { |elem| csv << elem}
end
end您只需将矩阵转换为数组数组,并将其提供给CSV
results.map! { |row| row.to_a.map(&:to_a) }
CSV.open("data.csv", "wb") { |csv| csv.replace results }https://stackoverflow.com/questions/42133507
复制相似问题