How to use database cursor in OpenERPAuthProvider in http_server.py in server part??
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
1
Reply
9689
Views
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)
pool['res.user'].browse...
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
Hello nbessi,,,i have tried your given solution and i have done what i want thank you so much for your help.
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?
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
3
Sep 20
|
5184 | ||
|
0
Aug 15
|
18638 | ||
|
1
Mar 15
|
6766 | ||
|
2
Mar 22
|
5936 | ||
|
0
Mar 15
|
8413 |
