Convert CSV to Sqlite records.

sequel_sqlite_example.rb

require 'sequel'
require 'csv'

csv_records = CSV.read('records.csv')

DB = Sequel.connect('jdbc:sqlite::memory:')

DB.create_table(:records) do
  Integer :id, :primary_key => true
  String :member_id, :null => false
  String :lob, :null => false
  String :region, :null => false
  Date :region_eff, :null => false #Sequel.string_to_date('2010-09-10') # Date.civil(2010, 09, 10)
  String :pcp, :null => false
  Date :pcp_eff, :null => false #Sequel.string_to_date('2010-09-10') # Date.civil(2010, 09, 10)
end

DB[:records].import([:member_id, :lob, :region, :region_eff, :pcp, :pcp_eff], csv_records)

p DB[:records].all