Skip to main content

click-odoo scripts collection

Project description

License: LGPL-3

click-odoo-contrib is a set of useful Odoo maintenance functions. They are available as CLI scripts (based on click-odoo), as well as composable python functions.


click-odoo-copydb (beta)

Usage: click-odoo-copydb [OPTIONS] SOURCE DEST

  Create an Odoo database by copying an existing one.

  This script copies using postgres CREATEDB WITH TEMPLATE. It also copies
  the filestore.

  -c, --config FILE       ...
  -f, --force-disconnect  Attempt to disconnect users from the template
  --unless-dest-exists    Don't report error if destination database already
  --if-source-exists      Don't report error if source database does not
  --filestore-copy-mode   [default|rsync|hardlink]
                          Mode for copying the filestore. Default uses
                          python shutil copytree which copies
                          everything. If the target filestore already
                          exists and just needs an update you can use
                          rsync to rsync the filestore instead. If both
                          filestores are on the same filesystem supporting
                          hardlinks you can use the option hardlink to hard
                          link the files to the inodes of the files of the
                          source directory which saves on space on the disk.
  --help                  Show this message and exit.

click-odoo-dropdb (stable)

Usage: click-odoo-dropdb [OPTIONS] DBNAME

  Drop an Odoo database and associated file store.

  -c, --config FILE  ...
  --if-exists        Don't report error if database doesn't exist.
  --help             Show this message and exit.

click-odoo-initdb (stable)

Usage: click-odoo-initdb [OPTIONS]

  Create an Odoo database with pre-installed modules.

  Almost like standard Odoo does with the -i option, except this script
  manages a cache of database templates with the exact same addons
  installed. This is particularly useful to save time when initializing test

  Cached templates are identified by computing a sha1 checksum of modules
  provided with the -m option, including their dependencies and
  corresponding auto_install modules.

  -c, --config FILE         ...
  -n, --new-database TEXT   Name of new database to create, possibly from
                            cache. If absent, only the cache trimming
                            operation is executed.
  -m, --modules TEXT        Comma separated list of addons to install.
                            [default: base]
  --demo / --no-demo        Load Odoo demo data.  [default: True]
  --cache / --no-cache      Use a cache of database templates with the exact
                            same addons installed. Disabling this option also
                            disables all other cache-related operations such
                            as max-age or size. Note: when the cache is
                            enabled, all attachments created during database
                            initialization are stored in database instead of
                            the default Odoo file store.  [default: True]
  --cache-prefix TEXT       Prefix to use when naming cache template databases
                            (max 8 characters). CAUTION: all databases named
                            like {prefix}-____________-% will eventually be
                            dropped by the cache control mechanism, so choose
                            the prefix wisely.  [default: cache]
  --cache-max-age INTEGER   Drop cache templates that have not been used for
                            more than N days. Use -1 to disable.  [default:
  --cache-max-size INTEGER  Keep N most recently used cache templates. Use -1
                            to disable. Use 0 to empty cache.  [default: 5]
  --unless-exists           Don't report error if database already exists.
  --help                    Show this message and exit.

click-odoo-backupdb (beta)

Usage: click-odoo-backupdb [OPTIONS] DBNAME DEST

  Create an Odoo database backup.

  This script dumps the database using pg_dump. It also copies the filestore.

  Unlike Odoo, this script allows you to make a backup of a database without
  going through the web interface. This avoids timeout and file size
  limitation problems when databases are too large.

  It also allows you to make a backup directly to a directory. This type of
  backup has the advantage that it reduces memory consumption since the
  files in the filestore are directly copied to the target directory as well
  as the database dump.

  -c, --config FILE           ...
  --force                       Don't report error if destination file/folder
                                already exists.  [default: False]

  --if-exists                   Don't report error if database does not exist.
  --format [zip|dump|folder]    Output format  [default: zip]
  --filestore / --no-filestore  Include filestore in backup  [default: True]
  --help                        Show this message and exit.

click-odoo-restoredb (beta)

Usage: click-odoo-restoredb [OPTIONS] DBNAME SOURCE

  Restore an Odoo database backup.

  This script allows you to restore databses created by using the Odoo web
  interface or the backupdb script. This avoids timeout and file size
  limitation problems when databases are too large.

  -c, --config FILE  ...
  --copy / --move    This database is a copy. In order to avoid conflicts
                     between databases, Odoo needs to know if thisdatabase was
                     moved or copied. If you don't know, set is a copy.

  --force            Don't report error if destination database already
                     exists. If force and destination database exists, it will
                     be dropped before restore.  [default: False]

  --jobs INTEGER     Uses this many parallel jobs to restore. Only used to
                     restore folder format backup.

  --help             Show this message and exit.

click-odoo-makepot (stable)

Usage: click-odoo-makepot [OPTIONS]

  Export translation (.pot) files of addons installed in the database and
  present in addons_dir. Additionally, run msgmerge on the existing .po
  files to keep them up to date. Commit changes to git, if any.

  -c, --config FILE           ...
  -d, --database TEXT         ...
  --addons-dir TEXT           [default: .]
  -m, --modules TEXT          Comma separated list of addons to export
  --msgmerge / --no-msgmerge  Merge .pot changes into all .po files
                              [default: False]
  --msgmerge-if-new-pot / --no-msg-merge-if-new-pot
                              Merge .pot changes into all .po files, only
                              if a new .pot file has been created.
                              [default: False]
  --fuzzy-matching /  --no-fuzzy-matching
                              Use fuzzy matching when merging .pot changes
                              into .po files.
                              Only applies when --msgmerge
                              or --msgmerge-if-new-pot are passed.
                              [default: True]
  --purge-old-translations /  --no-purge-old-translations
                              Remove comment lines containing old
                              translations from .po files.
                              Only applies when --msgmerge
                              or --msgmerge-if-new-pot are passed.
                              [default: False]
  --commit / --no-commit      Git commit exported .pot files if needed.
                              [default: False]
  --help                      Show this message and exit.

click-odoo-uninstall (stable)

Usage: click-odoo-uninstall [OPTIONS]

  -c, --config PATH    ...
  -d, --database TEXT  ...
  -m, --modules TEXT   Comma-separated list of modules to uninstall
  --help               Show this message and exit.

click-odoo-update (stable)

Usage: click-odoo-update [OPTIONS]

  Update an Odoo database (odoo -u), automatically detecting addons to
  update based on a hash of their file content, compared to the hashes
  stored in the database.

  It allows updating in parallel while another Odoo instance is still
  running against the same database, by using a watcher that aborts the
  update in case a DB lock happens.

  -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.
  --i18n-overwrite             Overwrite existing translations
  --update-all                 Force a complete upgrade (-u base)
  --ignore-addons TEXT         A comma-separated list of addons to ignore.
                               These will not be updated if their checksum has
                               changed. Use with care.
  --ignore-core-addons         If this option is set, Odoo CE and EE addons
                               are not updated. This is normally safe, due the
                               Odoo stable policy.
  --if-exists                  Don't report error if database doesn't exist
  --watcher-max-seconds FLOAT  Max DB lock seconds allowed before aborting the
                               update process. Default: 0 (disabled).
  --list-only                  Log the list of addons to update without
                               actually updating them.
  --help                       Show this message and exit.


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. For running tests you need a postgres server accessible for your user without a password at /var/run/postgresql/.s.PGSQL.5432.

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.





This project is maintained by ACSONE SA/NV.


1.15.1 (2021-12-04)


  • Silence Odoo 15 noisy warnings about using autocommit. (#105)

1.15.0 (2021-10-06)


  • Update core addons lists, with Odoo 15 support. (#104)

1.14.0 (2021-06-28)


  • Adding a new option to enable using rsync and hardlinks for copying filestore: –filestore-copy-mode [default|rsync|hardlink]. (#86)

1.13.0 (2021-06-25)


  • Backup and restore commands: add support for “dump” format (#79)
  • click-odoo-makepot: add –modules option to select modules to export. (#92)
  • click-odoo-update: also pass all modified modules in to upgrade state to Odoo for update; this helps upgrading when there are new dependencies, in combination with Odoo #72661. (#97)


  • click-odoo-update: do not attempt to update addons that are uninstallable. (#89)

1.12.0 (2020-11-25)


  • click-odoo-makepot gained new options controlling how it merges new strings in existing .po files: --no-fuzzy-matching and --purge-old-translation. (#87)

1.11.0 (2020-10-01)


  • In click-odoo-copydb, reset database.* system parameters, to prevent conflicts between databases (database.uuid, database.secret, database.enterprise_code, …) (#25)
  • Add click-odoo-restoredb command. (#32)
  • Update core addons lists (for click-odoo-update –ignore-core-addons), including Odoo 14 support. (#81)

1.10.1 (2020-04-29)


  • click-odoo-update: fix packaging issue (missing core addons lists). (#77)

1.10.0 (2020-04-28)


  • click-odoo-initdb: add support of dot and underscore in database name. (#35)
  • click-odoo-update: added –list-only option. (#68)
  • click-odoo-update: add –ignore-addons and –ignore-core-addons options to exclude addons from checksum change detection. (#69)

Improved Documentation

  • initdb, dropdb, update: move out of beta. (#70)

Deprecations and Removals

  • Remove deprecated click-odoo-upgrade. (#71)

1.9.0 (2020-03-23)

  • click-odoo-update: acquire an advisory lock on the database so multiple instances of click-odoo-update will not start at the same time on the same database (useful when there are several Odoo instances running on the same database and all running click-odoo-update at startup)

1.8.0 (2019-10-01)

  • Support Odoo SaaS versions
  • click-odoo-update now has some support for updating while another Odoo instance is running against the same database, by using a watcher that aborts the update in case a DB lock happens (this is an advanced feature)

1.7.0 (2019-09-02)

  • makepot: always check validity of .po files

1.6.0 (2019-03-28)

  • update: support postgres 9.4
  • backupdb: work correctly when list_db is false too
  • backupdb: new –(no-)filestore option
  • dropdb: refactored to use Odoo api instead of custom code

1.5.0 (2019-02-05)

  • add click-odoo-backupdb

1.4.1 (2018-11-21)

  • fix broken click-odoo-update –i18n-overwrite

1.4.0 (2018-11-19)

  • new click-odoo-update which implements the functionality of module_auto_update natively, alleviating the need to have module_auto_update installed in the database, and is more robust (it does a regular -u after identifying modules to update)
  • upgrade: deprecated in favor of click-odoo-update
  • initdb: save installed checksums so click-odoo-update can readily use them
  • initdb: add –addons-path option
  • copydb: fix error when source filestore did not exist

1.3.1 (2018-11-05)

  • Add –unless-exists option to click-odoo-initdb

1.3.0 (2018-10-31)

  • Add click-odoo-copydb
  • Add click-odoo-dropdb
  • Add –if-exists option to click-odoo-upgrade

1.2.0 (2018-10-07)

  • Odoo 12 support

1.1.4 (2018-06-21)

  • makepot: fix issue when addons-dir is not current directory (this should also fix issues when there are symlinks)

1.1.3 (2018-06-20)

  • makepot: add –commit-message option

1.1.2 (2018-06-20)

1.1.1 (2018-06-16)

  • makepot: add –msgmerge-if-new-pot option

1.1.0 (2018-06-13, Sevilla OCA code sprint)

  • add click-odoo-makepot
  • in click-odoo-initdb, include active=True modules in hash computation (because modules with active=True are auto installed by Odoo)

1.0.4 (2018-06-02)

  • update module list after creating a database from cache, useful when we are creating a database in an environment where modules have been added since the template was created

1.0.3 (2018-05-30)

  • fix: handle situations where two initdb start at the same time ending up with an “already exists” error when creating the cached template

1.0.2 (2018-05-29)

  • fix: initdb now stores attachments in database when cache is enabled, so databases created from cache do not miss the filestore

1.0.1 (2018-05-27)

  • better documentation
  • fix: initdb now takes auto_install modules into account

1.0.0 (2018-05-27)

  • add click-odoo-initdb

1.0.0b3 (2018-05-17)

  • be more robust in rare case button_upgrade fails silently

1.0.0b2 (2018-03-28)

  • uninstall: commit and hide –rollback
  • upgrade: refactor to add composable function

1.0.0b1 (2018-03-28)

  • upgrade: save installed checksums after full upgrade

1.0.0a1 (2018-03-22)

  • first alpha
  • click-odoo-uninstall
  • click-odoo-upgrade

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

click-odoo-contrib-1.15.1.tar.gz (62.4 kB view hashes)

Uploaded source

Built Distribution

click_odoo_contrib-1.15.1-py2.py3-none-any.whl (57.1 kB view hashes)

Uploaded py2 py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page