Updating the mysql record without id feild

rubyonrails-talk
1

Hi All,

        I need to update the records in the mysql with the data fields from the xml where the id field not presented in the database,

instead we took the number as primary key but not auto_incremented.

I treid with many attempts

for example my view as follows …

Editing employee

<% form_tag :action =>‘update’,:id => @employee.number do -%>

<%= label 'Employ_No','Employee Number' %> 
          <%= text_field 'employee','number',:value => @employee.number,:size => "16",:maxlength => "20",:id=>'number' %>
        
        </td>

  </tr>
  <tr>
        <td>
          <%=  label 'Employ_Name','Employee Name' %>
        </td>
        <td>
           <%= text_field 'employee','name',:value => @[employee.name](http://employee.name),:size => "16",:maxlength => "20",:id=>"employ_name" %>

        </td>
  </tr>
  <tr>
        <td>
          <%=  label 'Employ_Job','Employee Job' %>
        </td>
        <td>

        <%= text_field 'employee','job',:value => @employee.job,:size => "16",:maxlength => "20",:id=>"employ_job" %>
        </td>
  </tr>

  <tr>
        <td>
          <%=  label 'Employ_Salary','Employee Salary' %>
        </td>
        <td>
          <%= text_field 'employee','salary',:value => @employee.salary,:size => "16",:maxlength => "20",:id=>"employ_salary" %>

        </td>
  </tr>

<%= submit_tag “Save” %>

<% end %>

I tried with text_field_tag but i found this is the right way since we can access through the params[:employee] for all values and params[:employee][:name] for individual fields

and in my controller

def update begin puts “In update” no = params[:id] employ = Employee.new employ.number = params[:employee][:number]

       [employ.name](http://employ.name) = params[:employee][:name]
       employ.job = params[:employee][:job]
       employ.salary = params[:employee][:salary]
     #  puts "#{params[employ_no]}"

       puts "#{params[:employee][:employ_no]}"
       puts "#{params[:employee][:name]}"
       puts "#{params[:id]}"
      
     employee = Employee.find(:first,:conditions =>  ["number = ?",no])


      @emp = Employee.find(:first,:conditions => ["number = ?",no])
     
      puts "before update"
     
   #     if @emp.update(:no,params[:employee]) then

   #             puts "success"
   #             reder :text => "success"
   #     else
   #             puts "failed"
   #             render :text => "failed"

   #     end       
     
      if @emp.update_attributes(params[:employee]) then
        puts "success"
        reder :text => "success"
      else
        puts "failed"

        render :text => "failed"
      end
     
     # employee.update_attribute(:number,employ.number)
     
      puts "updated"

      #if @emp!= nil then
      #    @emp.number = params[:employ_no]
       #   @[emp.name](http://emp.name) = params[:employ_name]
       #   @emp.job = params[:employ_job]

       #   @emp.salary = params[:employ_sal]
     # end
       puts "#{params[:employee]}"
       puts @emp

    
     
     
rescue => e
  puts "error is #{e}"
end

end

Where my model has only 4 fields name,number,job,salary (here number is the primary key)

I tried with all the cases and vexed, It is througin error for each case

@emp.update(:number,params[:employee]) # ERROR : The private method ‘update’ called

@emp.update_attributes(params[:employee]) # Mysql::Error: #42S22Unknown column ‘id’ in ‘where clause’: UPDATE employees SET salary = ‘20000’, number = 6, job = ‘se’, name = ‘xxx’ WHERE id = NULL

@emp.update_attributes(employ) # ERROR is undefined method `stringify_keys!’ for #

How to achieve the updating? Please anybody help me…

2

Hi All,             I need to update the records in the mysql with the data
fields from the xml where the id field not presented in the database, instead we took the number as primary key but not auto_incremented.

I treid with many attempts for example my view as follows ..

Your code is pretty impenetrable by virtue of the duplication, bits
commented out etc... but if you don't have a primary key column you
should be using set_primary_key to tell rails which column is the
primary key

Fred

3

Thank You Fred for your reply.. I tried with the set_primary_key but still it is throwing the exception,Sorry sending the code like that i modified the code with removing the comments,the commented code is the my trails to achieve the desired.I have given the ways and the errors that are rendering for the particular call .. Please check and excuse the mistakes if any,

4

Thank You Fred I got it In model I kept the statement as   self.primary_key = :number

It worked.. Thank you