Odoo Shell
Basics
List all fields
record = env['res.config.settings'].browse(1)
for field in record.fields_get():
print(field)
List all products
for product in env['product.template'].search([]):
print(product.name)
Execute sql quer.
self._cr.execute("SELECT * FROM account_move WHERE id = 16")
Generate password.
from passlib.context import CryptContext
setpw = CryptContext(schemes=['pbkdf2_sha512'])
setpw.encrypt('odoo')
Commands
Log into Docker Container.
CONTAINER=odoo04
docker exec -it $CONTAINER bin/bash
Start Odoo Shell.
DATABASE=odoo14
odoo shell -d $DATABASE --db_host $HOST -r $USER -w $PASSWORD --no-http
Clear assets.
domain = [('res_model', '=', 'ir.ui.view'), ('name', 'like', 'assets_')]
env['ir.attachment'].search(domain).unlink()
env.cr.commit()
Uninstall app.
env['ir.module.module'].search([('name', '=', 'certificate_planer')]).button_immediate_uninstall()
List all users.
users=self.env['res.users'].search([])
[print(user.name, user.login) for user in users]
List all inactive users.
users=self.env['res.users'].search([('active', '=', False)])
for user in users:
print(user.name, user.login, user.active)
Enable user.
user = self.env['res.users'].search([('active', '=', False),('login', '=', 'janik.vonrotz@mint-system.ch')])
user.active = True
self.env.cr.commit()
Reset passwort for user.
user = self.env['res.users'].search([('login', '=', 'admin')], limit=1)
user.write({'new_password': 'admin'})
self.env.cr.commit()
Disable mail server
record = env['res.config.settings'].browse(1)
print(record.external_email_server_default)
record.external_email_server_default = False
env.cr.commit()
List all quality alerts.
alerts=self.env['quality.alert'].search([])
for alert in alerts:
print(alert.id, alert.name, alert.title)
Set name of alert.
record = env['quality.alert'].browse(57)
record.name = "QA0005X"
env.cr.commit()
Remove view.
self.env['ir.ui.view'].browse(888).unlink()
env.cr.commit()
Get sale order info.
sale_order = self.env['sale.order'].browse(60)
sale_order.procurement_group_id.stock_move_ids.created_production_id.procurement_group_id.mrp_production_ids
List all defaults
defaults = self.env['ir.default'].search([('invoice_cash_rounding_id')], limit=1)
[print(default.json_value, default.field_id.name) for default in defaults]