Databases
StackOverflow2013
Postsdbo
POSaving new records based on older instances in Rails
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSaving new records based on older instances in Rails
    primarykey
    data
    text
    <p>I have a Lesson model and a Revision model. When a lesson is created its first revision is created (the models have a has_many through: relation). Users should be able to create new revisions by updating the old one - but the updates would save to a new revision.</p> <p>Currently my lessons and the first revision version save properly, through a nested form. What I want to know is - how can I create a "new revision" form that does what the update form does, but save the results to a new revision? (The lesson the new revision is tied to would be unchanged.)</p> <p>EDIT: With my updated (and hopefully more concise) code below, new revisions save, but I never get directed to a form. I'm sent straight to the profile page where I can see the list of revisions. How can I make updates rather than just a duplicate? I've been reading <a href="http://guides.rubyonrails.org/form_helpers.html" rel="nofollow">http://guides.rubyonrails.org/form_helpers.html</a>, but am clearly still missing a step.</p> <p>The entire app is on <a href="https://github.com/arilaen/pen" rel="nofollow">https://github.com/arilaen/pen</a>.</p> <p>Revision Controller</p> <pre><code>class RevisionsController &lt; ApplicationController def new @revision = Revision.new @lesson = Lesson.find(params[:lesson_id]) end def create @revision = Revision.new(params[:revision]) @revision.user_id = current_user.id @revision.time_updated = DateTime.now @revision.save redirect_to current_user.profile end def show @revision = Revision.find(params[:id]) end def edit @old_revision= Revision.find(params[:id]) @revision = Revision.new(params[:revision]) @revision.user_id = current_user.id @revision.lesson_id = @old_revision.lesson_id @revision.time_updated = DateTime.now @revision.save redirect_to current_user.profile end end </code></pre> <p>Revision Model:</p> <pre><code>class Revision &lt; ActiveRecord::Base attr_accessible :comment, :lesson_id, :user_id, :description, :content, :time_updated, :old_revision_id belongs_to :lesson, :class_name =&gt; "Lesson", :foreign_key =&gt; "lesson_id" belongs_to :user, :class_name =&gt; "User", :foreign_key =&gt; "user_id" accepts_nested_attributes_for :lesson end </code></pre> <p>New Revision Form</p> <p>edit.html.erb</p> <pre><code>&lt;%= form_for @revision do |f| %&gt; &lt;%= render "form" %&gt; &lt;% end %&gt; </code></pre> <p>_form.html.erb in revisions</p> <pre><code>&lt;%= form_for @revision :url =&gt; { :action =&gt; "create" } do |f| %&gt; &lt;div class="field"&gt; &lt;%= f.label :description %&gt;&lt;br /&gt; &lt;%= f.text_field :description, :value =&gt; @old_revision.description %&gt; &lt;/div&gt; &lt;div class="field"&gt; &lt;%= f.label :content %&gt;&lt;br /&gt; &lt;%= f.text_area :content, :value =&gt; @old_revision.content %&gt; &lt;/div&gt; &lt;div class="field"&gt; &lt;%= f.label :comment %&gt;&lt;br /&gt; &lt;%= f.text_field :comment, :value =&gt; @old_revision.comment %&gt; &lt;/div&gt; &lt;div class="actions"&gt; &lt;%= f.submit %&gt; &lt;/div&gt; &lt;% end %&gt; </code></pre> <p>Excerpt from Revision/show:</p> <pre><code> &lt;% if current_user.nil? %&gt; &lt;% else %&gt; &lt;% if @revision.user_id = current_user.id %&gt; &lt;%= link_to 'New Revision', edit_lesson_revision_path(@revision.id) %&gt;&lt;br /&gt; &lt;% else %&gt; &lt;%= link_to 'Copy', edit_lesson_revision_path(@revision.id) %&gt; &lt;% end %&gt; &lt;% end %&gt; </code></pre> <p>Here's my lessons model because it was requested earlier, may or may not be relevant to solution:</p> <pre><code>class Lesson &lt; ActiveRecord::Base attr_accessible :stable, :summary, :title, :time_created, :revision, :revisions_attributes has_many :revisions, :class_name =&gt; "Revision" has_many :users, :through =&gt; :revisions accepts_nested_attributes_for :revisions end </code></pre> <p>routes.rb</p> <pre><code>resources :revisions resources :lessons do resources :revisions end </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USarilaan
    1. USarilaan
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POSaving new records based on older instances in Rails
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSaving new records based on older instances in Rails
      1. This table or related slice is empty.
      1. VTDownMod
    1. COCan you post your Lesson model? Does a Lesson have many revisions? If so, I'd look at nested resources. http://stackoverflow.com/questions/12375361/rails-nested-resources It helps out a lot when you have a relationship like this where one model has_many of another model. Rails helps manage the IDs and makes your job a lot easier if you follow this convention of nested resources.
      singulars
      1. POSaving new records based on older instances in Rails
      1. USKenrick Chien
    2. COTake a look at this to modify your form to handle nested models: http://railscasts.com/episodes/196-nested-model-form-part-1
      singulars
      1. POSaving new records based on older instances in Rails
      1. USKenrick Chien
    3. COI've used the second link you referred to, which another user gave me in response to an earlier question (http://stackoverflow.com/questions/16706372/saving-and-redirecting-with-a-model-and-revision-model-in-rails), to help save lessons and revisions. I'll add the forms I used there and the lesson model. The question I have here, for a new form how to use an older version of a revision to create a new one (like update, but saving a new object). The lesson would be the same.
      singulars
      1. POSaving new records based on older instances in Rails
      1. USarilaan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload