32 lines
1.1 KiB
Python
32 lines
1.1 KiB
Python
from odoo.tools import sql
|
|
|
|
|
|
def migrate(cr, version):
|
|
# Select relevant ids to generate the list of x_plan_id column names, removing the id of the project plan
|
|
cr.execute(
|
|
"""
|
|
SELECT value::int
|
|
FROM ir_config_parameter
|
|
WHERE key = 'analytic.project_plan'
|
|
"""
|
|
)
|
|
[project_plan_id] = cr.fetchone()
|
|
cr.execute("SELECT id FROM account_analytic_plan WHERE id != %s AND parent_id IS NULL", [project_plan_id])
|
|
plan_ids = [r[0] for r in cr.fetchall()]
|
|
column_names = [f"x_plan{id_}_id" for id_ in plan_ids]
|
|
# Update on_delete for existing x_plan_id columns
|
|
cr.execute(
|
|
"""
|
|
UPDATE ir_model_fields
|
|
SET on_delete = 'restrict'
|
|
WHERE model = 'account.analytic.line'
|
|
AND on_delete = 'set null'
|
|
AND name = ANY(%s)
|
|
""",
|
|
[column_names],
|
|
)
|
|
# Change the constraint on the table definition
|
|
for column in column_names:
|
|
sql.drop_constraint(cr, 'account_analytic_line', f'account_analytic_line_{column}_fkey')
|
|
sql.add_foreign_key(cr, 'account_analytic_line', column, 'account_analytic_account', 'id', 'restrict')
|