Contents

require 'earth/model'

require 'earth/industry/naics_2002'
require 'earth/industry/naics_2002_sic_1987_concordance'

class Sic1987 < ActiveRecord::Base
  extend Earth::Model

  TABLE_STRUCTURE = <<-EOS

CREATE TABLE sic_1987
  (
     code        CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
     description CHARACTER VARYING(255)
  );

EOS

  self.primary_key = "code"
  self.table_name = "sic_1987"
  
  has_many :naics_2002_sic_1987_concordances, :foreign_key => :sic_1987_code
  has_many :naics_2002, :through => :naics_2002_sic_1987_concordances
  
  # for data import
  def self.format_description(description)
    (desc = description.match /^(.+?) \(/) ? desc.captures.first : description
  end
  
  warn_unless_size 1004
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
earth-1.2.1	lib/earth/industry/sic_1987.rb
earth-1.1.2	lib/earth/industry/sic_1987.rb
earth-1.1.1	lib/earth/industry/sic_1987.rb
earth-1.1.0	lib/earth/industry/sic_1987.rb
earth-1.0.3	lib/earth/industry/sic_1987.rb
earth-1.0.2	lib/earth/industry/sic_1987.rb
earth-1.0.1	lib/earth/industry/sic_1987.rb