rails on oracle (oracleで接続する手順) その２■概要 rails on oracle でいくつかのテーマで検証してみます ●fetchループ module FetchTest SQL = "select p1.* from posts p1 cross join posts p2" def self.run Post.delete_all 200.times do |i| Post.create(:title => "title_#{i}", :body => "body_#{i}") end open("test.txt", "w") do |f| # ① Post.find_by_sql(SQL).each { |r| f.write "#{r}\r\n" } # ② Post.connection.raw_connection.exec(SQL) { |r| f.write "#{r}\r\n" } end end end Fe
