#!/usr/bin/env ruby
%w[rubygems sqlite3].each{|lib| require lib}

class LoadData
  def initialize
    @file,@db,@table,@delim = ARGV
    self.check_args
    self.load
  end 

  def check_args
    if ARGV.length != 4
      puts "Usage: #{$0} file.csv sqlite3.db table delimiter"
      exit
    end 
  end 

  def load
    puts "Loading #{@file} into #{@db}.#{@table}"
    `sqlite3 -separator #{@delim} #{@db} ".import #{@file} #{@table}"`
  end 
end

LoadData.new