We have imported our database our mock data into our RethinkDB instance. Now it's time to run a use case query and make use of it. But before we do so, we need to figure out one data alteration. We have made a mistake while generating mock data (on purpose actually) we have a $ sign before ctc. Hence, it becomes tough to perform salary-level queries.
Before we move ahead, we need to figure out this problem, and basically get rid of the $ sign and update the ctc value to an integer instead of a string.
In order to do this, we need to perform the following operation:
Traverse through each document in the database
Split the ctc string into two parts, containing
$and the other valueUpdate the
ctcvalue in the document with a new data type and value
Since we require the chaining of queries, I have written a small snippet in Node.js to achieve the previous scenario as follows:
var rethinkdb = require('rethinkdb');
var connection = null;
rethinkdb.connect...