浏览odoo/openerp data的通用工具
ERPpeek的Python项目详细描述
下载并安装最新版本:
pip install -U erppeek
文档和教程:http://erppeek.readthedocs.org
ci测试:https://travis-ci.org/tinyerp/erppeek
Overview
erppeek有三个完整的用途:
- 使用命令行参数
- 作为交互式外壳
- 作为客户库
主要功能:
- 单个可执行文件erppeek.py,无外部依赖关系
- 用于search+read、数据模型内省等的包装器。
- domain和fields 的更简单语法
- openerp 5.0到odoo 11.0的Client对象上可访问的完整api
- 模块可以导入并用作库:from erppeek import Client
- 支持Python3和Python2.7
Command line arguments
从命令行查询odoo模型的参数很少。 虽然它非常有限:
$ erppeek --help Usage: erppeek [options] [search_term_or_id [search_term_or_id ...]] Inspect data on Odoo objects. Use interactively or query a model (-m) and pass search terms or ids as positional parameters after the options. Options: --version show program's version number and exit -h, --help show this help message and exit -l, --list list sections of the configuration --env=ENV read connection settings from the given section -c CONFIG, --config=CONFIG specify alternate config file (default: 'erppeek.ini') --server=SERVER full URL of the server (default: http://localhost:8069/xmlrpc) -d DB, --db=DB database -u USER, --user=USER username -p PASSWORD, --password=PASSWORD password, or it will be requested on login -m MODEL, --model=MODEL the type of object to find -f FIELDS, --fields=FIELDS restrict the output to certain fields (multiple allowed) -i, --interact use interactively; default when no model is queried -v, --verbose verbose $ #
示例:
$ erppeek -d demo -m res.partner -f name -f lang 1 "name","lang" "Your Company","en_US"
$ erppeek -d demo -m res.groups -f full_name 'id > 0' "full_name" "Administration / Access Rights" "Administration / Configuration" "Human Resources / Employee" "Usability / Multi Companies" "Usability / Extended View" "Usability / Technical Features" "Sales Management / User" "Sales Management / Manager" "Partner Manager"
Interactive use
编辑erppeek.ini并声明环境:
[DEFAULT] scheme = http host = localhost port = 8069 database = odoo username = admin [demo] username = demo password = demo protocol = xmlrpc [demo_jsonrpc] username = demo password = demo protocol = jsonrpc [local] scheme = local options = -c /path/to/odoo-server.conf --without-demo all
连接到ODOO服务器:
erppeek --list erppeek --env demo
这是一个示例会话:
>>> model('res.users') <Model 'res.users'> >>> model('res.users').count() 4 >>> model('ir.cron').read(['active = False'], 'active function') [{'active': False, 'function': 'run_mail_scheduler', 'id': 1}, {'active': False, 'function': 'run_bdr_scheduler', 'id': 2}, {'active': False, 'function': 'scheduled_fetch_new_scans', 'id': 9}] >>> # >>> client.modules('delivery') {'uninstalled': ['delivery', 'sale_delivery_report']} >>> client.upgrade('base') 1 module(s) selected 42 module(s) to process: to upgrade account to upgrade account_chart to upgrade account_tax_include to upgrade base ... >>> #
注意
使用--verbose开关查看场景背后发生了什么。 行被截短为79个字符。使用-vv或-vvv打印 更多。
注意
要在关闭会话时保留命令的历史记录,请首先 在主目录中创建空文件: touch ~/.erppeek_history