Get In That DB! Parsing CSV Using Ruby...
        Posted  
        
            by keruilin
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by keruilin
        
        
        
        Published on 2010-04-09T18:28:25Z
        Indexed on 
            2010/04/09
            21:23 UTC
        
        
        Read the original article
        Hit count: 449
        
I have a CSV file formatted just like this:
name,color,tasty,qty
apple,red,true,3
orange,orange,false,4
pear,greenish-yellowish,true,1
As you can see, each column in the Ruby OO world represents a mix of types -- string, string, boolean, int.
Now, ultimately, I want to parse each line in the file, determine the appropriate type, and insert that row into a database via a Rails migration. For ex:
Fruit.create(:name => 'apple', :color => 'red', :tasty => true, :qty => 3)
Help!
© Stack Overflow or respective owner