Updating and deleting documents
Now that you've inserted a few documents into your RethinkDB table, you'll probably be wondering how to update or delete these documents using Node.js.
You'll be happy to know that the queries for updating and removing are exactly the same as the ones you learned in Chapter 2, The ReQL Query Language and used in the web interface. Let's go over them very briefly.
RethinkDB provides us with the update
command to update the existing documents. This command accepts as input a JSON document with the required changes. As an example, suppose we want to add a gender
field to all documents in the fake_data
table. We can do so with the following lines of code:
r.table('fake_data').update({gender: "male"}).run(conn, function(err, result) { if (err) throw err; console.log(result); });
As you can see, the query syntax is exactly the same as running it from the web interface. The only difference is appending the run
command at the end of the query.
Now, let's take look...