click-odoo
helps you create and run beautiful and robust command line scripts
for Odoo. It is based on the excellent Click library.
Useful community-managed scripts can be found in click-odoo-contrib.
Contents
Check Odoo is correctly installed: python -c "import odoo"
must
work when run from another directory than the Odoo root directory.
Install click-odoo
:
pip install click-odoo
Assuming the following script named list-users.py
.
#!/usr/bin/env python
from __future__ import print_function
for u in env['res.users'].search([]):
print(u.login, u.name)
It can be run with:
python -m click_odoo -d dbname --log-level=error ./list-users.py
or:
click-odoo -d dbname --log-level=error ./list-users.py
or:
./list-users.py -d dbname --log-level=error
The other technique to create scripts looks like this. Assuming
the following script named list-users2.py
.
#!/usr/bin/env python
from __future__ import print_function
import click
import click_odoo
@click.command()
@click_odoo.env_options(default_log_level='error')
@click.option('--say-hello', is_flag=True)
def main(env, say_hello):
if say_hello:
click.echo("Hello!")
for u in env['res.users'].search([]):
print(u.login, u.name)
if __name__ == '__main__':
main()
It can be run like this:
$ ./list-users2.py --help Usage: list-users2.py [OPTIONS] Options: -c, --config PATH Specify the Odoo configuration file. Other ways to provide it are with the ODOO_RC or OPENERP_SERVER environment variables, or ~/.odoorc (Odoo >= 10) or ~/.openerp_serverrc. -d, --database TEXT Specify the database name. If present, this parameter takes precedence over the database provided in the Odoo configuration file. --log-level TEXT Specify the logging level. Accepted values depend on the Odoo version, and include debug, info, warn, error, critical. [default: error] --logfile PATH Specify the log file. --rollback Rollback the transaction even if the script does not raise an exception. Note that if the script itself commits, this option has no effect, this is why it is not named dry run. This option is implied when an interactive console is started. --say-hello --help Show this message and exit. $ ./list-users2.py --say-hello -d dbname Hello! admin Administrator ...
Finally, you can start an interactive shell by simply typing
python -m click_odoo -d dbname
or click-odoo -d dbname
.
This will launch the python REPL with an Odoo env
available
as a global variable.
Odoo version 11, 12, 13, 14, 15 and 16 are supported.
An important design goal is to provide a consistent behaviour across Odoo versions.
Note
click-odoo
does not mandate any particular method of installing odoo. The only
prerequisiste is that import odoo
must work when run from another directory than
the Odoo root directory.
You may also rely on the fact that python adds the current directory to
sys.path
, so import odoo
works from the Odoo root directory.
In such case, the only working invocation method may be
python -m click_odoo
.
By default click-odoo
commits the transaction for you, unless your script
raises an exception. This is so that you don't need to put explicit commits
in your scripts, which are therefore easier to compose in larger transactions
(provided they pass around the same env).
There is a --rollback
option to force a rollback.
A rollback is always performed after an interactive session. If you need to
commit changes made before or during an interactive session, use env.cr.commit()
.
Logging is controlled by the usual Odoo logging options (--log-level
,
--logfile
) or the Odoo configuration file.
Note the --log-level
option applies to the odoo
package only.
Usage: click-odoo [OPTIONS] [SCRIPT] [SCRIPT_ARGS]... Execute a python script in an initialized Odoo environment. The script has access to a 'env' global variable which is an odoo.api.Environment initialized for the given database. If no script is provided, the script is read from stdin or an interactive console is started if stdin appears to be a terminal. Options: -c, --config FILE Specify the Odoo configuration file. Other ways to provide it are with the ODOO_RC or OPENERP_SERVER environment variables, or ~/.odoorc (Odoo >= 10) or ~/.openerp_serverrc. --addons-path TEXT Specify the addons path. If present, this parameter takes precedence over the addons path provided in the Odoo configuration file. -d, --database TEXT Specify the database name. If present, this parameter takes precedence over the database provided in the Odoo configuration file. --log-level TEXT Specify the logging level. Accepted values depend on the Odoo version, and include debug, info, warn, error. [default: info] --logfile FILE Specify the log file. --rollback Rollback the transaction even if the script does not raise an exception. Note that if the script itself commits, this option has no effect. This is why it is not named dry run. This option is implied when an interactive console is started. -i, --interactive / --no-interactive Inspect interactively after running the script. --shell-interface TEXT Preferred shell interface for interactive mode. Accepted values are ipython, ptpython, bpython, python. If not provided they are tried in this order. --help Show this message and exit.
Most options above are the same as odoo
options and behave identically.
Additional Odoo options can be set in the the configuration file.
Note however that most server-related options (workers, http interface etc)
are ignored because no server is actually started when running a script.
An important feature of click-odoo
compared to, say, odoo shell
is
the capability to pass arguments to scripts.
In order to avoid confusion between click-odoo
options and your script
options and arguments, it is recommended to separate them with --
:
click-odoo -d dbname -- list-users.py -d a b ./list-users.py -d dbname -- -d a b
In both examples above, sys.argv[1:]
will contain ['-d', 'a', 'b']
in the script.
@click_odoo.env_options()
is a decorator that is used very much like
@click.option()
and inserts the list of predefined click-odoo
options. Instead of passing down these options to the command, it prepares
an odoo Environment
and passes it as a env
parameter.
It is configurable with the following keyword arguments:
- default_log_level
- The default value for the
--log-level
option (default: 'info'). - with_rollback
- Controls the presence of the
--rollback
option (default: True). This is useful for creating commands that commit and leave no possibility for rollback. - with_database
- Controls the presence of the
--database
option (default: True). This is useful to create scripts that have access to a pre-loaded Odoo configuration, without any database. In such case, the environment is not set (env is None). Ifwith_database
is False,database_required
is implied to be False too. - database_required
- Controls if a database must be provided through the
--database
option or the Odoo configuration file (default: True). - database_must_exist
- If this flag is False and the selected database does not exist do not fail and pass env=None instead (default: True).
- with_addons_path
- Controls the presence of the
--addons-path
option (default: False). - environment_manager
experimental feature A context manager that yields an intialized
odoo.api.Environment
. It is invoked after Odoo configuration parsing and initialization. It must have the following signature (identical toOdooEnvironment
below, plus the clickctx
as well as**kwargs
for future proofing):environment_manager(database, rollback, ctx, **kwargs)
click_odoo.env_options
is a class that can be extended for customization
purposes.
It currently has one method that is intended to be overridden, with the following signature:
def get_odoo_args(self, ctx: click.Context) -> List[str]:
...
It must return a list of Odoo command line arguments computed from the Click context. It will be called after parsing all parameters of the command, and before initializing Odoo and invoking the command function.
As a convenience click_odoo
exports the odoo
namespace, so
from click_odoo import odoo
is an alias for import odoo
.
This package also provides an experimental OdooEnvironment
context manager.
It is meant to be used in after properly intializing Odoo (ie parsing the
configuration file etc).
Warning
This API is considered experimental, contrarily to the scripting mechanism
(ie passing env
to scripts) and env_options
decorator which are
stable features. Should you have a specific usage for this API and would
like it to become stable, get it touch to discuss your requirements.
Example:
from click_odoo import OdooEnvironment
with OdooEnvironment(database='dbname') as env:
env['res.users'].search([])
To run tests, type tox
. Tests are made using pytest. To run tests matching
a specific keyword for, say, Odoo 12 and python 3.6, use
tox -e py36-12.0 -- -k keyword
.
This project uses black
as code formatting convention, as well as isort and flake8.
To make sure local coding convention are respected before
you commit, install
pre-commit and
run pre-commit install
after cloning the repository.
- pypi page: https://pypi.org/project/click-odoo
- code repository: https://github.com/acsone/click-odoo
- report issues at: https://github.com/acsone/click-odoo/issues
Author:
- Stéphane Bidoul (ACSONE)
Contributors:
Inspiration has been drawn from:
- anybox.recipe.odoo
- anthem by Camptocamp
- odoo's own shell command
This project is maintained by ACSONE SA/NV.