Odoov13 how to use cr.execute in a controller?

Question

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?

Khubab Shams · Answer

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

Ray Carnes (ray) · Answer

https://github.com/odoo/odoo/blob/13.0/addons/web/controllers/main.py#L1551 [1]
## inside try
registry  =  odoo . modules . registry . Registry ( dbname )
with  registry . cursor () as  cr :
cr . execute ( """ query """)
row  =  cr . fetchone ()

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

相關帖文	回覆	瀏覽次數
How to execute sql query on website controller? 已解決 many2many query execute sql controller	3 5月 20	12752
Error in sql while using operator "in" and variable 已解決 function execute sql syntax	3 10月 15	6540
is possible to add 2 filters to the web portal similar to searchbar_filters? portal	2 7月 25	1406
How can I allow one portal user to see another portal user's information (like Sales Orders, Invoices)? 已解決 portal	1 5月 24	2688
Use worksheets in Odoo Portal portal	2 2月 24	2189

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！