pre-migration.py

# Copyright 2024 Akretion France (http://www.akretion.com/)
# @author: Alexis de Lattre <alexis.delattre@akretion.com>
# License AGPL-3.0 or later (http://www.gnu.org/licenses/agpl).

from openupgradelib import openupgrade


@openupgrade.migrate()
def migrate(env, version):
    if not openupgrade.column_exists(env.cr, "res_partner", "country_department_id"):
        openupgrade.rename_fields(
            env,
            [
                (
                    "res.partner",
                    "res_partner",
                    "department_id",
                    "country_department_id",
                ),
            ],
        )

_column_renames = {
    "l10n_fr_intrastat_product_declaration": [("month", None)],
    "l10n_fr_intrastat_product_computation_line": [("invoice_line_id", None)],
}

@openupgrade.migrate()
def migrate(env, version):
    openupgrade.rename_columns(env.cr, _column_renames)
# will be accessible in post-upgrade openupgrade.get_legacy_name("month")
# openupgrade.logged_query(env.cr, "UPDATE xxx")

def migrate(cr, version):
    if not version:
        return

    cr.execute(
        'ALTER TABLE "account_cutoff_line" RENAME "after_cutoff_days" '
        'TO "prepaid_days"')

    cr.execute(
        "UPDATE payment_line SET communication = communication2, "
        "communication2 = null "
        "FROM payment_order "
        "WHERE payment_line.order_id = payment_order.id "
        "AND payment_order.state in ('draft', 'open') "
        "AND payment_line.state = 'normal' "
        "AND communication2 is not null")

# Explications :
# Il faut créer un sous-répertoire "migrations/7.0.0.2/" et mettre ce script dedans:
# le script sera alors exécuté pour openerp 7.0, quand on met à jour le module vers la version 0.2
# Si on utilise la nouvelle numérotation à 5 chiffres de l'OCA, il faut créer un répertoire "migrations/8.0.1.0.2" (sans ajouter le numéro de version d'Odoo