eiru_reports_crifin/controllers/helpers/res_store.py

# -*- coding: utf-8 -*-
from openerp.http import request as r

def get_res_store():
    query = '''
        SELECT  id,
                name,
                company_id
        FROM res_store
    '''

    r.cr.execute(query)

    return [
        {
            'id': j[0],
            'name': j[1],
            'company_id': j[2],
        } for j in r.cr.fetchall()
    ]