Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

What is the recommended practice when updating models fieds ?

update odooV8 schema ORM

2 Antwoorden

4231 Weergaven

Paraita Wohler

We are using Odoo v8 and we'd like to improve the deployment of our in-house modules into production.

What are the good practices when upgrading custom modules ? At the moment we copy the latest version of the module into the addons folder, and trigger the update of the said module from the web interface (I do restart the server whenever it's required).

I forsee problems when I'm going to update existing (stored) fields in some of my models. I understand the Odoo ORM is going to create new storable fields but it doesn't have any clue if the new field comes from a renamed field or if it's a legit new field, so in the end we have to update our tables and move the values of the old field columns to the new field columns.

At the moment we tend to avoid modifying existing fields of our modules, as renaming those would make them appear empty on the user side (thank god Odoo doesn't drop non used columns).

With Hibernate (Java) it's possible to use different ddl strategies so the update of the schema is either the ORM's responsibility or the DBA's. Hibernate recommends the latter, because the update is more predictable. Is there a similar mechanism with Odoo ?

Paraita Wohler

Auteur

up !

Mohammed Rida Yahla

Hi,

When you get a new stored field after renaming the old one, you can pass the values from the old field to the new using a SQL commande in PGAdmin database (and after that you can drop the old if you want), in condition both of the new and old fields have compatible types (CHAR -> CHAR ...), otherwise you will have to use SQL converting functions.

For example let say you have a Char field named "description" in the model "My_model", and you want to rename it as "features":

To pass the old values from "description" column to the new "features", you have to run this sql query in postegres (PGAdmin):

update My_model set features = description where features ='';

And by this you can merge the old values without losing the new ones.

Please Vote if you find my answer usefull.

Paraita Wohler

Auteur

Thank you for your answer :) that's exactly what we are doing at the moment but as a control gate we'd like to prevent Odoo's ORM to "update" the database schema automatically so that changes like moving values from the old column to the new one become more explicit (which is good for maintainability). The trade-off in doing so is that we'd have to manually alter tables for Odoo's ORM to accomodate with its models, which can be acceptable in our case.

In the Java world, ORMs like Hibernate have such features (you can have a look at the hibernate.hbm2ddl.auto parameter in https://docs.jboss.org/hibernate/orm/5.0/manual/en-US/html/ch03.html). SQLAlchemy also have such feature through its Alembic tool.

Do you think there is a similar feature with Odoo ?

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
Why odoo want to delete some items when update all module ? Opgelost update odooV8	10 mei 20	9705
How to start server with --update all update odooV8	1 jan. 16	7225
Developing new modules, KeyError: 'stock.picking' return self.models[model_name] Opgelost module update odooV8	1 jan. 25	24622
updating module from command line error update postgresql9.2 odooV8	1 mei 21	6601
Odoo v8 still good for use? update odooV8 odoo9.0	5 jan. 17	5274

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!