odoo-orm-expert

# Odoo ORM Expert ## Overview This skill teaches you Odoo's Object Relational Mapper (ORM) in depth. It covers reading/writing records, building domain filters, working with relational fields, and avoiding common performance pitfalls like N+1 queries. ## When to Use This Skill - Writing `search()`, `browse()`, `create()`, `write()`, or `unlink()` calls. - Building complex domain filters for views or server actions. - Implementing computed, stored, and related fields. - Debugging slow queries or optimizing bulk operations. ## How It Works 1. **Activate**: Mention `@odoo-orm-expert` and describe what data operation you need. 2. **Get Code**: Receive correct, idiomatic Odoo ORM code with explanations. 3. **Optimize**: Ask for performance review on existing ORM code. ## Examples ### Example 1: Search with Domain Filters ```python # Find all confirmed sale orders for a specific customer, created this year import datetime start_of_year = datetime.date.today().replace(month=1, day=1).strftime('%Y-%m-%d') orders = self.env['sale.order'].search([ ('partner_id', '=', partner_id), ('state', '=', 'sale'), ('date_order', '>=', start_of_year), ], order='date_order desc', limit=50) # Note: pass dates as 'YYYY-MM-DD' strings in domains, # NOT as fields.Date objects — the ORM serializes them correctly. ``` ### Example 2: Computed Field ```python total_order_count = fields.Integer( string='Total Orders', compute='_compute_total_order_count', store=True ) ...