Contents

require 'stringio'
require 'test/unit'
require 'mocks/test/death_master_file_loader'
require File.dirname(__FILE__) + '/../lib/ssn_validator'

ActiveRecord::Base.establish_connection :adapter => 'sqlite3', :database => ':memory:'


def setup_high_group_codes_table
	ActiveRecord::Base.connection.tables.each { |table| ActiveRecord::Base.connection.drop_table(table) }
  create_ssn_high_group_codes_table
end

def setup_death_master_file_table
	ActiveRecord::Base.connection.tables.each { |table| ActiveRecord::Base.connection.drop_table(table) }
  create_death_master_file_table
end

private

def create_ssn_high_group_codes_table
  silence_stream(STDOUT) do
    ActiveRecord::Schema.define(:version => 1) do
      create_table :ssn_high_group_codes do |t|
        t.date      :as_of
        t.string    :area
        t.string    :group
        t.timestamps
      end

      add_index :ssn_high_group_codes, [:area]
      add_index :ssn_high_group_codes, [:area, :as_of]
    end
  end
end

def create_death_master_file_table
  silence_stream(STDOUT) do
    ActiveRecord::Schema.define(:version => 1) do
      create_table :death_master_files do |t|
        t.string :social_security_number
        t.string  :last_name
        t.string  :name_suffix
        t.string :first_name
        t.string :middle_name
        t.string :verify_proof_code
        t.date  :date_of_death
        t.date  :date_of_birth
        t.string  :state_of_residence
        t.string :last_known_zip_residence
        t.string :last_known_zip_payment
        t.timestamps
        t.date :as_of
      end
      add_index :death_master_files, :social_security_number, :unique => true
      add_index :death_master_files, :as_of
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
kevintyll-ssn_validator-1.0.0	test/test_helper.rb
kevintyll-ssn_validator-1.0.1	test/test_helper.rb