CODEWITHSUNDEEP
ruby-on-railsruby-on-rails-3activerecordrefinerycms
SteenhouwerD
SteenhouwerD

Reputation: 1807

Unknown primary key for table

I'm making an extension for refinerycms in rails and this is the structure I follow :

Project has many project_images Project_images belongs_to Project & Image ( The refinery Image class )

Now when I want to create a new object of ProjectImage in my Project class I always get this error :

Unknown primary key for table refinery_projects_images in model Refinery::Projects::ProjectImage.

I don't need a primary key for this table because it is a join table. Here is the code of my models and migration file:

Migration.rb

class CreateProjectsProjects < ActiveRecord::Migration

  def up
    create_table :refinery_projects do |t|
      t.string :title
      t.text :description
      t.string :investor
      t.string :location
      t.string :area
      t.string :purpose
      t.string :architect
      t.string :users
      t.integer :position
      t.integer :position

      t.timestamps
    end

    add_index :refinery_projects, :id

    create_table :refinery_projects_images, :id => false do |t|
      t.references :image
      t.references :project
      t.integer :position
      t.string :category
      t.string :caption
    end

    add_index :refinery_projects_images, [:image_id, :project_id], :uniq => true

  end

  def down
    if defined?(::Refinery::UserPlugin)
      ::Refinery::UserPlugin.destroy_all({:name => "refinerycms-projects"})
    end

    if defined?(::Refinery::Page)
      ::Refinery::Page.delete_all({:link_url => "/projects/projects"})
    end

    drop_table :refinery_projects
    drop_table :refinery_projects_images

  end

end

Project.rb

module Refinery
  module Projects
    class Project < Refinery::Core::BaseModel
      self.table_name = 'refinery_projects'

      attr_accessible :title, :description, :investor, :location, :area, :purpose, :architect, :users, :position, :position, :images_attributes

      acts_as_indexed :fields => [:title, :description, :investor, :location, :area, :purpose, :architect, :users]

      validates :title, :presence => true, :uniqueness => true

      has_many :project_images
      has_many :images, :through => :project_images, :order => 'position ASC'

      accepts_nested_attributes_for :images, :allow_destroy => false

      def images_attributes=(data)
        ProjectImage.delete_all(:project_id => self.id)

        (0..(data.length-1)).each do |i|
          unless (image_data = data[i.to_s]).nil? or image_data['id'].blank?
            project_image = self.project_images.new(:image_id => image_data['id'].to_i, :position => i)
            # Add caption if supported
            if false
              project_image.caption = image_data['caption']
            end
            self.project_images << project_image
          end
        end
      end

    end
  end
end

ProjectImage.rb

module Refinery
  module Projects
    class ProjectImage < Refinery::Core::BaseModel
      self.table_name = 'refinery_projects_images'

      attr_accessible :image_id, :position

      belongs_to :image, :class_name => 'Refinery::Image'
      belongs_to :project, :class_name => 'Refinery::Projects::Project'
    end
  end
end

Somebody knows why he keeps looking for the primary key?

Upvotes: 1

Views: 6059

Answers (1)

moritz
moritz

Reputation: 25757

Refinery::Core::BaseModel is somehow derived from ActiveRecord::Base. When you use that class then your table layout needs an id. If you don't want an id, Have a look at has_and_belongs_to_many in the rails guides: http://guides.rubyonrails.org/association_basics.html

Upvotes: 2

Related Questions