Python 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
 
import httplib;
import json;
 
content = event['response']['content'];
host = event['request']['headers']['host'][0];
headers = {
    'x-dreamfactory-api-key':platform['session']['api_key'],
    'x-dreamfactory-session-token':platform['session']['session_token']
};
 
connection = httplib.HTTPConnection(host);
 
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
        connection.request('GET', '/api/v2/mongodb/_table/contact?'+filter, '', headers);
        response = connection.getresponse();
        result = json.loads(response.read());
 
        # from_mongo_twitter can be a field in MySQL schema, but it doesn't have to be 
        record['from_mongo_twitter'] = result['resource'][0]['twitter'].encode('utf-8');
        records[i] = record;
 
event['response']['content']['resource'] = 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;