eiru_dashboard_mocona/controllers/helpers/res_user.py

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

def get_user_info():
    query = '''
    SELECT
        partner.id,
        partner.name,
        partner.active
    FROM res_partner AS partner
    WHERE partner.is_medic = true
    '''

    r.cr.execute(query)

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