forked from OCA/purchase-workflow
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpre-migrate.py
57 lines (51 loc) · 1.29 KB
/
pre-migrate.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
# Copyright 2024 Camptocamp SA
# License AGPL-3.0 or later (https://www.gnu.org/licenses/agpl)
from openupgradelib import openupgrade
def migrate_order_discount_to_discount1(env):
openupgrade.add_fields(
env,
[
(
"discount1",
"purchase.order.line",
"purchase_order_line",
"float",
"numeric",
"purchase_triple_discount",
0.0,
)
],
)
openupgrade.logged_query(
env.cr,
"""
UPDATE purchase_order_line
SET discount1 = discount;
""",
)
def migrate_supplierinfo_discount_to_discount1(env):
openupgrade.add_fields(
env,
[
(
"discount1",
"product.supplierinfo",
"product_supplierinfo",
"float",
"numeric",
"purchase_triple_discount",
0.0,
)
],
)
openupgrade.logged_query(
env.cr,
"""
UPDATE product_supplierinfo
SET discount1 = discount;
""",
)
@openupgrade.migrate()
def migrate(env, version):
migrate_order_discount_to_discount1(env)
migrate_supplierinfo_discount_to_discount1(env)