sqlでデータ名が異なる場合テーブルに挿入

require 'rubygems'
require 'sqlite3'



f=open("food_list_2014_12_03_b.txt")


f=f.map{|i| i.split(",")}.sort_by{|elem| elem[3];}

#f.each{|i|

#       puts i;
#}

#exit

db=SQLite3::Database.new("syoku.sqlite3")

f.each{|data|
     
        foodname=data[1]

        last_update="1001-01-01"
        recode_date=data[3].split(" ")[0];
        status="T"
        update_status1=""
        update_status2="F"

        id_list_max=db.execute("select id from food_list;").max
        id=id_list_max[0].to_i+1
        #puts recode_date;
        #puts id
        f=db.execute("select * from food_list where foodname=\"#{foodname}\";")


        #puts id_list;

        #exit

        if f.length==0 then

                db.execute("insert into food_list values(#{id},\"#{foodname}\",\"#{recode_date}\",\"#{last_update}\",\"#{status}\",\"#{update_status1}\",\"#{update_status2}\");")
                #f=db.execute("select * from food_list where foodname=\"#{data[1]}\";")
        end
}