Sha256: 317dda78454405f4ef435ccf51ccfd4ea0c56fca7d92aafabc4482f97ba5f91c

Contents?: true

Size: 733 Bytes

Versions: 7

Compression:

Stored size: 733 Bytes

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