In this video learn how to execute queries against SQLite using Cupboard. Annyce explains how the query results are returned and how to display the records in a RecyclerView.
- [Narrator] Cupboard Queries have the following attributes;…first: they make use of the builder pattern…when establishing your desired criteria…for the returned results.…Second: you can have your results returned to…you as objects or cursors;…this gives you flexibility in determining how…you want to handle the results.…And, finally, very similar to standard SQLite,…you will use strings for your selection criteria.…Let's say we wanted to retrieve all active…email records in our database.…
You'd start off with a call to…the very familiar withDatabase method.…Then, you'd use the query method…to provide the type of object that…you are interested in.…In this example, we want emails.…Next, you would typically use…the withSelection method to filter your results.…In this case, we want all emails that are active.…And then, finally, the query is executed…with the call to the queried method.…
Cupboard provides several methods…to filter your returned results.…We just saw an example of the withSelection condition;…however, there are many more available to you.…
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
Android App Development: Unit Testingwith James P White2h 59m Intermediate
1. SQLite Basics
2. SQLite Beyond the Basics
3. Working with Cupboard
4. Realm Basics
5. 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.