Python SQL with NoSQL

NOTE: DreamFactory Python scripting requires 'bunch' package to be installed on server. sudo pip install bunch

# 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
 
content = event.response.content;
 
if content.resource != "":
    records = content.resource;
    for (i, record) in enumerate(records):
        # filter by email
        filter = "filter=" + "email=" + record.email;
 
        # get matching record from MongoDB service
        result = platform.api.get('/mongodb/_table/contact?'+filter);
        # convert json string -> dict -> bunch
        data = bunchify(json.loads(result.read()));
 
        # from_mongo_twitter can be a field in MySQL schema, but it doesn't have to be 
        record.from_mongo_twitter = data.resource[0].twitter.encode('utf-8');
        records[i] = record;
 
 
event.response.content = records;
# 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;