Executing data exploration use cases

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 value
• Update the ctc value 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...