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	12740
Error in sql while using operator "in" and variable 已解决 function execute sql syntax	3 10月 15	6529
is possible to add 2 filters to the web portal similar to searchbar_filters? portal	2 7月 25	1398
How can I allow one portal user to see another portal user's information (like Sales Orders, Invoices)? 已解决 portal	1 5月 24	2673
Use worksheets in Odoo Portal portal	2 2月 24	2178

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！