V8 sql with nosql

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsV8 sql with nosql

// script db._table.contact.get.post_process

// for each record in the MySQL db service, query the MongoDB service to get the Twitter handle for that contact

var lodash = require("lodash.min.js");

if (event.response.content.resource) {

lodash._.each (event.response.content.resource, function( record ) {

// filter by email var params = {

"filter": "email=" + record.email }

// get matching record from MongoDB service var result = platform.api.get("mongodb/_table/contact", params);

// from_mongo_twitter can be a field in MySQL schema, but it doesn't have to be record.from_mongo_twitter = result.content.resource[0].twitter;

// set this flag if you change the response content // you can also set event.response.status_code and event.response.content_type event.response.content_changed = true; }); }