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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

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

models cursor controllers version7

4 Odpowiedzi

8311 Widoki

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

Najlepsza odpowiedź

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):

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
how we render model form in controller in odoo v9 models controllers odooV9	3 gru 19	9074
Need help in new controller for new model and module. Always KeyError in return from controller to model Rozwiązane models download controllers	2 sie 17	6865
ImportError: cannot import name controllers, why? Rozwiązane v8 import models controllers	2 gru 23	45713
[Odoo 14] - Model is not updating via Controller widget models controllers v14	1 wrz 21	5516
Open an url using python, without using return models actions url controllers	1 lip 21	6060

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!