Odoo Help


How to access cr or database in httprequest in openerp 7?

Praveen Shakkarval
on 3/2/16, 5:07 PM 887 views

I want to access database in my below method in openerp 7:


def index(self, req, data, token):

data = json.loads(data)

model = data.get('model', [])

columns_headers = data.get('headers', [])

rows = data.get('rows', [])

return req.make_response(

self.from_data(columns_headers, rows),


('Content-Disposition', 'attachment; filename="%s"'

% self.filename(model)),

('Content-Type', self.content_type)


cookies={'fileToken': token}


I accessed database in odoo 8 using request.cr in same method.

but here when I tried req.cr and used it too access method, it throws error

cr is not attribute of request.

So tell me a way to access either cr or database somehow.

Axel Mendoza
On 3/2/16, 7:50 PM

You could do it like:

registry = openerp.modules.registry.Registry(dbname)
with registry.cursor() as cr:
    cr.execute("""SELECT * from res_users""")

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 3/2/16, 5:07 PM
Seen: 887 times
Last updated: 3/10/16, 2:52 AM