Skip to Content
This question has been flagged
portalexecutesqlcontrollercr
2 Replies
5301 Zobrazenia
Avatar
Arian Shariat

I want to use sql queries in CustomerPortal class controllers. I wrote following code:

request.cr.execute("""my query""")
result = request.cr.fetchall()
but I get the following error:
AttributeError: 'CustomerPortal (extended by PortalAccount, Custome' object has no attribute 'cr'a
what should I do?
Avatar
Zrušiť
Avatar
Khubab Shams
Best Answer

Hello Arian, try to use 'request.session.cr' instead of 'request.cr'.


Avatar
Zrušiť
Arian Shariat
Autor

thanks! request.env.cr worked for me aswell.

Avatar
Ray Carnes (ray)
Best Answer

https://github.com/odoo/odoo/blob/13.0/addons/web/controllers/main.py#L1551

## inside try

registry = odoo.modules.registry.Registry(dbname)
with registry.cursor() as cr:
    cr.execute(""" query """)
    row = cr.fetchone()
Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
How to execute sql query on website controller? Solved
many2many query execute sql controller
Avatar
Avatar
3
máj 20
12729
Error in sql while using operator "in" and variable Solved
function execute sql syntax
Avatar
Avatar
3
okt 15
6529
is possible to add 2 filters to the web portal similar to searchbar_filters?
portal
Avatar
Avatar
Avatar
2
júl 25
1391
How can I allow one portal user to see another portal user's information (like Sales Orders, Invoices)? Solved
portal
Avatar
Avatar
1
máj 24
2662
Use worksheets in Odoo Portal
portal
Avatar
Avatar
2
feb 24
2174