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

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

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

models cursor controllers version7

4 Antwoorden

8310 Weergaven

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

Beste antwoord

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

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
how we render model form in controller in odoo v9 models controllers odooV9	3 dec. 19	9073
Need help in new controller for new model and module. Always KeyError in return from controller to model Opgelost models download controllers	2 aug. 17	6865
ImportError: cannot import name controllers, why? Opgelost v8 import models controllers	2 dec. 23	45713
[Odoo 14] - Model is not updating via Controller widget models controllers v14	1 sep. 21	5516
Open an url using python, without using return models actions url controllers	1 jul. 21	6060

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!