Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Odoo 14 Development Cookbook
  • Table Of Contents Toc
  • Feedback & Rating feedback
Odoo 14 Development Cookbook

Odoo 14 Development Cookbook - Fourth Edition

By : Gajjar, Fayolle, Holger Brunn, Daniel Reis
4 (5)
Buy this Book
close
close
Odoo 14 Development Cookbook

Odoo 14 Development Cookbook

4 (5)
By: Gajjar, Fayolle, Holger Brunn, Daniel Reis
Buy this Book

Overview of this book

With its latest iteration, the powerful Odoo framework released a wide variety of features for rapid application development. This updated Odoo development cookbook will help you explore the new features in Odoo 14 and learn how to use them to develop Odoo applications from scratch. You'll learn about the new website concepts in Odoo 14 and get a glimpse of Odoo's new web-client framework, the Odoo Web Library (OWL). Once you've completed the installation, you'll begin to explore the Odoo framework with real-world examples. You'll then create a new Odoo module from the ground up and progress to advanced framework concepts. You'll also learn how to modify existing applications, including Point of Sale (POS) applications. This book isn't just limited to backend development; you'll discover advanced JavaScript recipes for creating new views and widgets. As you progress, you'll learn about website development and become a quality Odoo developer by studying performance optimization, debugging, and automated testing. Finally, you'll delve into advanced concepts such as multi-website, In-App Purchasing (IAP), Odoo.sh, the IoT Box, and security. By the end of the book, you'll have all the knowledge you need to build impressive Odoo applications and you'll be well versed in development best practices that will come in handy when working with the Odoo framework.
Table of Contents (26 chapters)
close
close
close
Preface
Icon
Preface
Icon
Who this book is for
Icon
What this book covers
Icon
To get the most out of this book
Icon
Download the example code files
Icon
Download the color images
Icon
Conventions used
Icon
Get in touch
Icon
Reviews
1
Chapter 1: Installing the Odoo Development Environment
Icon
Chapter 1: Installing the Odoo Development Environment
Icon
Understanding the Odoo ecosystem
Icon
Easy installation of Odoo from source
Icon
Managing Odoo server databases
Icon
Storing the instance configuration in a file
Icon
Activating Odoo developer tools
Icon
Updating the add-on modules list
Lock Free Chapter
2
Chapter 2: Managing Odoo Server Instances
Icon
Chapter 2: Managing Odoo Server Instances
Icon
Configuring the add-ons path
Icon
Standardizing your instance directory layout
Icon
How to do it…
Icon
How it works…
Icon
Installing and upgrading local add-on modules
Icon
Installing add-on modules from GitHub
Icon
Applying changes to add-ons
Icon
Applying and trying proposed pull requests
3
Chapter 3: Creating Odoo Add-On Modules
Icon
Chapter 3: Creating Odoo Add-On Modules
Icon
Technical requirements
Icon
What is an Odoo add-on module?
Icon
Creating and installing a new add-on module
Icon
How to do it...
Icon
Completing the add-on module manifest
Icon
Organizing the add-on module file structure
Icon
Adding models
Icon
Adding menu items and views
Icon
Adding access security
Icon
Using the scaffold command to create a module
4
Chapter 4: Application Models
Icon
Chapter 4: Application Models
Icon
Technical requirements
Icon
Defining the model representation and order
Icon
Adding data fields to a model
Icon
Using a float field with configurable precision
Icon
Adding a monetary field to a model
Icon
Adding relational fields to a model
Icon
Adding a hierarchy to a model
Icon
Adding constraint validations to a model
Icon
Adding computed fields to a model
Icon
Exposing related fields stored in other models
Icon
Adding dynamic relations using reference fields
Icon
Adding features to a model using inheritance
Icon
Copy model definition using inheritance
Icon
Using delegation inheritance to copy features to another model
Icon
Using abstract models for reusable model features
5
Chapter 5: Basic Server-Side Development
Icon
Chapter 5: Basic Server-Side Development
Icon
Technical requirements
Icon
Defining model methods and using API decorators
Icon
Getting ready
Icon
Reporting errors to the user
Icon
Obtaining an empty recordset for a different model
Icon
Creating new records
Icon
Updating values of recordset records
Icon
Searching for records
Icon
Combining recordsets
Icon
Filtering recordsets
Icon
Traversing recordset relations
Icon
Sorting recordsets
Icon
Extending the business logic defined in a model
Icon
Extending write() and create()
Icon
Customizing how records are searched
Icon
Fetching data in groups using read_group()
6
Chapter 6: Managing Module Data
Icon
Chapter 6: Managing Module Data
Icon
Technical requirements
Icon
Using external IDs and namespaces
Icon
Loading data using XML files
Icon
Using the noupdate and forcecreate flags
Icon
Loading data using CSV files
Icon
Add-on updates and data migration
Icon
Deleting records from XML files
Icon
Invoking functions from XML files
7
Chapter 7: Debugging Modules
Icon
Chapter 7: Debugging Modules
Icon
The auto-reload and --dev options
Icon
Producing server logs to help debug methods
Icon
Using the Odoo shell to interactively call methods
Icon
Using the Python debugger to trace method execution
Icon
Understanding the debug mode options
8
Chapter 8: Advanced Server-Side Development Techniques
chevron up
Icon
Chapter 8: Advanced Server-Side Development Techniques
Icon
Technical requirements
Icon
Changing the user that performs an action
Icon
Calling a method with a modified context
Icon
Executing raw SQL queries
Icon
Writing a wizard to guide the user
Icon
See also
Icon
Defining onchange methods
Icon
Calling onchange methods on the server side
Icon
Defining onchange with the compute method
Icon
See also
Icon
Defining a model based on a SQL view
Icon
See also
Icon
Adding custom settings options
Icon
Implementing init hooks
9
Chapter 9: Backend Views
Icon
Chapter 9: Backend Views
Icon
Technical requirements
Icon
Adding a menu item and window actions
Icon
Having an action open a specific view
Icon
Adding content and widgets to a form view
Icon
Adding buttons to forms
Icon
Passing parameters to forms and actions – context
Icon
Defining filters on record lists – domain
Icon
Defining list views
Icon
Defining search views
Icon
Adding a search filter side panel
Icon
Changing existing views – view inheritance
Icon
Defining document-style forms
Icon
See also
Icon
Dynamic form elements using attrs
Icon
Defining embedded views
Icon
Displaying attachments on the side of the form view
Icon
Defining kanban views
Icon
See also
Icon
Showing kanban cards in columns according to their state
Icon
Defining calendar views
Icon
Defining graph view and pivot view
Icon
Defining the cohort view
Icon
Defining the dashboard view
Icon
Defining the gantt view
Icon
Defining the activity view
Icon
Defining the map view
10
Chapter 10: Security Access
Icon
Chapter 10: Security Access
Icon
Technical requirements
Icon
Creating security groups and assigning them to users
Icon
Adding security access to models
Icon
Limiting access to fields in models
Icon
Limiting record access using record rules
Icon
Using security groups to activate features
Icon
Accessing recordsets as a superuser
Icon
Hiding view elements and menus based on groups
11
Chapter 11: Internationalization
Icon
Chapter 11: Internationalization
Icon
Installing a language and configuring user preferences
Icon
Configuring language-related settings
Icon
Translating texts through the web client user interface
Icon
Exporting translation strings to a file
Icon
Using gettext tools to make translations easier
Icon
Importing translation files into Odoo
Icon
Changing the custom language URL code for a website
12
Chapter 12: Automation, Workflows, Emails, and Printing
Icon
Chapter 12: Automation, Workflows, Emails, and Printing
Icon
Technical requirements
Icon
Managing dynamic record stages
Icon
Managing kanban stages
Icon
Adding a quick create form to a kanban card
Icon
Creating interactive kanban cards
Icon
Adding a progress bar in kanban views
Icon
Creating server actions
Icon
Using Python code server actions
Icon
Using automated actions on time conditions
Icon
Using automated actions on event conditions
Icon
Creating QWeb-based PDF reports
Icon
Managing activities from a kanban card
Icon
Adding a stat button to a form view
Icon
Enabling the archive option for records
13
Chapter 13: Web Server Development
Icon
Chapter 13: Web Server Development
Icon
Technical requirements
Icon
Making a path accessible from the network
Icon
Restricting access to web-accessible paths
Icon
Consuming parameters passed to your handlers
Icon
Modifying an existing handler
Icon
Serving static resources
14
Chapter 14: CMS Website Development
Icon
Chapter 14: CMS Website Development
Icon
Managing static assets
Icon
Adding CSS and JavaScript for a website
Icon
Creating or modifying templates – QWeb
Icon
Managing dynamic routes
Icon
Offering static snippets to the user
Icon
Offering dynamic snippets to the user
Icon
Getting input from website users
Icon
Managing SEO options
Icon
Managing sitemaps for the website
Icon
Getting a visitor's country information
Icon
Tracking a marketing campaign
Icon
Managing multiple websites
Icon
Redirecting old URLs
Icon
Publish management for website-related records
15
Chapter 15: Web Client Development
Icon
Chapter 15: Web Client Development
Icon
Technical requirements
Icon
Creating custom widgets
Icon
Using client-side QWeb templates
Icon
Making RPC calls to the server
Icon
Creating a new view
Icon
Debugging your client-side code
Icon
Improving onboarding with tours
Icon
Mobile app JavaScript
16
Chapter 16: The Odoo Web Library (OWL)
Icon
Chapter 16: The Odoo Web Library (OWL)
Icon
Technical requirements
Icon
Creating an OWL component
Icon
Managing user actions in an OWL component
Icon
Making OWL components reactive
Icon
Understanding the OWL component life cycle
Icon
Adding an OWL field to the form view
17
Chapter 17: In-App Purchasing with Odoo
Icon
Chapter 17: In-App Purchasing with Odoo
Icon
Technical requirements
Icon
IAP concepts
Icon
Registering an IAP service in Odoo
Icon
Creating an IAP service module
Icon
Authorizing and charging IAP credits
Icon
Creating an IAP client module
Icon
Displaying offers when an account lacks credits
18
Chapter 18: Automated Test Cases
Icon
Chapter 18: Automated Test Cases
Icon
Technical requirements
Icon
Adding Python test cases
Icon
Running tagged Python test cases
Icon
Setting up Headless Chrome for client-side test cases
Icon
Adding client-side QUnit test cases
Icon
Adding tour test cases
Icon
Running client-side test cases from the UI
Icon
Debugging client-side test cases
Icon
Generating videos/screenshots for failed test cases
Icon
Populating random data for testing
19
Chapter 19: Managing, Deploying, and Testing with Odoo.sh
Icon
Chapter 19: Managing, Deploying, and Testing with Odoo.sh
Icon
Technical requirements
Icon
Exploring some basic concepts of Odoo.sh
Icon
Creating an Odoo.sh account
Icon
Adding and installing custom modules
Icon
Managing branches
Icon
Accessing debugging options
Icon
Getting a backup of your instance
Icon
Checking the status of your builds
Icon
All Odoo.sh options
20
Chapter 20: Remote Procedure Calls in Odoo
Icon
Chapter 20: Remote Procedure Calls in Odoo
Icon
Technical requirements
Icon
Logging in to/connecting Odoo with XML-RPC
Icon
Searching/reading records through XML-RPC
Icon
Creating/updating/deleting records through XML-RPC
Icon
Calling methods through XML-RPC
Icon
Logging in to/connecting Odoo with JSON-RPC
Icon
Fetching/searching records through JSON-RPC
Icon
Creating/updating/deleting records through JSON-RPC
Icon
Calling methods through JSON-RPC
Icon
The OCA odoorpc library
Icon
Generating API keys
21
Chapter 21: Performance Optimization
Icon
Chapter 21: Performance Optimization
Icon
The prefetching pattern for recordsets
Icon
The in-memory cache – ormcache
Icon
Generating differently sized images
Icon
Accessing grouped data
Icon
Creating or writing multiple records
Icon
Accessing records through database queries
Icon
Profiling Python code
22
Chapter 22: Point of Sale
Icon
Chapter 22: Point of Sale
Icon
Technical requirements
Icon
Adding custom JavaScript/SCSS files
Icon
Adding an action button on the keyboard
Icon
Making RPC calls
Icon
Modifying the Point of Sale screen UI
Icon
Modifying existing business logic
Icon
Modifying customer receipts
23
Chapter 23: Managing Emails in Odoo
Icon
Chapter 23: Managing Emails in Odoo
Icon
Technical requirements
Icon
Configuring incoming and outgoing email servers
Icon
Managing chatter on documents
Icon
Managing activities on documents
Icon
Sending emails using the Jinja template
Icon
Sending emails using the QWeb template
Icon
Managing the email alias
Icon
Logging user changes in a chatter
Icon
Sending periodic digest emails
24
Chapter 24: Managing the IoT Box
Icon
Chapter 24: Managing the IoT Box
Icon
Technical requirements
Icon
Flashing the IoT Box image for Raspberry Pi
Icon
Connecting the IoT Box with a network
Icon
Adding the IoT Box to Odoo
Icon
Loading drivers and listing connected devices
Icon
Taking input from devices
Icon
Accessing the IoT Box through SSH
Icon
Configuring a point of sale
Icon
Sending PDF reports directly to a printer
25
Other Books You May Enjoy
Icon
Other Books You May Enjoy
Icon
Leave a review - let other readers know what you think

Executing raw SQL queries

Most of the time, you can perform the operations you want by using Odoo's ORM. For example, you can use the search() method to fetch records. However, sometimes, you need more; either you cannot express what you want using the domain syntax (for which some operations are tricky, if not downright impossible) or your query requires several calls to search(), which ends up being inefficient.

This recipe shows you how to use raw SQL queries to get the average number of days a user keeps a particular book.

Getting ready

For this recipe, we will use the my_library module from the previous recipe. For simplicity, we will just print the results in a log, but in real scenarios, you will need to use the query result in your business logic. In Chapter 9, Backend Views, we will display the result of this query in the user interface.

How to do it...

To get the information about the average number of days a user keeps a particular book, you need to perform...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Odoo 14 Development Cookbook
End of Section 8
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options
font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon