Zum Inhalt springen
Sie müssen registriert sein, um mit der Community zu interagieren.
Alle Beiträge Personen Abzeichen
Stichwörter (Alle anzeigen)
odoo accounting v14 pos v15
Über dieses Forum
Diese Frage wurde gekennzeichnet
createidsqlincrementodooV13
2 Antworten
9047 Ansichten
Avatar
Benjamin Cherpas

Hi,


I'd like to use the create() method to create objects with a specific ID in database like :

self.env['res.partner'].create({'id': 450, 'name': 'TEST'})

But, the ID keeps going to increment normally : 1, 2, 3, etc. and doesn't be 450  as I want.

I think it's because there is DEFAULT in database : nextval('res_partner_id_seq'::regclass) but even if I remove it, it still increments as a simple ID.


I don't want to use an SQL request like UPDATE because, in my code, there are SQL errors like 'ID already exists'. It's not possible to process like that.


If anyone can help me.


Thank you so much.

Regards.

Avatar
Verwerfen
Avatar
Ray Carnes (ray)
Beste Antwort

You should use a different field.

ID is a field maintained by Odoo and not designed to be updatable.

See also: https://www.odoo.com/forum/help-1/question/what-are-the-magic-columns-why-are-they-so-magical-120123

Avatar
Verwerfen
Benjamin Cherpas
Autor

Thanks for your answer ! But I ain't sure I understand the purpose of magic columns and how to use 'em. May you explain me better please? :)

Ray Carnes (ray)

Magic Columns are for Odoo. You need to make your own columns if you want to create with a specific ID. Make your own column and put your information in there. Odoo needs the Magic Columns and you are not supposed to interfere with them.

Benjamin Cherpas
Autor

Thank you for helping me!

Avatar
Abderrahim
Beste Antwort

Well, you can use this 

```

SELECT setval('public."table_name_id_seq"',
(SELECT MAX(id) FROM public.table_name)
);

```

Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
Project.task ID increment, per minute passed?
task id increment
Avatar
Avatar
2
Dez. 24
1591
Import - 'Create if doesn't exist' Gelöst
import create odooV13
Avatar
Avatar
1
Okt. 21
6231
ORM: Create a record with a psecific id Gelöst
create orm id
Avatar
Avatar
1
Juni 19
6100
Odoo Module not appearing Gelöst
apps create developer odooV13
Avatar
Avatar
Avatar
2
Mai 21
12471
Odoov13 reocrds are not created in order of my passsed list
create orm sale.order odooV13 create()
Avatar
0
März 21
2601