İçereği Atla
Bu soru işaretlendi
portalexecutesqlcontrollercr
2 Cevaplar
5312 Görünümler
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
Vazgeç
Avatar
Khubab Shams
En İyi Yanıt

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


Avatar
Vazgeç
Arian Shariat
Üretici

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

Avatar
Ray Carnes (ray)
En İyi Yanıt

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
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
How to execute sql query on website controller? Çözüldü
many2many query execute sql controller
Avatar
Avatar
3
May 20
12731
Error in sql while using operator "in" and variable Çözüldü
function execute sql syntax
Avatar
Avatar
3
Eki 15
6529
is possible to add 2 filters to the web portal similar to searchbar_filters?
portal
Avatar
Avatar
Avatar
2
Tem 25
1394
How can I allow one portal user to see another portal user's information (like Sales Orders, Invoices)? Çözüldü
portal
Avatar
Avatar
1
May 24
2669
Use worksheets in Odoo Portal
portal
Avatar
Avatar
2
Şub 24
2176