An application built in NodeJs that recognises the sensitive data present in the database and trims it off.
Built as a part of a contest in TopCoder Open. Here's the competition link.
- fast-csv
- fs
- lodash
- prompt
- config-node
The mirror of the database (Dummy DB) is stored in the csv file. The user enters the path to csv that needs to be modified. fast-csv and fs are used to read and process the rows of the csv file one at a time. lodash library is used in the operations that are used to transform the data.
The application uses the Luhn Algorithm or Mod Ten Algorithm to recognise the sensitive data ( credit/debit card numbers, Account numbers ) present in the database. Every creditCard/AccountNo is replaced by the predefined string '<CREDIT_CARD>'/'<ACCOUNT_NO>', respectively, configured in the config directory.
Variables used in the production mode or the development mode can be configured in the production.json or the development.json files resplectively.
The data base entries are present in the test.csv file and the trimmed entries are written into the modify.csv file. Look into the files for the demo of the implementation.
cd Sensitive_DataLookup_and_Trim
npm install
node app.js
<Input the path to csv file>
And you are ready to go!