Odoo Scripts

Most commands can be run directly or with the image build from Dockerfile (xcgd/odoo_scripts) by indicating the command to run, but the best way to use this module is to install it. Installing will also install dependencies.

Shell Scripts

Those scripts are not installed when installing this python module.

start

This script can be used to start odoo.

It need to be run on a machine with all the odoo requirements installed, either system-wide or in a virtual environment (which need to be activated).

Its arguments are forwarded to the Odoo executable (odoo-bin / openerp-server).

It expect the configuration file (setup.cfg) to have the following keys:

• odoo_type: type of odoo (odoo7, odoo8, odoo10, odoo11 or odoo13) [default to odoo8]. The environment variable ODOO_TYPE can be used instead.
• modules: list of directories and files to include (also used by another script)

The environment variable ODOO_ADDONS_PATH can be used to set the path for the addons, it can be empty if there is no path to include.

do_tests

This script create a database, install modules and run the tests on those modules and print the result.

It need to be run on a machine with all the odoo requirements installed, either system-wide or in a virtual environment (which need to be activated). A postgresql server is also needed.

It takes three optional arguments (those are positional arguments):

• the host of the postgresql server,
• the user for this base (which need database creation rights). If a user is provided, you will need to have a .pgpass with the password if it is not the one in conf/dev/odoo.conf.
• the name of the database to use

Those environment variables are used:

ODOO_NO_DROP

set to reuse an existing database.

The script call run_tests.

It expect the configuration file (setup.cfg) to have the following keys:

• module_list: list (separated by white space) of odoo modules to install on the database (default to empty list)
• unaccent: boolean to indicate if unaccent is to be installed on the database (default to True)

run_tests

This script run the tests on a database.

It need to be run on a machine with all the odoo requirements installed, either system-wide or in a virtual environment (which need to be activated). A postgresql server is also needed.

The name of the database is the same as do_tests or can be provided.

The script call start.

It expect the configuration file (setup.cfg) to have the following keys:

• module_list_tests: list (separated by white space) of odoo modules to run tests for on the database (default to empty list)
• odoo_type: type of odoo (bzr, odoo7, odoo8 or odoo10) [default to odoo8]

create_archive

zsh script to create a tar.xz file containing all sources.

isort

Run dockerized isort on current directory. This uses a configuration file that is adapted to OCA guidelines for imports.

For help:

./isort --help

Scripts

Those scripts are available when installing the package, and can also be run directly.

The recommend way to install this module is to run pip3 install ., eventually with the editable option. Some scripts are in other sections, because they need some specialized library, in that case you need to indicate the name of section as in pip3 install ".[docker]". The prerequisites for this module or one of its section can be installed by using pip3 or the package manager; the requirements are defined in setup.py. As there is no way of indicating sections (it is even handling them incorrectly), do not use python3 setup.py install.

conf2reST.py

This script is used to produce a reST file from setup.cfg, the Dockerfile and the .hgconf/nest.yaml file.

When the package is installed, the executable for this script is conf2reST. This is part of the conf2reST section.

update_duplicate_sources.py

This script will update a metaproject that only contain the sources of the one it is launched from.

It expect the configuration file (setup.cfg) to have the following keys:

• modules: list of directories and files to include (also used by another script)
• dependencies: list of directories and files to include (also used by another script)
• other_sources: list of directories and files to include (only used by this script, used for README, ReleaseNotes, script directories, etc.)

No change are made to the name of the directories/files included.

When the package is installed, the executable for this script is update_duplicate_sources. This is part of the source_control section.

docker_dev_start.py

This script can be used to start an odoo from a docker but with the local addons modules mounted, and eventually a local copy of the odoo sources mounted too.

Using it avoids having to create a virtual env for every project.

Your user also needs to be in the docker group.

It expects the configuration file (setup.cfg) to have the following keys:

• modules: list of directories and files to include
• …

When the package is installed, the executable for this script is docker_dev_start. This is part of the docker section.

docker_build.py

This script builds a docker image of the project.

It uses the super project’s setup.cfg and Dockerfile.

When the package is installed, the executable for this script is docker_build. This is part of the docker section.

do_tests.py

This scripts launches the tests, but with more options than do_tests. It uses docker by default, similar to docker_dev_start.py.

When the package is installed, the executable for this script is do_tests.

import_base_import and import_jsonrpc

Import CSV files into an odoo.

import_base_import uses odoo base_import module to import the CSV file.

import_jsonrpc uses jsonrpc calls to import the files. The format is the same as the one used with the import module, with a couple more restrictions:

• selection fields must use the technical value, not the displayed value or one of its translation.
• many2one and many2many fields must use the xmlid of the field they are referencing, with the column name in the form field_name/id or field_name:id.
• one2many fields in the same file are not supported for now.
• date and datetime must be in ISO format.
• context does not include base.import usual import key, so they need to be added as argument or in the configuration file.

import_jsonrpc tries to find an import.yaml file alongside any imported file. It will use the delimiter indicated in the file if it finds one and will add the context key to the context used in the jsonrpc calls.

import_sql

Import CSV files into an Odoo database. The import is done directly as SQL insert and update commands.

The format is the similar to the one used with the import module, with many more restrictions:

• selection fields must use the technical value, not the displayed value or one of its translation.
• many2one and many2many fields can not be used.
• one2many fields in the same file are not supported.
• date and datetime must be in ISO format.

When inserting, the create_uid/write_uid are not set. create_date and write_date is updated as needed, and so is the date_update in ir.model.data. This is part of the import_sql section.

setup.cfg

The scripts expects configuration in the odoo_scripts section of setup.cfg. This file is in the super project, not the one in odoo_scripts.

Configuration keys:

modules

list of modules to install (relative to project directory), those modules are the ones copied in the Dockerfile

odoo_type

type of odoo (odoo7, odoo8, odoo10, odoo11, odoo13)

pg.extensions

postgresql extensions to install (unaccent is added automatically depending on odoo configuration)

load-language

languages to install into a newly created database

Completion files for zsh

Your .zshrc should contain a line like this:

fpath=(~/.local/share/zsh/completion $fpath)

Create completion directory:

mkdir -p ~/.local/share/zsh/completion

Clone:

cd
mkdir -p src
cd src
git clone git@github.com:RobSis/zsh-completion-generator.git

Generate completion file for python scripts (from the superproject for the scripts that need to be run from there, and with the required requirements too):

for command_name in docker_dev_start docker_build docker_build_copy docker_build_clean do_tests conf2reST import_base_import import_jsonrpc import_sql ; do
  $command_name --help | ~/src/zsh-completion-generator/help2comp.py $command_name > ~/.local/share/zsh/completion/_$command_name
done

Alternatives: genzshcomp