Database population in Odoo 18 - Odoo slides

In this slide, we’ll discuss the database population in Odoo 18. In Odoo, performance analysis of the source code is more important. Database population is one of the methods used to analyze the performance of our code.

1. Database population in Odoo 18 Enterprise

2. Enterprise Introduction In this slide, we’ll discuss the database population in Odoo 18. In Odoo, performance analysis of the source code is more important. Database population is one of the methods used to analyze the performance of our code. We can use this feature to fill the database with a number of test data. And it will help to find the bugs or issues in the test. Odoo Command Line Interface (CLI) is used to accomplish the feature database population, and it will generate data automatically for the records of models to test the database containing a significant amount of records.

3. Enterprise Methods and attributes to populate a model _populate_sizes(): This function will return a dictionary that maps the sizes ('small', 'medium', 'large'). Default sizes are small: 10, medium: 100, large: 1000 _populate_dependencies(): This function will return dependent models of the current populating model. Those models will populate first before the current model. _populate(size): This function will create records to populate the corresponding model. The parameter size is a string that may be small, medium, or large. populate_factories(): This function will populate a factory for different fields of the corresponding model. And the factory is a dictionary of field values. It will return a list of pairs(field_name, factory) where `factory` is a generator function.

4. Enterprise Lets see an example, we want to define at least _populate(size) or _populate_factories() for the database population. Commonly, population functions and attributes for the models will be defined inside the populate directory of the module. class ProductCategory (models.Model) : _inherit = "product.category" _populate_sizes = { "small" : 50 , "medium" : 500 , "large" : 5 _000} def _populate_factories (self) : return [( "name" , populate.constant( 'PC_{counter}' ))] def _populate (self, size) : categories = super()._populate(size) # Set parent/child relation self._populate_set_parents(categories, size) return categories

5. Enterprise def _populate_set_parents (self, categories, size) : _logger.info( 'Set parent/child relation of product categories' ) parent_ids = [] rand = populate.Random( 'product.category+parent_generator' ) for category in categories: if rand.random() < 0.25 : parent_ids.append(category.id) categories -= self.browse(parent_ids) parent_childs = collections.defaultdict( lambda : self.env[ 'product.category' ]) for category in categories: if rand.random() < 0.25 : parent_childs[rand.choice(parent_ids)] |= category for count, (parent, children) in enumerate(parent_childs.items()): if (count + 1 ) % 1000 == : _logger.info( 'Setting parent: %s/%s' , count + 1 , len(parent_childs)) children.write({ 'parent_id' : parent})

6. Enterprise In the above example, the product.template model will be populated. For populating, we can use the command on the server from the directory where the odoo-bin file is located. ./odoo-bin populate –-models models_name -d database_name Then, we can see the terminal while populating the models. Test records will be generated for all the models defined by the populate functions.

7. Enterprise Here we can see all the records populated by this method .

8. For More Info. Check our company website for related blogs and Odoo book. Check our YouTube channel for functional and technical videos in Odoo. Enterprise www.cybrosys.com