has_many:不会从表单将数据库插入数据库 [英] has_many :throught not INSTERING INTO database from form

问题描述

我已经尝试了所有解决类似问题的解决方案，但还没有弄清楚这个问题.

I have tried all of the solutions to similar problems and haven't gotten this one figured out.

我在'Clinician'和'Patient'之间具有has_many:through关系，并具有联接模型'CareGroupAssignment'.我希望一个patient能够与多个clinicians关联，并且clinicians将具有多个patients.

I have a has_many :through relationship between 'Clinician', and 'Patient' with a joined model 'CareGroupAssignment'. I would like to have a patient be able to have multiple clinicians associated with it and clinicians will have multiple patients.

当我提交表单时，将记录以下内容: Started POST "/patients" for 127.0.0.1 at 2015-09-02 14:56:38 -0700 Processing by PatientsController#create as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"XXX=", "patient"=>{"user_attributes"=>{"email"=>"allencentre", "password"=>"[FILTERED]"}, "first_name"=>"Allen", "last_name"=>"Centre", "birth_date(1i)"=>"2002", "birth_date(2i)"=>"9", "birth_date(3i)"=>"2", "clinician_ids"=>["85", "87"], "patient_deceased"=>"0", "patient_archived"=>"0"}, "button"=>""}

When I submit my form this is logged: Started POST "/patients" for 127.0.0.1 at 2015-09-02 14:56:38 -0700 Processing by PatientsController#create as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"XXX=", "patient"=>{"user_attributes"=>{"email"=>"allencentre", "password"=>"[FILTERED]"}, "first_name"=>"Allen", "last_name"=>"Centre", "birth_date(1i)"=>"2002", "birth_date(2i)"=>"9", "birth_date(3i)"=>"2", "clinician_ids"=>["85", "87"], "patient_deceased"=>"0", "patient_archived"=>"0"}, "button"=>""}

因此"clinician_ids"=>["85", "87"]正在从表单传递.

有一个INSERT INTO "users" ("email", ....和INSERT INTO "patients" ("bir....，但是care_group_assignments的数据没有一个.

There is an INSERT INTO "users" ("email", .... and an INSERT INTO "patients" ("bir.... but the data for care_group_assignments doesn't have one.

有[36mCareGroupAssignment Load (0.4ms)[0m [1mSELECT "care_group_assignments".* FROM "care_group_assignments" WHERE "care_group_assignments"."patient_id" = $1[0m [["patient_id", 199]]

clinician.rb (简体)

class Clinician < ActiveRecord::Base
    belongs_to :care_group

    has_many :patients ,:through=> :care_group_assignments
    has_many :care_group_assignments, :dependent => :destroy

    belongs_to :user
    accepts_nested_attributes_for :user,  :allow_destroy => true
end

Patient.rb

class Patient < ActiveRecord::Base
    belongs_to :care_group

    has_many :clinicians ,:through=> :care_group_assignments
    has_many :care_group_assignments

    belongs_to :user
    accepts_nested_attributes_for :user,  :allow_destroy => true
end

care_group_assignments.rb

class CareGroupAssignment < ActiveRecord::Base
    belongs_to :clinician
    belongs_to :patient
end

这是从 Railscasts PRO#17- HABTM复选框起的示例开始收集数据并正确设置模型.下面是带有RailsCast中描述的每个临床医生复选框的表格，该复选框显示，并且数据已发送但未存储(无法查明原因).

This is following the example from Railscasts PRO #17- HABTM Checkboxes to at least start getting the data collected and to have the models set up correctly. Below is the form with the checkboxes for each clinician as described in the RailsCast, checkboxes show up and the data is sent but not stored (can't figure out why).

患者 new.html.erb 表格

<%= form_for @patient do |form| %>

  <%= form.fields_for :user do |builder| %>
   <div class="form-group">
      <%= builder.label "Email or Username" %>
      <%= builder.text_field :email, class: "form-control" %>
    </div>
    <div class="form-group">
      <%= builder.label :password %>
      <%= builder.password_field :password, class: "form-control" %>
    </div>
  <% end %>

  <div class="form-group">
    <%= form.label :first_name %>
    <%= form.text_field :first_name, class: "form-control", placeholder: "First name" %>
  </div>

  <div class="form-group">
    <%= form.label :last_name %>
    <%= form.text_field :last_name, class: "form-control", placeholder: "Last name" %>
  </div>

  <div class="form-group">
    <% Clinician.where(care_group_id: @care_group.id).each do |clinician| %>
      <%= check_box_tag "patient[clinician_ids][]", clinician.id, @patient.clinician_ids.include?(clinician.id), id: dom_id(clinician) %>
      <%= label_tag dom_id(clinician), clinician.full_name %><br>
    <% end %>
  </div>

  <%= form.button 'Create Patient', class: "btn btn-u btn-success" %>
<% end %>

到目前为止，该方法尚无法将clinician保存为patient关联.

This method has so far not been able to save the clinician to patient association.

patient_controller.rb

def new
  @patient = Patient.new
  @user = User.new
  @patient.build_user

  @care_group = current_clinician.care_group
end

def create
  @patient = Patient.create(patient_params)
  @patient.care_group = current_clinician.care_group

  if @patient.save
    redirect_to patient_path(@patient), notice: "New patient created!"
  else
    render "new"
  end
end

def show
 @patient = Patient.find_by(id: params["id"])
end

private
 def patient_params
  params.require(:patient).permit({:clinician_ids => [:id]},:first_name,:last_name,:user_id,:birth_date, user_attributes: [ :email, :password, :patient_id, :clinician_id ])
 end

我计划在患者show页面上显示与patient相关的clinicians:

I plan to display the clinicians associated with a patient on the patient show page:

患者 show.html.erb

<strong>Shared with:</strong>
 <% @patient.clinicians.each do |clinician| %>
  <%= clinician.full_name %><
 <% end %>

如果我为数据库添加种子，这将起作用，但是由于似乎没有存储数据，因此没有任何显示.

This works if I seed the database but since the data doesn't seem to be stored, nothing is showing up.

Rails 4.1.8，ruby 2.2.1p85，PostgreSQL

Rails 4.1.8, ruby 2.2.1p85, PostgreSQL

谢谢

推荐答案

我相信您的问题是控制器中的这一行:

I believe your problem is this line in your controller:

params.require(:patient).permit({:clinician_ids => [:id]}...

应该是:

params.require(:patient).permit({:clinician_ids => []}...

这篇关于has_many:不会从表单将数据库插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！