Setting the primary key for a database not named ": id"

I am using: rails 2.3.5 ruby ​​1.8.7 and Windows 7 Home Basic

I was provided with a database and connected it to rails without having any problems reading and retrieving data. Now I want to add some functionality (add, edit and remove), but when I try to set my primary key to the primary key of the table (ProductCode) by executing this code:

class Product < ActiveRecord::Base
self.primary_key :ProductCode
end

      

I got this error while executing @products = Product.find(:all, :limit => 10)

:

ArgumentError in PosController # index wrong number of arguments (1 to 0)

How can I solve this?

Here's my controller code:

    class PosController < ApplicationController

    def index
        @cards = Card.find(:all)
        @products = Product.find(:all, :limit => 10)
    end

    def new
        @pro = Product.new
    end

    def edit
    @pro = Product.find(params[:id])
    end

    def update
    @pro = Product.find(params[:id])
    if session[:user_id]
                @log = "Welcome Administrator!"
                @logout="logout"
            else
                @log = "Admin Log in"
                @logout=""
            end

    respond_to do |format|
      if @pro.update_attributes(params[:product])
        flash[:notice] = 'product was successfully updated.'
        format.html { redirect_to(:controller => "pos", :action => "index") }
        format.xml  { head :ok }
      else
        format.html { render :action => "edit" }
        format.xml  { render :xml => @pro.errors, :status => :unprocessable_entity }
      end
    end
  end

    def create
    @pro = Product.new(params[:product])

    respond_to do |format|
      if @pro.save
        flash[:notice] = 'product was successfully created.'
        format.html {redirect_to (:controller => "pos", :action => "index")}
        #format.xml  { render :xml => @product, :status => :created, :location => @product }
      else
        format.html { render :controller => "pos",:action => "new" }
        #format.xml  { render :xml => @product.errors, :status => :unprocessable_entity }
      end
    end
  end

  def destroy
    @pro = Product.find(params[:id])
    @pro.destroy

    respond_to do |format|
    flash[:notice] = 'product was successfully deleted.'
      format.html { redirect_to(:controller => "pos", :action => "index") }
      format.xml  { head :ok }
    end
  end
end

      

+3


source to share


2 answers


Sets the name of the primary key column.



self.primary_key = "product_code"

+7


source


self.primary_key

returns what rails currently considers to be the primary key and therefore takes no arguments. If you want to set the primary key use self.primary_key = 'blah'

.



Earlier versions of rails also supported set_primary_key 'blah'

, but this was deprecated in rails 3.2.

+3


source







All Articles