3

How do I edit an existing object in the database? For example, if I have a model like this: class Topic{title,content,author}, when I edit and save the object I do not want to add the "author" object again. How do I update my existing object rather than adding a new one?

andronikus
  • 4,125
  • 2
  • 29
  • 46
WoooHaaaa
  • 19,732
  • 32
  • 90
  • 138
  • If one of the answers you got solved your problem, please accept it by clicking on the check mark. – andronikus Sep 27 '11 at 03:05
  • i think i didn't make myself clear, another example: my existing object is Topic(id:1,content:'xxx',author:'roy'...) ， now i pass an object like Topic(id:1,content:'yyy',author:null...)。how do i just update the not null fields ? does it have any easy way to do that ? – WoooHaaaa Sep 27 '11 at 04:28
  • Oh, you only want to update certain fields and not others? Not easy, but see my answer below. – andronikus Sep 27 '11 at 12:42

2 Answers2

5

If you're inheriting from the Model class (as you should), it provides a save() method as well as an ID attribute. When you call save() on an object you got out of the database, it will be updated, and if you call it on a new object it will be saved to the database. It's all automagical!

Updating only specific fields

Model.save() saves the whole object, so if you want to update only some data fields in your object, you first have to construct the exact object you want to go in your database. So let's say you don't want to update null fields, using your Topic(id, content, author) object:

Topic newT = Topic(1L, 'yyy', null);
Long id = newT.getID();

Topic oldT = Topic.findByID(id);  //Retrieve the old values from the database

Author newAuthor = newT.getAuthor(); //null

if (newAuthor != null) {  //This test will fail
  oldT.setAuthor(newAuthor);  //Update the old object
}

String newContent = newT.getContent(); //Not null

if (newContent != null) {
  oldT.setContent(newContent);  //Update the old object
}

// Now the object oldT holds all the new, non-null data.  Change the update tests as you see fit, of course, and then...

oldT.save();  //Update the object in the database.

That's how I would do it. Depending on how many fields you have this code is going to get really clunky really fast. Definitely put it in a method. Also, see here about findByID() and other ways to pull objects from the database.

andronikus
  • 4,125
  • 2
  • 29
  • 46
  • In play 2.0.2, Model class provides update method also, does it work the same way as you described for save method to update particular column or I have to implement it the way you have described but that does not make a sense for update method. – Neha Choudhary Nov 19 '12 at 08:05
4

If you look at the JPA Object Binding part of the documentation, you will see it explains that, if you pass in an object to your controller, containing an ID, the object is first automatically loaded from the database, and then the new fields passed in are added to the object.

This means, you can simply call the save() method.

So, you controller action could be something like

public static void editTopic(Topic topic) {
   topic.save();
   //...any post edit processing
}
Codemwnci
  • 54,176
  • 10
  • 96
  • 129