In this video learn how to delete records from SQLite using Cupboard. Annyce covers how to provide the selection criteria for the records you want deleted.
- [Instructor] Deleting records in Cupboard…is as simple as modifying them.…In this example, we're passing in a user with an ID of 1…to the delete method.…If the record is found,…then it will be deleted from the table.…It's that simple.…So if you had the following records,…and Amber was at ID 1,…then after running that code,…you would only have two records in the user table,…Joe and Gladys.…Cupboard also provides the ability…to delete records based on the selection criteria.…
For instance,…if we wanted to delete all user records…that were set to active,…we'd use the following variant of the delete method.…First, we pass in the entity class,…in this case user,…and then the desired selection criteria,…in this case, the active status.…This would leave us with only one record, Joe.…Finally, Cupboard gives us the ability…to remove all records from a given table.…
This means that if we no longer wanted to have…any users in our system,…we could call the delete method,…passing in null for the criteria.…Simple and powerful.…Let's move over to Android Studio now…
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.