require 'rubygems'
require 'dm-core'
require 'dm-migrations'
require 'cheap_imports'

DataMapper.setup(:default, 'sqlite3:dm-example.sqlite3')

class Payment
  include DataMapper::Resource
  include CheapImports

  property :id, Serial
  property :name, String
  property :paid_on, DateTime
  property :price, Decimal

  imports :tarp_transactions => {
    :paid_on => 'Date',
    :paid_on_format => '%Y-%m-%d',
    :name => 'Name',
    :price => 'Price Paid'
  }
end

DataMapper.finalize
DataMapper.auto_migrate!

# Data downloaded from http://subsidyscope.com/bailout/tarp/
Import.import_from_file([Payment], "tarp_transactions.csv")

Payment.all.each do |p|
  puts p.inspect
end