mirror of
https://gitlab.com/flectra-community/reporting-engine.git
synced 2024-11-15 02:32:05 +00:00
30 lines
1.2 KiB
Python
30 lines
1.2 KiB
Python
|
# Copyright 2021 Tecnativa - Víctor Martínez
|
||
|
|
# Copyright 2021 Tecnativa - Pedro M. Baeza
|
||
|
|
# License AGPL-3.0 or later (https://www.gnu.org/licenses/agpl).
|
||
|
|
from openupgradelib import openupgrade
|
||
|
|
|
||
|
|
from flectra.tools import parse_version
|
||
|
|
|
||
|
|
|
||
|
|
@openupgrade.migrate()
|
||
|
|
def migrate(env, version):
|
||
|
|
if parse_version(version) == parse_version("14.0.1.0.0"):
|
||
|
|
openupgrade.logged_query(
|
||
|
|
env.cr,
|
||
|
|
"""
|
||
|
|
INSERT INTO base_comment_template_res_partner_rel
|
||
|
|
(res_partner_id, base_comment_template_id)
|
||
|
|
SELECT SPLIT_PART(ip.res_id, ',', 2)::int AS res_partner_id,
|
||
|
|
SPLIT_PART(ip.value_reference, ',', 2)::int AS base_comment_template_id
|
||
|
|
FROM ir_property ip
|
||
|
|
JOIN ir_model_fields imf ON ip.fields_id = imf.id
|
||
|
|
JOIN res_partner rp ON rp.id = SPLIT_PART(ip.res_id, ',', 2)::int
|
||
|
|
JOIN base_comment_template bct
|
||
|
|
ON bct.id = SPLIT_PART(ip.value_reference, ',', 2)::int
|
||
|
|
WHERE imf.name = 'property_comment_template_id'
|
||
|
|
AND imf.model = 'res.partner'
|
||
|
|
AND ip.res_id IS NOT NULL
|
||
|
|
ON CONFLICT DO NOTHING
|
||
|
|
""",
|
||
|
|
)
|