What is the difference between `db_connect` and `get_db` to obtain a Cursor?

Question

When I need a new Cursor() for a database, I have at least 2 ways to initialize a new one.

Using the helpers functions in openerp.pooler :

cr = openerp.pooler.get_db('name_of_my_database').cursor() # or
db, pool = openerp.pooler.get_db_and_pool('name_of_my_database')
cr = db.cursor()

Or using openerp.sql_db.db_connect :

cr = openerp.sql_db.db_connect('name_of_my_database').cursor()

Note that both are used in OpenERP server or addons.

What is the difference between them and for which use ca

Guewen Baconnier · Accepted Answer

By a reading of the functions, I found that:

openerp.pooler.get_db get the Registry for the database and returns the db attribute of the Registry . Registry().db is initialized using openerp.sql_db.db_connect .

At end, they both return an instance of a openerp.sql_db.Connection which respond to cursor() .

It seems to me that we can use one or the other equally. openerp.pooler.get_db appears to be more 'High-Level' and needs to already have a Registry for the database.

My feeling is that we s

Ram Peri · Answer

This is a standard design pattern.
Applications usually pool all their database connections so that each module does not have to create its on database connection (as they are very costly)
You should always use the pooler.get_db, which underneath creates a connection if needed.
But, if the pooler already has a connection, it saves you a lot of time and gives it to you.
Just do repeat, you should always avoid making direct database connections and use the pooler (think of like like a car pool)

관련 게시물	답글	화면
How to reset the development database 해결 완료 development database	2 8월 25	3484
How to get psql database access? database api	2 9월 24	3882
How to select a different database on login screen 해결 완료 database v7	4 7월 24	33918
Specify Odoo database in API request database api	0 11월 23	3079
What's the context? 해결 완료 development v7	9 3월 24	121054

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!