Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Is there any alternative way to create/write data at once ?
Now i'm using
for rec in bla :
vals = {}
vals['name'] = rec.name
obj.create(vals)
When i'm trying to create 1000++ data i will be very slow, take 1-3 Hours.
I need alternative way ! Thank You !!
Hi @Chaanto
There are several ways that you could use to get that task done. Here I give you 2. Hope it will help you
1- Using Model load method that accept 2 arguments, fields and data. were fields is a list of fields that match the elements in the data rows meaning that the argument with the data need to be a list of rows and every row will be the list of values of the fields in the same order
Model = self.env['model.name']2- Using Cursor copy_from by building a CSV with the data to be load using an SQL Copy Commands
result = Model.load(
['name', 'value'],
[
['A', '1'],
['B', '2'],
['C', '3']
],
)
fields = ['name', 'value']
self.env.cr.copy_from(io.StringIO(
u'\n'.join(
u"%s\t%s\t%s\t%d" % (
rec.name,
rec.value
)
for rec in bla
)),
table='model_table',
columns=fields,
)
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
Registrieren| Verknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
|---|---|---|---|---|
|
1
Mai 18
|
4129 | ||
|
0
Feb. 18
|
3363 | ||
|
Libary managment
Gelöst
|
|
2
Mai 23
|
2105 | |
|
.create() for a Many2many?
Gelöst
|
|
2
Dez. 18
|
9652 | |
|
0
Mai 16
|
3634 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Hope this will helps: http://learnopenerp.blogspot.com/2019/10/how-to-use-self-env-cr-copy-from-to-save-data-in-database.html