Contents

class InventoryFile < ActiveRecord::Base
  attr_accessible :inventory, :note
  has_many :inventories, :dependent => :destroy
  has_many :items, :through => :inventories
  belongs_to :user
  has_attached_file :inventory, :path => ":rails_root/private:url"
  validates_attachment_content_type :inventory, :content_type => ['text/csv', 'text/plain', 'text/tab-separated-values']
  validates_attachment_presence :inventory
  validates_presence_of :user

  def self.per_page
    10
  end

  def import
    self.reload
    file = File.open(self.inventory.path)
    reader = file.read
    reader.split.each do |row|
      item = Item.where(:item_identifier => row.to_s.strip).first
      if item
        unless self.items.where(:id => item.id).select('items.id').first
          self.items << item
        end
      end
    end
    file.close
    true
  end
end

# == Schema Information
#
# Table name: inventory_files
#
#  id                     :integer         not null, primary key
#  filename               :string(255)
#  content_type           :string(255)
#  size                   :integer
#  user_id                :integer
#  note                   :text
#  created_at             :datetime        not null
#  updated_at             :datetime        not null
#  inventory_file_name    :string(255)
#  inventory_content_type :string(255)
#  inventory_file_size    :integer
#  inventory_updated_at   :datetime
#  inventory_fingerprint  :string(255)
#

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
enju_inventory-0.1.6	app/models/inventory_file.rb
enju_inventory-0.0.10	app/models/inventory_file.rb
enju_inventory-0.1.5	app/models/inventory_file.rb
enju_inventory-0.1.4	app/models/inventory_file.rb
enju_inventory-0.0.9	app/models/inventory_file.rb