Replica Breguet Marine Collection - Simple 5817ST/Y2/5V8 watch [5817ST/Y2/5V8] - $202.99 : TITLE, SI
Replica Breguet Marine Collection - Simple 5817ST/Y2/5V8 watch [5817ST/Y2/5V8] - $202.99 : TITLE, SITE_TAGLINE
Ruby on Rails: Convert Table into CSV
Ruby scripts example about how to read table data and convert it into CSV
require 'odbc'
require 'dbi'
filename = "./file.csv"
writeFile = File.open(filename,"w")
dbh = DBI.connect('DBI:ODBC:data_source_name', 'username', 'password')
sth = dbh.prepare("SELECT * FROM table WITH UR")
sth.execute
writeFile.puts sth.column_names.join(" ; ") #puts names on the top of each row
while row=sth.fetch do
writeFile.puts row.join(" ; ") #puts lines from table
end
sth.finish
dbh.disconnect
writeFile.close
Shared By
Andrew Webb
@ : Mar 20th 2011, 07:33 # : ruby on rails, convert, csv
Web Developer, Web Programmer, Python Junky
Discuss
More Ruby on Rails Codes
- 2012 Graceful Empire Waist Strapless Applique Customer-made Dress (PWD-020) [PWD-020] - $170.99 : TI
- Tiffany Rings,cheap Tiffany Rings,discount Tiffany Rings,Tiffany Rings online,Tiffany Rings sale,Tif
- Balenciaga Crocodile Veins Leather Papier Top Handle Bag Black [BalenciagaCD37] - $244.00 : TITLE, S
- Replica Hermes Watches,fake Hermes Watches,copy Hermes Watches,Hermes Watches sale,discount Hermes W
Joined Today, 02:55
