This post helps demonstrate the ease with which you can save and update a record with the help of Sugar in android project.
For an introduction to Sugar, click here.
Firstly, to enable your model to utilize Sugar’s benefits, you need to have configured Sugar in the manifest file (as shared in the introduction) and the model needs to extend SugarRecord.
Saving a record becomes straight forward, as you’re only interacting with your objects and not the usually messy way of dealing with SQL queries directly. Here’s a way to save a record using Sugar:
// Note class represents model. It extends SugarRecord. Note note = new Note(context); note.setTitle("Make Tea"); note.setDescription("Add tea along with milk and sugar. Boil for few minutes"); note.save();
That is all you need to do to save a record into the android database. The save() method takes care of inserting the record into its corresponding table.
Similarly, modifying and updating a record is made very simple with Sugar. Here’s a way to do it.
// obtain a reference to the note record from database. Note note = Note.findById(context, 1); note.setDescription("Take some water. Add milk, tea and sugar. Boil it for few minutes"); note.save();
Here findById() is a query method to obtain the record with id 1 from the table. After getting the reference to the instance, modify the values and call the save() method to update the record into the table.
Do try it out.