V8 field scrambling

Scramble social security numbers during development and testing. When a social security number is posted, "encrypt" (scramble the digits), then POST the randomized digits to the database.

Then GET the social security number by decrypting the scrambled digits with a private key and returning the real social security number back to the client.

For this change to take effect you have to enable modification of request and response in admin console script editor. Checkbox label is 'Allow script to modify request (pre-process) or response (post-process)'.

var privateKey = 27;
 
// post.pre_process
 
function encode(key, value) {
    var result = "";
    for (i = 0; i < value.length; ++i) {
        result += String.fromCharCode(value.charCodeAt(i) + parseInt(key));
    }
    return result;
};
 
var lodash = require('lodash.min.js');
 
lodash._.each(event.request.payload.resource, function (record) {
 
    if (!record.ssn) {
        throw "Social Security Number is required!";
    }
 
    record.ssn = encode(privateKey, record.ssn);
 
});
 
 
// get.pre_process
 
function decode(key, value) {
    var result = "";
    for (i = 0; i < value.length; ++i) {
        result += String.fromCharCode(value.charCodeAt(i) - parseInt(key));
    }
    return result;
};
 
var lodash = require('lodash.min.js');
 
lodash._.each(event.response.content.resource, function (record) {
    record.ssn = decode(privateKey, record.ssn || '');
});