How to automatically insert data into data base.

Question

I want to automatically fill a table when another table is filled by user.
here's the problem :
I have different products for rent (let's say cars), each product have different stock/quantity.
I want to develop a method that if a user/admin adds a new "Car Model" with 'stock = N' the method adds N new rows of data for each car.
the reason i need them to be stored separately is because each car has it's own attributes e.g. how many times has it been rented, need repair or not, damaged or not, etc

Gaddour · Answer

Thanks so mush that was helpful
I did the following and it worked
#this code is inside Car Model's class
#Overriding create
@api.model
def create(self, vals):
res = super(CarModel, self).create(vals)
for i in range(vals["stock"]):
super(rc.RentCar, self.env['rent.car']).create({
'model_id': res.id,
'car_ref' : "%s_%s" %(res.ref,i+1),
'name' : "%s #%s" %(res.name,i+1)
})
return res

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
You can apply your logic by overriding the create and write method of the first model.
For overriding the create method, see:  https://www.youtube.com/watch?v=_-fs_NBeOLI [1]
Thanks

[1] https://www.youtube.com/watch?v=_-fs_NBeOLI

Powiązane posty	Odpowiedzi	Widoki
which method use odoo to create new stock move Rozwiązane stock move method	2 sty 24	14509
Database list method in openerp Rozwiązane database list method	3 mar 15	8625
Account invoice and stock picking not connected anymore stock invoice database picking	1 kwi 19	4829
Stock journals and stock moves are not create in POS Sales -Odoo 10 stock accounting database journals	0 kwi 18	2876
Error when installing stock module stock modules database addons	3 wrz 17	5336

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!