通过关联实现具有多的 Rails 3 嵌套形式

Question

我正在尝试通过关联实现具有多个的 Rails3 嵌套表单。

我的模型关系如下（我的模型是 Project ProjectDuration、ProjectFee）。通过project_fees，项目可以有多个项目持续时间。

以下是我的模型/表

mysql> desc projects;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| id            | int(11)      | NO   | PRI | NULL    | auto_increment |
| title         | varchar(255) | YES  |     | NULL    |                |
+---------------+--------------+------+-----+---------+----------------+

class Project < ActiveRecord::Base
  has_many :project_durations, :through => :project_fees
  has_many :project_fees
  accepts_nested_attributes_for :project_fees
end


mysql> desc project_durations;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int(11)      | NO   | PRI | NULL    | auto_increment |
| duration | varchar(255) | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+

class ProjectDuration < ActiveRecord::Base
  has_many :projects, :through => :project_fees
  has_many :project_fees
end


mysql> desc project_fees;
+---------------------+----------+------+-----+---------+----------------+
| Field               | Type     | Null | Key | Default | Extra          |
+---------------------+----------+------+-----+---------+----------------+
| id                  | int(11)  | NO   | PRI | NULL    | auto_increment |
| projec_id           | int(11)  | YES  |     | NULL    |                |
| project_duration_id | int(11)  | YES  |     | NULL    |                |
| fee                 | float    | YES  |     | NULL    |                |
+---------------------+----------+------+-----+---------+----------------+

class ProjectFee < ActiveRecord::Base
  belongs_to :projects
  belongs_to :project_durations
end

我的projects_controllers新操作如下

class ProjectsController < AdminsController
  def new
    @project = Project.new
    @project_durations = ProjectDuration.find(:all)
    project_fees = @project.project_fees.build()

    respond_to do |format|
      format.html # new.html.erb
      format.xml  { render :xml => @project }
    end
  end
end

我终于有了以下视图（new.erb），

<%= form_for(@project, :html => { :class => :form }) do |f| -%>
     <% @project_durations.each do |duration| %>
      <%= f.fields_for :project_fees do |builder|  %>
        <%= render 'fee_fields', :f => builder, :project => @project, :duration => duration %>
      <% end %>
  <% end %>
<% end -%>

并且'fee_fields'是这样

<ul>
  <li>
    <%= duration.duration %>
    <%= f.text_field :fee %>
    <%= f.hidden_field :project_duration_id, :value => duration.id %>
  </li>
</ul>

即使这将数据保存到'project_fees'表，它不会将数据保存在 project_fees 表的 project_id 字段中。

我在 Linux 上使用 Rails 3 和 Ruby 1.8.7。

Answer 1

假设你的 MySQL 输出被剪切和粘贴，你可能在迁移中的某个地方出现了拼写错误。 列应为

projec_id

project_fees 表中的

project_id

Answer 2

这对我来说是救星

http ://iqbalfarabi.net/2011/01/20/rails-nested-form-with-has-many-through-association/