Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
会計
在庫
PoS
プロジェクト
MRP

All apps

全てのポスト人々バッジ

タグ (全て表示)

odoo accounting v14 pos v15

このフォーラムについて

ヘルプ

How to invoke model and cursor inside controller? Openerp Version 7

models cursor controllers version7

4 返信

8292 ビュー

Gustavo Seluja

I'm writing a controller for V7 and I have this problem. I want to get the database name and the cursor but I can't because there is no a "request" parameter like in V8 to get the cr value and I can't obtain database name from anywhere too. As you can see, I hardcoded the database name just for testing but I have to get it programatically or get the cursor value. How can I do that? Following, the actual code:

class firmaController(http.Controller): 
 _cp_path = '/x_firma' 

 @http.httprequest 
 def index(self, request, **post): 

     db_name = 'GRP-MRREE' 
     cr = openerp.pooler.get_db(db_name).cursor() 
     bd_obj = openerp.pooler.get_pool(db_name) 
     firma_obj = bd_obj.get('x_firma') 
     id_transaccion = post['id_transaction']
     documento = firma_obj.invocar_ws_obtenerDocumentosFirmados(cr, SUPERUSER_ID, id_transaccion)
     cr.commit() 
     cr.close() 
     return werkzeug.utils.redirect('/') 
firmaController()

Axel Mendoza

Hi Axel, I'm really new with openerp and particularly, with controllers. What do you mean with "authenticated sessions" and how can I do that? For what I've been doing with the debugger tool, request.session._db is coming with False value. Do you have any example how to implement authenticated sessions?

Axel Mendoza

Authenticated sessions are those that needs a previous login on the specific database for the user

Axel Mendoza

最善の回答

Hi @Gustavo Seluja

Normally you need to work with authenticated sessions on your methods in a controller. If that is the case you could get the db_name from the OpenERPSession object like:

db_name = request.session._db

If you are not working with an authenticated session you could always get the db_name as a parameter in your method definition like:

class firmaController(http.Controller): 
    _cp_path = '/x_firma' 
    @http.httprequest 
    def index(self, request, db=None, **post):

Using the former your url need to add an ?db=db_name as a querystring

Hope this solve your problem

Akira Chen

How do I use C# to call the function？

def index(self, request, **post):

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！

今すぐアカウントを作成して、限定機能を利用したり、素晴らしいコミュニティと交流しましょう！

登録

関連投稿	返信	ビュー
how we render model form in controller in odoo v9 models controllers odooV9	3 12月 19	9061
Need help in new controller for new model and module. Always KeyError in return from controller to model 解決済 models download controllers	2 8月 17	6850
ImportError: cannot import name controllers, why? 解決済 v8 import models controllers	2 12月 23	45703
[Odoo 14] - Model is not updating via Controller widget models controllers v14	1 9月 21	5514
Open an url using python, without using return models actions url controllers	1 7月 21	6054

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！