V8 sql with nosql

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsV8 sql with nosql
(Created page with "// 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 = re...")
 
Line 1: Line 1:
// script db._table.contact.get.post_process
+
<pre>// 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
 
// for each record in the MySQL db service, query the MongoDB service to get the Twitter handle for that contact
Line 26: Line 26:
 
});
 
});
 
}
 
}
 +
</pre>

Revision as of 20:44, 22 February 2016

// 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;
	});
}