Odoo Help


how to use database cursor in a class That does not inherit from orm.Model ?

Nirav Bhadradiya
on 3/13/13, 9:09 AM 3,777 views

How to use database cursor in OpenERPAuthProvider in http_server.py in server part??


Nicolas Bessi

--Nicolas Bessi--

| 5 7 8
Lausanne, Switzerland
--Nicolas Bessi--
Nicolas Bessi
On 3/14/13, 5:54 AM

Hello you can do:

from openerp import pooler, sql_db
# Get database connexion
db = sql_db.db_connect(db_name) # You can get the db name from config
cr = db.cursor()

# Access pooler the one in self.pool
pool = pooler.get_pool(cr.dbname)

Hello nbessi, thank you for your useful answer but actually i don't know how to get db_name pro grammatically in my case,,,so it will be very helpful if you will tell me , how to fetch "db_name" from config(which you are saying)... Thank you

Nirav Bhadradiya
on 3/14/13, 6:40 AM

Hello nbessi,,,i have tried your given solution and i have done what i want thank you so much for your help.

Nirav Bhadradiya
on 3/14/13, 9:15 AM

This way i do get access to db but only to some models like res.partner but not to other models like product.product or website ?!? How can i access models like website too?

Michael Karrer
on 3/18/15, 3:06 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 3/13/13, 9:09 AM
Seen: 3777 times
Last updated: 4/10/15, 1:19 AM