Reader small image

You're reading from  Getting Started with RethinkDB

Product typeBook
Published inMar 2016
Reading LevelIntermediate
PublisherPackt
ISBN-139781785887604
Edition1st Edition
Languages
Right arrow
Author (1)
Gianluca Tiepolo
Gianluca Tiepolo
author image
Gianluca Tiepolo

Gianluca Tiepolo is a cybersecurity researcher who specializes in mobile forensics and incident response. He holds a BSc degree in Computer Science and an MSc in Information Security, as well as several security-related certifications. Over the past 12 years, he has performed security monitoring, threat hunting, incident response, and intelligence analysis as a consultant for dozens of organizations, including several Fortune 100 companies. Gianluca is also the co-founder of the startup Sixth Sense Solutions, which developed AI-based anti-fraud solutions. Today, Gianluca works as a Security Delivery Team Lead for consulting firm Accenture Security. In 2016, he authored the book Getting Started with RethinkDB, published by Packt Publishing.
Read more about Gianluca Tiepolo

Right arrow

Deleting data


Now that we have some data in our database, we can look at how we can delete specific documents. As usual, the query is very straightforward. The first thing to do is select the document to be deleted. This can be done using the document's primary key or using the filter() command. The next step is chaining the delete() command at the end of the query.

As an example, let's delete Ted's document from the people table:

r.table('people').filter({"name": "Ted"}).delete()

First, we select the correct table, then we use the filter() command to specify the predicate. In this case, we filter documents that have the name attribute equal to Ted. Finally, we call the delete() command. The resulting JSON indicates that one document has indeed been removed:

{
"deleted": 1 ,
"errors": 0 ,
"inserted": 0 ,
"replaced": 0 ,
"skipped": 0 ,
"unchanged": 0
}

Removing all documents

Occasionally, we may want to clear the entire table by removing all the documents contained in it. As in the previous section...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Getting Started with RethinkDB
Published in: Mar 2016Publisher: PacktISBN-13: 9781785887604

Author (1)

author image
Gianluca Tiepolo

Gianluca Tiepolo is a cybersecurity researcher who specializes in mobile forensics and incident response. He holds a BSc degree in Computer Science and an MSc in Information Security, as well as several security-related certifications. Over the past 12 years, he has performed security monitoring, threat hunting, incident response, and intelligence analysis as a consultant for dozens of organizations, including several Fortune 100 companies. Gianluca is also the co-founder of the startup Sixth Sense Solutions, which developed AI-based anti-fraud solutions. Today, Gianluca works as a Security Delivery Team Lead for consulting firm Accenture Security. In 2016, he authored the book Getting Started with RethinkDB, published by Packt Publishing.
Read more about Gianluca Tiepolo