How to run Odoo ORM methods in python console?

Question

I would like to use ORM methods like browseor searchin the python console.

$pwd
/opt/odoo/

$python
>>> import openerp
>>> product_obj = pool.get('product.product)
Traceback (most recent call last):
 File "<stdin>", line 1, in <module>
NameError: name 'pool' is not defined

How could I achieve this?

Answer 1

In version 9, you can run the odoo shell with odoo.py shell -d <database>, thanks to this commit

In version 8, functionality is not built-in, but you can use this script , this module, or OERPLib

Answer 2

The pool must be connected to the database, so you need to create the pool first, for example:

pool = openerp.modules.registry.RegistryManager.get("test")

This should return the pool connected to the 'test' database