Creating Two Models in One Form (Page 5 of 6)

hi

I am facing the following issue:

I have two models named: Project and AgreementFile
Every Project can have only one agreement file
So they share following relationships

class Project < ActiveRecord::Base
  belongs_to :agreementfile
end

class Agreementfile < ActiveRecord::Base
  has_one :project

  def sow_file=(input_data)
    self.name = input_data.original_filename
    self.content_type = input_data.content_type.chomp
    self.content = input_data.read
  end

end

I want to create agreementfile in the same view as project new
New is working for me but edit do not

In edit.html.erb file of project view I did following

<h1>Editing project</h1>

<%= error_messages_for :project, :agreementfile %>

<% form_for(:project, @project, :url => {:action => 'update'}, :html => { :multipart => true }) do |f| %>

    <p>
    <b>Name</b><br />
    <%= f.text_field :name %>
  </p>
   
  <p>
    <b>Budget</b><br />
    <%= f.text_field  :budget %>
  </p>

  <p>
    <b>Billable count</b><br />
    <%= f.text_field :billable_count %>
  </p>
   

<% fields_for(:agreementfile, @project.agreementfile) do |i| %>
    <p>
      <b>Upload file</b>
      <%= i.file_field :sow_file %>
     </p>
   <% end %>

  <p>
    <%= submit_tag "Update" %>
  </p>

<% end %>

<%= link_to 'Show', @project %> |
<%= link_to 'Back', projects_path %>

But still I found the view do not show me upload image file name in file_field of corresponding to "Upload file"

Requirement: During the edit of particular project all the fields corresponding to that project should be pre-filled. User can change the value of any field and click "Update" . The new values should then replace the old values.
So the first step itself populating the old values of project in edit form is not working. Please help me how to go about.

Online

Hmm, I can get the form to work for three leves down.
But then the problem is how do I keep the third level objects from being applied across the board?  1 Project 5 Tasks each task has 5 asignees.  I can't loop through each of the params for asignee it has to do it in blocks of five.  Is there an elegat way to do this or just brute if then logic?

thanks for helping

You may want to try out the attribute_fu plugin. That is what I ended up using, it is really simple and can even be extended to three (or I assume even more) levels of model nesting. Cheers

Anyone tried Rails 2.3.2 ability to do that?

Hi Javix ,
Thank you for the response.
As i am new to rails i dont have much idea on associations .
But i want to provide the association between models in my application while uploading the sterams.
ex:
I want to upload a stream called '1.ts' the stream has more programs and each program will have one or more video and audio streams and each audio and video details are stored in streams table.

this the data of stream to be uploaded in to database.

For this i have below tables :
containerformats:to store the name of stream and location
----------------

trasportstreams:has below fields
----------------
"num_programs"
"encryption_std"
"containerformat_id"

programs table: has below fields
----------------
"pid"
"closedcaption"
"privatedata_pid"
"transport_stream_id"
"numAudio"
"numVideo"

streams table:has below fields
-----------
"videoCodec_id"
"resolution"
"audioSamplingRate"

And i am using ryans complexforms post to upload data into models.

--Can you suggest me to provide the association between the models.
i could not able to proceede from this step.
Any help is greatly appreciated.

thanks
Srikanth

Hi Javix,
thank you for the suggestions.

Now i have removed the use has_many:through association.
And i could able to upload stream into database.

But the problem here is:
while uploading data into other tables
1)i am not getting the transportstream_id from transportstreams in to the programs table.
2)throughing the error like:
ActiveRecord::StatementInvalid in Containerformats#show
Showing app/views/containerformats/show.html.erb where line #26 raised:

Mysql::Error: Unknown column 'programs.containerformat_id' in 'where clause': SELECT * FROM `programs` WHERE (`programs`.containerformat_id = 2)

but data is storing in the correspomding tables.

my code details;

in containerformatcontroller:
def new
    @containerformat = Containerformat.new
    @containerformat.transport_streams.build
     @containerformat.programs.build
     @containerformat.streams.build

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

--------in containerformat model
class Containerformat < ActiveRecord::Base
has_many :transport_streams
has_many :programs
has_many :streams

def transport_stream_attributes=(transport_stream_attributes)
transport_stream_attributes.each do |attributes|
transport_streams.build(attributes)
end
end

def program_attributes=(program_attributes)
program_attributes.each do |attributes|
programs.build(attributes)
end
end
def stream_attributes=(stream_attributes)
stream_attributes.each do |attributes|
streams.build(attributes)
end
end

end
---------------------in views(new.html.erb)<h1>New containerformat</h1>

<% form_for(@containerformat) do |f| %>
  <%= f.error_messages %>

  <p>
    <%= f.label :stream_name %><br />
    <%= f.text_field :stream_name %>
  </p>
  <p>
    <%= f.label :location %><br />
    <%= f.text_field :location %>
  </p>
  <p>
    <%= f.label :containertype_id %><br />
    <%= f.text_field :containertype_id %>
  </p>
 
  <%for transport_stream in @containerformat.transport_streams%>
     <%fields_for "containerformat[transport_stream_attributes][]", transport_stream do |ts_form|%>
     <p>Num_programs</p>
     <p><%= ts_form.text_field :num_programs%></p>
     <p>Encryption std</p>
     <p><%= ts_form.text_field :encryption_std%></p>
     <% end %>
     <% end %>

 
    <%for program in @containerformat.programs%>
       <%fields_for "containerformat[program_attributes][]", program do |ts_form|%>
       <p>PID</p>
       <p><%= ts_form.text_field :pid%></p>
       
       <% end %>
       <% end %>
       
       
       <%for stream in @containerformat.streams%>
              <%fields_for "containerformat[stream_attributes][]", stream do |ts_form|%>
              <p>videocodecid</p>
              <p><%= ts_form.text_field :videoCodec_id%></p>
              <p>audiocodecid</p>
              <p><%= ts_form.text_field :audioCodec_id%></p>
             
              <% end %>
              <% end %>
 
 
  <p>
 
    <%= f.submit "Create" %>
  </p>
<% end %>

<%= link_to 'Back', containerformats_path %>
-------showpage
<p>
  <b>Stream name:</b>
  <%=h @containerformat.stream_name %>
</p>

<p>
  <b>Location:</b>
  <%=h @containerformat.location %>
</p>

<p>
  <b>containertype_id:</b>
  <%=h @containerformat.containertype_id %>
</p>

<%- @containerformat.transport_streams.each do |task| -%>
<p>
    <b>Number of programs:</b>
    <%= task.num_programs %>
</p>
<%- end -%>

<%- @containerformat.programs.each do |task| -%>
<p>
    <b>PID:</b>
    <%= task.pid %>
</p>
<%- end -%>

<%- @containerformat.streams.each do |task| -%>
<p>
    <b>videoCodec_id:</b>
    <%= task.videoCodec_id %>
   
    <b>audiocodecid:</b>
    <%= task.audioCodec_id %>
    </p>
<%- end -%>

<%= link_to 'Edit', edit_containerformat_path(@containerformat) %> |
<%= link_to 'Back', containerformats_path %>

Can you tell me where i am doing the mistake?
Can you suggest me how to get the valus of other tables in the show page?

regards
Srikanth

there are so many tutorials on how to create multiple models in one form, but i want to do something more simple and its killing me, i cant find ANY examples.  How do you create multiple instances of the SAME model on one form.  Say you wanted a tasks entry screen where you could enter 4 tasks in one view and submit and have them all created.  What then? please help, ive wasted half the day on this

Hi all

I have 2 tables. Lesson and Tag. A lesson can have multiple tags. When I save, records are saving in both tables but the tag.body is saving as NULL. What am I doing wrong?

This is lesson,rb
class Lesson < ActiveRecord::Base
#Mandatory fields validation
validates_presence_of :title, :contact_yn
has_many :tags
end

This is tag.rb
class Tag < ActiveRecord::Base
    belongs_to :lesson
end

My lesson.new is
<h1>New lesson</h1>

<%= error_messages_for :lesson %>
<%= error_messages_for :tag %>

<% form_for(@lesson) do |f| %>
  <p>
    <%= f.label :title %><br />
    <%= f.text_field :title %>
  </p>
  <p>
    <%= f.label :description %><br />
    <%= f.text_area :description %>
  </p>

  <p>
    Can others contact you?<br />
   <%= f.select :contact_yn, ['Yes', 'No'] %>
  </p>
<% fields_for :tags do |i| %>
      <p>
        Tags:<br />
    <%= i.text_field :body %>
</p>
<% end %>
  <p>
    <%= f.submit 'Save' %>
  </p>

<% end %>
<%= link_to 'Back', lessons_path %>

My lesson controller is
def new
    @lesson = Lesson.new
    @tag = Tag.new
   
    respond_to do |format|
      format.html # new.html.erb
      format.xml  { render :xml => @lesson }
    end
  end

  # GET /lessons/1/edit
  def edit
    @lesson = Lesson.find(params[:id])
  end

  # POST /lessons
  # POST /lessons.xml
  def create
    @lesson = Lesson.new(params[:lesson])
    $tag = @lesson.tags.build(params[:tag])

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

When I save, records are saving in both tables but the tag.body is saving as NULL. What am I doing wrong?

TIA
-vas