thr3ads.net - Rails - Inserting rows into linking table [Sep 2006]

If this information is useful, please help other people find it:
Share via:

David Lelong

2006-Sep-28 20:44 UTC

Inserting rows into linking table

Hi,

I have two objects:

Contacts
Lists

I want to be able to add multiple contacts to multiple lists.

I''ve created a linking table and a form that allows me to select the 
contacts using checkboxes, but I''m having some problems with the 
controller and model.

I receive the following error message when I submit the form:

Mysql::Error: Cannot add or update a child row: a foreign key constraint 
fails: INSERT INTO contact_lists (`contact_id`, `list_id`) VALUES(1, 2)

However, the form variables returned from the form are:

Parameters: {"commit"=>"Add Contacts to List", 
"contact_list"=>{"contact_id"=>["4",
"5"], "list_id"=>"2"}}

I''m not sure if the issue is with the way my controller is setup or the
model.

The controller action is:

  def link_contacts
    @contact_list = Contact_List.new(params[:contact_list])
    if @contact_list.save
      flash[:notice] = ''Contacts were successfully added to the
list.''
      redirect_to :action => ''list''
    else
      flash[:notice] = ''Error with adding contacts to the
list.''
    end
  end

Any advice?

Thanks,

David

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

Maxim Kulkin

2006-Sep-29 04:54 UTC

head link

Re: Inserting rows into linking table

David Lelong пишет:> Hi,
>
> I have two objects:
>
> Contacts
> Lists
>
> I want to be able to add multiple contacts to multiple lists.
>
> I''ve created a linking table and a form that allows me to select
the
> contacts using checkboxes, but I''m having some problems with the 
> controller and model.
>
> I receive the following error message when I submit the form:
>
> Mysql::Error: Cannot add or update a child row: a foreign key constraint 
> fails: INSERT INTO contact_lists (`contact_id`, `list_id`) VALUES(1, 2)
>
> However, the form variables returned from the form are:
>
> Parameters: {"commit"=>"Add Contacts to List", 
> "contact_list"=>{"contact_id"=>["4",
"5"], "list_id"=>"2"}}
>
> I''m not sure if the issue is with the way my controller is setup
or the
> model.
>
> The controller action is:
>
>   def link_contacts
>     @contact_list = Contact_List.new(params[:contact_list])
>     if @contact_list.save
>       flash[:notice] = ''Contacts were successfully added to the
list.''
>       redirect_to :action => ''list''
>     else
>       flash[:notice] = ''Error with adding contacts to the
list.''
>     end
>   end
>
> Any advice?
>   You are trying to pass an array as an attribute value ("contact_id"). 
This won''t work. You have to iterate through all items in 
params[:contact_list][:contact_id]:
@contacts = params[:contact_list][:contact_id].collect { |contact_id| 
Contact_List.new(:list_id => params[:list_id], :contact_id => contact_id)
}

But I''m in doubt you have business model designed right.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

David Lelong

2006-Sep-29 12:22 UTC

head link

Re: Inserting rows into linking table

Is this line correct?

params[:contact_list][:contact_id]:

I''m getting a kEnd error.

David


-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

Maxim Kulkin

2006-Sep-29 12:29 UTC

head link

Re: Inserting rows into linking table

@contacts = params[:contact_list][:contact_id].collect { |contact_id|
 Contact_List.new(:list_id => params[:list_id], :contact_id =>
contact_id) }


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

David Lelong

2006-Sep-29 14:22 UTC

head link

Re: Inserting rows into linking table

The contact_ids are being inserted, but the list_id is inserted as null. 
My models are as follows:

class Contact < ActiveRecord::Base
  has_many :contact_lists, :dependent => true
  has_many :lists, :through => :contact_lists
end

class List < ActiveRecord::Base
  has_many :contact_lists, :dependent => true
  has_many :contacts, :through => :contact_lists
end

class Contact_List < ActiveRecord::Base
  belongs_to :lists
  belongs_to :contacts
end

Is there an issue with my models or with getting the values from the 
form?

Thanks,

David


-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

Maxim Kulkin

2006-Sep-29 15:07 UTC

head link

Re: Inserting rows into linking table

On 29 September 2006 18:22, David Lelong wrote:> The contact_ids are being inserted, but the list_id is inserted as null.
> My models are as follows:
>
> class Contact < ActiveRecord::Base
>   has_many :contact_lists, :dependent => true
>   has_many :lists, :through => :contact_lists
> end
>
> class List < ActiveRecord::Base
>   has_many :contact_lists, :dependent => true
>   has_many :contacts, :through => :contact_lists
> end
>
> class Contact_List < ActiveRecord::Base
>   belongs_to :lists
>   belongs_to :contacts
> end
>
> Is there an issue with my models or with getting the values from the
> form?
Ahh.. don''t ever copy/paste the code. Read it, get the idea and then
type it
YOURSELF. Here is the corrected one:

@contacts = params[:contact_list][:contact_id].collect { |contact_id|
 Contact_List.new(:list_id => params[:contact_list][:list_id], :contact_id
=>
contact_id) }

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

Maxim Kulkin

2006-Sep-29 15:09 UTC

head link

Re: Inserting rows into linking table

On 29 September 2006 18:22, David Lelong wrote:> class Contact < ActiveRecord::Base
>   has_many :contact_lists, :dependent => true
>   has_many :lists, :through => :contact_lists
> end
>
> class List < ActiveRecord::Base
>   has_many :contact_lists, :dependent => true
>   has_many :contacts, :through => :contact_lists
> end
>
> class Contact_List < ActiveRecord::Base
>   belongs_to :lists
>   belongs_to :contacts
> endBy the way, you should create an abstraction for link between Contact and List 
and name the corresponding class according to that abstraction. Contact_List 
looks not very nice for me.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

David Lelong

2006-Sep-29 15:32 UTC

head link

Re: Inserting rows into linking table

Thanks for the help.  I''ve got it sorted out now.


-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

David Lelong

2006-Sep-29 17:53 UTC

head link

Re: Inserting rows into linking table

One other thing.  I added:

validates_presence_of :contact_id, :list_id

to my Contact_List model, but I''m still receiving an error message when
I don''t select a contact_id:

You have a nil object when you didn''t expect it!
You might have expected an instance of Array.
The error occured while evaluating nil.collect

Any advice?

David


-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

Maxim Kulkin

2006-Sep-30 12:15 UTC

head link

Re: Inserting rows into linking table

David Lelong wrote:> I''m still receiving an error message when I don''t select
a contact_id:
>
> You have a nil object when you didn''t expect it!
> You might have expected an instance of Array.
> The error occured while evaluating nil.collect
>
> Any advice?This is because you use checkboxes in the HTML and they do not produce
any post parameter if they aren''t selected. My suggestion is to add
"rescue" clause for that case:

@contact_lists = .......... rescue []

The middle part is unchanged, only add "rescue []" to catch any errors
and return empty array then. Alternatively, you can wrap all construct
in an IF block:

if params[:contact_list] && params[:contact_list][:contact_id]
  @contact_lists = ....................
end


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

David Lelong

2006-Oct-02 20:46 UTC

head link

Re: Inserting rows into linking table

I noticed now that sometimes a new record does not get created in the 
contact_lists table.  It''s inconsistent, but I''m not sure why
it''s
happening.

I''m using this code to create the new records:

@contacts = params[:contact_list][:contact_id].collect { |contact_id|
    	Contact_List.create(:list_id => params[:contact_list][:list_id], 
:contact_id => contact_id) }

Sometimes it creates new records and sometimes it doesn''t.  It never 
produces errors though when records are not created.

Any advice?

Thanks,

David

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

David Lelong

2006-Oct-02 20:50 UTC

head link

Re: Inserting rows into linking table

Ugh, it had to do with:

validates_uniqueness_of :contact_id, :list_id

in my controller

Any advice on how I can get validate for uniqueness on the combination 
of contact_id and list_id, not each one individually?

Thanks,

David


-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

Jean-François

2006-Oct-02 21:46 UTC

head link

Re: Inserting rows into linking table

Hello David,
> Ugh, it had to do with:
>
> validates_uniqueness_of :contact_id, :list_id
>
> in my controller
>
> Any advice on how I can get validate for uniqueness on the combination
> of contact_id and list_id, not each one individually?
You were not so far :)
Use :scope.

validates_uniqueness_of :contact_id, :scope => :list_id

Regards,

     -- Jean-François.

-- 
À la renverse.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

David Lelong

2006-Oct-02 22:36 UTC

head link

Re: Inserting rows into linking table

This is perfect!

It works now, and the duplicate record ID combinations won''t be added
to
the contact_list table.  However, I can''t get the error message to 
appear on the form

I have:

<%= error_messages_for ''contact_list'' %>


enclosed within the form, but it''s only displaying flash[:notice] 
messages from the controller.

How do I get to display error messages from the model?

Thanks,

David

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

Joseph

2006-Oct-25 17:09 UTC

head link

Inserting Multiple records

how can i insert a multiple records of the database within one function 
of ruby

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

Joseph

2006-Oct-25 17:12 UTC

head link

Re: Inserting Multiple records

Joseph wrote:> how can i insert a multiple records of the database within one function 
> of ruby. This is the records that i want to be saved in the database

Item.create(:name=>''COMPETITION MAG POUCH (MC Cormick/Para Ord)  P14
RH
Black'',:model=>''COMPETITION MAG POUCH (MC Cormick/Para Ord)
P14  RH
Black'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''773-850-181-150'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION MAG POUCH
(Beretta/Browning/Ruger/Sig
Sauer 9mm) RH'',:model=>''COMPETITION MAG POUCH
(Beretta/Browning/Ruger/Sig Sauer 9mm)
RH'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''077-76-121-150'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION MAG POUCH (MC Cormick/Para Ord)  P14
RH
Red'',:model=>''COMPETITION MAG POUCH (MC Cormick/Para Ord) 
P14  RH
Red'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''771-850-351-150'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION MAG POUCH (Glock
17,19,22,23,26,27,34,35) LH'',:model=>''COMPETITION MAG POUCH
(Glock
17,19,22,23,26,27,34,35)
LH'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''077-83-122-150'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION MAG POUCH
(Beretta/Browning/Ruger/Sig
Sauer 9mm) LH'',:model=>''COMPETITION MAG POUCH
(Beretta/Browning/Ruger/Sig Sauer 9mm)
LH'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''077-76-182-150'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION MAG POUCH (MC Cormick/Para Ord)  P14
RH
Basketweave'',:model=>''COMPETITION MAG POUCH (MC
Cormick/Para Ord)  P14
RH
Basketweave'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''773-850-121-150'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION MAG POUCH (Govt. 1911/ Ofcr
45ACP/Sig
Sauer 220)'',:model=>''COMPETITION MAG POUCH (Govt. 1911/
Ofcr 45ACP/Sig
Sauer
220)'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''771-53-121-150'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION MAG POUCH (MC Cormick/Para Ord)  P14
LH'',:model=>''COMPETITION MAG POUCH (MC Cormick/Para Ord) 
P14
LH'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''771-850-122-150'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION MAG POUCH
(Beretta/Browning/Ruger/Sig
Sauer 9mm) RH'',:model=>''COMPETITION MAG POUCH
(Beretta/Browning/Ruger/Sig Sauer 9mm)
RH'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''771-76-121-150'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION MAG POUCH
(Beretta/Browning/Ruger/Sig
Sauer 9mm) RH'',:model=>''COMPETITION MAG POUCH
(Beretta/Browning/Ruger/Sig Sauer 9mm)
RH'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''773-76-121-150'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION MAG POUCH (Glock 20,21,29,30,36) LH
black'',:model=>''COMPETITION MAG POUCH (Glock
20,21,29,30,36) LH
black'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''077-383-122-150'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION MAG POUCH (Govt. 1911/ Sig Suer
P220) LH
black'',:model=>''COMPETITION MAG POUCH (Govt. 1911/ Sig Suer
P220) LH
black'',:unit_price=>0,:retail_price=>1800,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''771-1
1/2
Kydex'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''MAG HOLDER METAL CLIP-ON (Glock 20,21,Koch USP
45)'',:model=>''MAG HOLDER METAL CLIP-ON (Glock 20,21,Koch
USP
45)'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''CD-383'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''LOADER CASE COMPETITION (S&W L Frame/ Colt
Python)'',:model=>''LOADER CASE COMPETITION (S&W L Frame/
Colt
Python)'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>''333'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMP. III SPEEDLOADER (S&W L Frame
581,586,681,686)'',:model=>''COMP. III SPEEDLOADER (S&W L
Frame
581,586,681,686)'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>''J-GL85'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''COMPETITION HOLSTER (S&W K,L MED., N LARGE
FRAME,
Taurus 66,669,689)'',:model=>''COMPETITION HOLSTER (S&W
K,L MED., N LARGE
FRAME, Taurus
66,669,689)'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>''002-09-121'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''SPEEDLOADER HOLDER (S&W L FRAME, Colt
Python)'',:model=>''SPEEDLOADER HOLDER (S&W L FRAME, Colt
Python)'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>''333-3-2-175'',:brand_id=>''SAFARILAND'')
Item.create(:name=>''TRIPLE SPEEDLOADER POUCH K&L
FRAME'',:model=>''TRIPLE
SPEEDLOADER POUCH K&L
FRAME'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''SAFARILAND'')
Item.create(:name=>''MAGAZINE LOADER
ML-3'',:model=>''MAGAZINE LOADER
ML-3'',:unit_price=>0,:retail_price=>550,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''SAFARILAND'')
Item.create(:name=>''MAGAZINE LOADER
ML-1'',:model=>''MAGAZINE LOADER
ML-1'',:unit_price=>0,:retail_price=>550,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''SAFARILAND'')
Item.create(:name=>''MAGAZINE LOADER
ML-2'',:model=>''MAGAZINE LOADER
ML-2'',:unit_price=>0,:retail_price=>550,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''SAFARILAND'')
Item.create(:name=>''UNIVERSAL COMP
HOLSTER'',:model=>''UNIVERSAL COMP
HOLSTER'',:unit_price=>0,:retail_price=>3250,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''JETHRO'')
Item.create(:name=>''COMPETITION HOLSTER FOR
GLOCK'',:model=>''COMPETITION
HOLSTER FOR
GLOCK'',:unit_price=>0,:retail_price=>3250,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''JETHRO'')
Item.create(:name=>''UNIVERSAL MAG
POUCH'',:model=>''UNIVERSAL MAG
POUCH'',:unit_price=>0,:retail_price=>750,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''JETHRO'')
Item.create(:name=>''COMPETITION HOLSTER FOR
PARA'',:model=>''COMPETITION
HOLSTER FOR
PARA'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''JR
HOSTER'')
Item.create(:name=>''EARMUFF
HOLDER'',:model=>''EARMUFF
HOLDER'',:unit_price=>0,:retail_price=>250,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''SHOOTING
ACCESSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''SAFARILAND'')
Item.create(:name=>''UNIVERSAL COMP MAG
POUCH'',:model=>''UNIVERSAL COMP
MAG
POUCH'',:unit_price=>0,:retail_price=>2200,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''CR
SPEED'')
Item.create(:name=>''PADDLE HOLSTER BERETTA 92F
RH'',:model=>''PADDLE
HOLSTER BERETTA 92F
RH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''BR-2'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER BERETTA
92F'',:model=>''BELT HOLSTER
BERETTA
92F'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''BR-2
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER BERETTA 92F
LH'',:model=>''PADDLE
HOLSTER BERETTA 92F
LH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''BR-2
LH'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER 1911
STYLE'',:model=>''PADDLE HOLSTER
1911
STYLE'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''C-21'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER 1911 STYLE + ROTATING DEVICE
RH'',:model=>''PADDLE HOLSTER 1911 STYLE + ROTATING DEVICE
RH'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''C-21
RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER 1911 STYLE + ROTATING DEVICE
LH'',:model=>''PADDLE HOLSTER 1911 STYLE + ROTATING DEVICE
LH'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''C-21
LH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER 1911 STYLE
RH'',:model=>''BELT HOLSTER
1911 STYLE
RH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''C-21
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER 1911 STYLE
LH'',:model=>''BELT HOLSTER
1911 STYLE
LH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''C-21
LH BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER CZ-75
RH'',:model=>''BELT HOLSTER CZ-75
RH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''CZ-75
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER GLOCK 17/19
RH'',:model=>''BELT HOLSTER
GLOCK 17/19
RH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-2
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER GLOCK 17/19 RH + ROTATING
DEVICE'',:model=>''BELT HOLSTER GLOCK 17/19 RH + ROTATING
DEVICE'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-2
BH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER GLOCK 17/19
LH'',:model=>''PADDLE
HOLSTER GLOCK 17/19
LH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-2
LH'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER GLOCK 17/19 LH + ROTATING
DEVICE'',:model=>''PADDLE HOLSTER GLOCK 17/19 LH + ROTATING
DEVICE'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-2
LH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER GLOCK 26
RH'',:model=>''PADDLE HOLSTER
GLOCK 26
RH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-26'',:brand_id=>''FOBUS'')
Item.create(:name=>''ANKLE HOLSTER GLOCK 26
RH'',:model=>''ANKLE HOLSTER
GLOCK 26
RH'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-26
A'',:brand_id=>''FOBUS'')
Item.create(:name=>''ANKLE HOLSTER GLOCK 26
LH'',:model=>''ANKLE HOLSTER
GLOCK 26
LH'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-26
LH A'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER GLOCK 26 LH + ROTATING
DEVICE'',:model=>''BELT HOLSTER GLOCK 26 LH + ROTATING
DEVICE'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-26
LH BH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER GLOCK 20/21
RH'',:model=>''PADDLE
HOLSTER GLOCK 20/21
RH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''6L-3'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER GLOCK 20/21
RH'',:model=>''BELT HOLSTER
GLOCK 20/21
RH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-3
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER GLOCK 20/21 LH + ROTATING
DEVICE'',:model=>''BELT HOLSTER GLOCK 20/21 LH + ROTATING
DEVICE'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-3
LH BH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER GLOCK 20/21 RH + ROTATING
DEVICE'',:model=>''BELT HOLSTER GLOCK 20/21 RH + ROTATING
DEVICE'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-3
BH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER GLOCK 20/21 LH + ROTATING
DEVICE'',:model=>''PADDLE HOLSTER GLOCK 20/21 LH + ROTATING
DEVICE'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-3
LH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER GLOCK
36'',:model=>''PADDLE HOLSTER
GLOCK
36'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-36'',:brand_id=>''FOBUS'')
Item.create(:name=>''ANKLE HOLSTER GLOCK 36
'',:model=>''ANKLE HOLSTER
GLOCK 36
'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-36
A'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER GLOCK
36'',:model=>''BELT HOLSTER GLOCK
36'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-36
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER GLOCK 36 LH + ROTATING
DEVICE'',:model=>''PADDLE HOLSTER GLOCK 36 LH + ROTATING
DEVICE'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-36
LH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER GLOCK
29/30'',:model=>''PADDLE HOLSTER
GLOCK
29/30'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-4'',:brand_id=>''FOBUS'')
Item.create(:name=>''ANKLE HOLSTER GLOCK
29/30'',:model=>''ANKLE HOLSTER
GLOCK
29/30'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-4
A'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER GLOCK
29/30'',:model=>''BELT HOLSTER
GLOCK
29/30'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-4
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER GLOCK 29/30
LH'',:model=>''PADDLE
HOLSTER GLOCK 29/30
LH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-4
LH'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER GLOCK 29/30
ROTO'',:model=>''PADDLE
HOLSTER GLOCK 29/30
ROTO'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GL-4
RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''MINI HOLSTER GLOCK
17/19'',:model=>''MINI HOLSTER
GLOCK
17/19'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GLB
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''MINI HOLSTER GLOCK 17/19
ROTO'',:model=>''MINI HOLSTER
GLOCK 17/19
ROTO'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GLB
BH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''TELESCOPING STOCK FOR
GLOCK'',:model=>''TELESCOPING
STOCK FOR
GLOCK'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''GLR440'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER JRICHO
ROTO'',:model=>''BELT HOLSTER
JRICHO
ROTO'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''JR-1
BH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER S&W J FRAME MODEL
60'',:model=>''BELT
HOLSTER S&W J FRAME MODEL
60'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>''JSW-3
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''ANKLE HOLSTER S&W J
FRAME'',:model=>''ANKLE HOLSTER
S&W J
FRAME'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''JSW-3
A'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER S&W J
FRAME'',:model=>''PADDLE HOLSTER
S&W J
FRAME'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''JSW-3
'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER L & K FRAME 4"
REVOLVER'',:model=>''PADDLE HOLSTER L & K FRAME 4"
REVOLVER'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''LK-4'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER L & K FRAME
ROTO'',:model=>''BELT HOLSTER
L & K FRAME
ROTO'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''LK-4
BH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER WALTHER
PPK'',:model=>''PADDLE HOLSTER
WALTHER
PPK'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''PPK-1'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER RUGER
P85'',:model=>''PADDLE HOLSTER
RUGER
P85'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''RU-1'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER
SIG226'',:model=>''PADDLE HOLSTER
SIG226'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''SG-2'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER SIG226
LH'',:model=>''PADDLE HOLSTER
SIG226
LH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''SG-2
LH'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER SIG226 LH
ROTO'',:model=>''PADDLE
HOLSTER SIG226 LH
ROTO'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''SG-2
LH RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER SIG226
ROTO'',:model=>''PADDLE HOLSTER
SIG226
ROTO'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''SG-2
RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER
SIG229'',:model=>''PADDLE HOLSTER
SIG229'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''SG-229'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER
SIG230'',:model=>''PADDLE HOLSTER
SIG230'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''SG-3'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER SIG230
ROTO'',:model=>''PADDLE HOLSTER
SIG230
ROTO'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''SG-3
RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER
MAKAROV'',:model=>''BELT HOLSTER
MAKAROV'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''MAK-1
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER
HS2000'',:model=>''BELT HOLSTER
HS2000'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''SP-1
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER HS2000
ROTO'',:model=>''PADDLE HOLSTER
HS2000
ROTO'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''SP-1
RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER S&W 357 J
FRAME'',:model=>''PADDLE
HOLSTER S&W 357 J
FRAME'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>''SW-357'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER S&W 357 J
FRAME'',:model=>''PADDLE
HOLSTER S&W 357 J
FRAME'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>''SW-357
A'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER S&W 357 J
FRAME'',:model=>''PADDLE
HOLSTER S&W 357 J
FRAME'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>''SW-357
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER S&W 357 J FRAME
ROTO'',:model=>''PADDLE
HOLSTER S&W 357 J FRAME
ROTO'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>''SW-357
RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER TAURUS
MILLENIUM'',:model=>''PADDLE
HOLSTER TAURUS
MILLENIUM'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''TAM'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER TAURUS MILLENIUM
ROTO'',:model=>''PADDLE HOLSTER TAURUS MILLENIUM
ROTO'',:unit_price=>0,:retail_price=>2000,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''TAM
RT'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER WALTHER P99
'',:model=>''PADDLE HOLSTER
WALTHER P99
'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''WP-99'',:brand_id=>''FOBUS'')
Item.create(:name=>''BELT HOLSTER WALTHER P99
BH'',:model=>''BELT HOLSTER
WALTHER P99
BH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''WP-99
BH'',:brand_id=>''FOBUS'')
Item.create(:name=>''PADDLE HOLSTER WALTHER P99 
LH'',:model=>''PADDLE
HOLSTER WALTHER P99
LH'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''WP-99
LH'',:brand_id=>''FOBUS'')
Item.create(:name=>''KYDEX HIP HOLSTER Fits: HK USP Compact (All
Calibers)'',:model=>''KYDEX HIP HOLSTER Fits: HK USP Compact
(All
Calibers)'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''5331-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''KYDEX HIP HOLSTER Fits:
1911'',:model=>''KYDEX HIP
HOLSTER Fits:
1911'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''5319-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''KYDEX PADDLE HOLSTER Fits: HK USP Compact (All
Calibers)'',:model=>''KYDEX PADDLE HOLSTER Fits: HK USP
Compact (All
Calibers)'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''5431-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''KYDEX PADDLE HOLSTER Fits: Glock
17,19,22,23,25,31,32'',:model=>''KYDEX PADDLE HOLSTER Fits:
Glock
17,19,22,23,25,31,32'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''5421-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''KYDEX HIP HOLSTER Fits:S&W J Frame
.22,.32,9mm,.38,357'',:model=>''KYDEX HIP HOLSTER
Fits:S&W J Frame
.22,.32,9mm,.38,357'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>''5336-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''KYDEX PADDLE HOLSTER Fits: Glock 20,
21'',:model=>''KYDEX PADDLE HOLSTER Fits: Glock 20,
21'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''5425-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''KYDEX SINGLE MAG CASE Polymer
10mm-45caliber'',:model=>''KYDEX SINGLE MAG CASE Polymer
10mm-45caliber'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''5036-2'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''KYDEX PADDLE HOLSTER Fits: Sig Sauer P220,
P226'',:model=>''KYDEX PADDLE HOLSTER Fits: Sig Sauer P220,
P226'',:unit_price=>0,:retail_price=>1700,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''5422-2'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''INSIDE HOLSTER SIZE
1'',:model=>''INSIDE HOLSTER SIZE
1'',:unit_price=>0,:retail_price=>750,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''8901-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''INSIDE HOLSTER SIZE
36'',:model=>''INSIDE HOLSTER SIZE
36'',:unit_price=>0,:retail_price=>750,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''8936-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''INSIDE HOLSTER SIZE
16'',:model=>''INSIDE HOLSTER SIZE
16'',:unit_price=>0,:retail_price=>750,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''8916-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''INSIDE HOLSTER SIZE
15'',:model=>''INSIDE HOLSTER SIZE
15'',:unit_price=>0,:retail_price=>750,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''8915-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''INSIDE HOLSTER SIZE
2'',:model=>''INSIDE HOLSTER SIZE
2'',:unit_price=>0,:retail_price=>750,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''8902-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''INSIDE HOLSTER SIZE
0'',:model=>''INSIDE HOLSTER SIZE
0'',:unit_price=>0,:retail_price=>750,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''8900-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''AMBIDEXTROUS HOLSTER SIZE
36'',:model=>''AMBIDEXTROUS
HOLSTER SIZE
36'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''7036-0'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''ANKLE HOLSTER SIZE 16 Fits: 3 1/4 - 3
3/4'',:model=>''ANKLE HOLSTER SIZE 16 Fits: 3 1/4 - 3
3/4'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''8816-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''ANKLE HOLSTER SIZE 16 Fits: 3 1/4 - 3
3/5'',:model=>''ANKLE HOLSTER SIZE 16 Fits: 3 1/4 - 3
3/5'',:unit_price=>0,:retail_price=>0,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''PISTOL
ACCSSORIES'',:barcode=>'''',:code=>''8812-1'',:brand_id=>''UNCLE
MIKE'')
Item.create(:name=>''PLASTIC SPEEDLOADER
10-A'',:model=>''PLASTIC
SPEEDLOADER
10-A'',:unit_price=>0,:retail_price=>550,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''HKS'')
Item.create(:name=>''PLASTIC SPEEDLOADER
36-A'',:model=>''PLASTIC
SPEEDLOADER
36-A'',:unit_price=>0,:retail_price=>550,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''HKS'')
Item.create(:name=>''PLASTIC SPEEDLOADER
586-A'',:model=>''PLASTIC
SPEEDLOADER
586-A'',:unit_price=>0,:retail_price=>550,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''HKS'')
Item.create(:name=>''PLASTIC SPEEDLOADER
DS-A'',:model=>''PLASTIC
SPEEDLOADER
DS-A'',:unit_price=>0,:retail_price=>550,:stock_alarm=>0,:measurement_id=>'''',:category_id=>''REVOLVER
ACCSSORIES'',:barcode=>'''',:code=>'''',:brand_id=>''HKS'')





-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

Possibly Parallel Threads

Search for more reasonably related threads

Rails - Sep 2006 - Inserting rows into linking table

Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Re: Inserting rows into linking table

Inserting Multiple records

Re: Inserting Multiple records

Possibly Parallel Threads