CartoQuery

carto_query.py

# Run a query over the CARTO SQL api 
def carto_query(query,username,api_key):
    params = {'q' : query, 'format':'csv'}
    
    if api_key:
        params['api_key'] = api_key
        
    url = 'https://{}.carto.com/api/v2/sql?'.format(username) + urlencode(params)
    return pandas.read_csv(url)
    
# Take a matplotlib figure and turn it in to a response from the server
def mpl2img(fig):
    canvas = FigureCanvas(fig)
    img = StringIO()
    canvas.print_png(img)
    res = make_response(img.getvalue())
    res.headers['Content-Type'] = 'image/png'
    return res