from openerp.http import request as r

def get_res_currency():

    query = '''
        SELECT
            id,
            name,
            local_name,
            symbol,
            decimal_separator,
            thousands_separator,
            decimal_places
        FROM res_currency
        WHERE active = True
    '''

    r.cr.execute(query)
    return [
        {
            'id': j[0],
            'name': j[1],
            'local_name': j[2],
            'symbol': j[3],
            'decimal_separator': j[4],
            'thousands_separator': j[5],
            'decimal_places': j[6],
        } for j in r.cr.fetchall()
    ]