Inserting data into a table is made simple with Room. In this video, learn how you can use a wrapper class to abstract away your underlying data access solution to insert records.
- [Narrator] Let's get our Data Source class ready to work…with our room components.…What we want here is to have our data source class continue…to act as the abstraction layer for our underlying…database solution.…So inside of our constructor here on line 17, we want to…get our topsy turvey database instance using that get…instance method that we created previously.…So we're just going to tab into this function and we're…going to create our topsy turvey database and let's name…that database.…
And we're going to use the get instance method…providing the context.…So that's it, we now have our database.…The next thing we want to do is get access to our DAOs.…Remember, our database class has methods that make…those available for us.…So we're just going to grab them by first typing recipeDAO…and we're going to set this equal to the database dot…recipeDao method.…And we're going to convert these variables to fields because…we need to use them later on in the class when we…start to work with our cred methods.…
So if we come to the beginning of the line where we have…
To begin, Annyce Davis reviews using the de facto data persistence solution available on Android: SQLite. She takes you through basic SQLite concepts—such as how to create a database wrapper and insert data into a table—as well as a few more advanced topics. Next, she covers working with Cupboard, an open-source project dedicated to simplifying your SQLite interactions. To wrap up, she dives into working with Realm, an object database solution designed with mobile devices in mind. Throughout the course, Annyce discusses establishing relationships between database tables, creating and running queries, as well as performing data migrations.
- Overview of SQLite
- Defining a database table's schema
- Exploring SQLite create table syntax
- Executing create table statements
- Inserting data with a foreign key relation
- Inspecting the database using a terminal
- Updating and deleting records
- Working with Cupboard
- Working with Realm
Skill Level Intermediate
Q: This course was updated on 05/24/2018. What changed?
A: New videos were added that cover working with Room.
Learning Firebase Cloud Messaging for Androidwith Joe Marini52m 49s Intermediate
1. SQLite Basics
2. SQLite Beyond the Basics
3. Working with Room
4. Working with Cupboard
5. Realm Basics
6. Realm Beyond the Basics
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.