def migrate(env, version):
if not version:
return
openupgrade.drop_columns(env.cr, [
('lighting_product_source_line', 'color_temperature'),
])
def migrate(env, version):
if not version:
return
openupgrade.drop_columns(env.cr, [
('lighting_product', 'color_consistency'),
])
def migrate(cr, version):
openupgrade.copy_columns(cr, column_copies)
openupgrade.rename_tables(cr, table_renames)
openupgrade.rename_columns(cr, column_renames)
openupgrade.rename_xmlids(cr, xmlid_renames)
# Removing transient tables to get rid of warnings
openupgrade.drop_columns(cr, column_drops)
def migrate(cr, version):
if not version:
return
legacy_reviewer_id =\
openupgrade.get_legacy_name("reviewer_id")
legacy_reviewer_group_id =\
openupgrade.get_legacy_name("reviewer_group_id")
with api.Environment.manage():
env = api.Environment(cr, SUPERUSER_ID, {})
openupgrade.m2o_to_x2m(
cr=cr,
model=env["tier.definition.review"],
table="tier_definition_review",
field="reviewer_ids",
source_field=legacy_reviewer_id,
)
openupgrade.m2o_to_x2m(
cr=cr,
model=env["tier.definition.review"],
table="tier_definition_review",
field="reviewer_group_ids",
source_field=legacy_reviewer_group_id,
)
openupgrade.drop_columns(
cr=cr,
column_spec=[
("tier_definition_review", legacy_reviewer_id),
("tier_definition_review", legacy_reviewer_group_id),
],
)
def migrate(env, version):
if not version:
return
openupgrade.drop_columns(env.cr, [
('lighting_product', 'install_location'),
])
def migrate(env, version):
if not version:
return
openupgrade.drop_columns(env.cr, [
('lighting_product_ledchip', 'product_id'),
])
def migrate(env, version):
if not version:
return
# Remove old stored computed fields db columns
openupgrade.drop_columns(env.cr, [
('res_partner', 'risk_payment_return'),
])
def migrate(cr, version):
with api.Environment.manage():
env = api.Environment(cr, SUPERUSER_ID, {})
map_rma_operation(env)
map_rma_order_line(env)
openupgrade.drop_columns(cr, drop_columns)
def migrate(env, version):
if not version:
return
openupgrade.drop_columns(env.cr, [
('lighting_product', 'in_progress'),
('lighting_product', 'discontinued'),
])
def migrate(env, version):
if not version:
return
# remove equipment brand field from product type
openupgrade.drop_columns(env.cr, [
('lighting_product', 'auxiliary_equipment_brand_id'),
])
def migrate(env, version):
if not version:
return
openupgrade.drop_columns(env.cr, [
('lighting_product',
openupgrade.get_legacy_name('auxiliary_equipment_id')),
])
def migrate(env, version):
if not version:
return
openupgrade.drop_columns(env.cr, [
('lighting_product', 'ip'),
('lighting_product', 'ip2'),
])
def migrate(env, version):
if not version:
return
# remove type_id from product
openupgrade.drop_columns(env.cr, [
('lighting_product', openupgrade.get_legacy_name('type_id')),
])
def migrate(env, version):
cr = env.cr
# Restore columns disabled on 8.0 -> 9.0 migration
for row in column_renames[table]:
if openupgrade.column_exists(cr, table, row[0]):
if openupgrade.column_exists(cr, table, row[1]):
row1 = [(table, row[1])]
openupgrade.drop_columns(cr, row1)
columns = {table: [(row[0], row[1])]}
openupgrade.rename_columns(cr, columns)
def migrate(env, version):
if not version:
return
# remove is_accessory field from product type
openupgrade.drop_columns(
env.cr,
[('lighting_product_type', 'is_accessory'),
]
)
def migrate_progress(env, cr):
if openupgrade.column_exists(cr, 'mrp_bom', 'name'):
cr.execute("""
UPDATE
mrp_bom
SET
code=name;
""")
openupgrade.drop_columns(cr, [
('mrp_bom', 'name'),
])
def migrate(cr, installed_version):
new_column = tools.get_legacy_name('fixme')
query_update = """
update hr_attendance set state = 'fix' where {new_column} = True
""".format(new_column=new_column)
cr.execute(query_update)
query_update = """
update hr_attendance set state = 'right'
where {new_column} = False or {new_column} is Null
""".format(new_column=new_column)
cr.execute(query_update)
# Drop new_column
tools.drop_columns(cr, [['hr.attendance', new_column]])
def migrate(env, version):
if not version:
return
fields = [
'input_current',
'output_current',
]
openupgrade.drop_columns(
env.cr,
[('lighting_product', '%s_moved0' % f) for f in fields]
)
def migrate(env, version):
if not version:
return
if openupgrade.table_exists(env.cr, 'ambassador_details'):
openupgrade.rename_tables(env.cr, [
('ambassador_details', 'advocate_details'),
('ambassador_engagement', 'advocate_engagement'),
('ambassador_engagement_rel', 'advocate_engagement_rel')
])
openupgrade.rename_models(env.cr, [
('ambassador.details', 'advocate.details'),
('ambassador.engagement', 'advocate.engagement')
])
if not openupgrade.column_exists(env.cr, 'res_partner',
'advocate_details_id'):
openupgrade.rename_fields(env, [
('res.partner', 'res_partner',
'ambassador_details_id', 'advocate_details_id'),
], True)
openupgrade.rename_columns(env.cr, {
'advocate_engagement_rel': [
('ambassador_details_id', 'advocate_details_id')]
})
if openupgrade.column_exists(env.cr, 'res_partner',
'ambassador_details_id'):
openupgrade.drop_columns(env.cr,
[('res_partner', 'ambassador_details_id')])
# Replace field in views to avoid errors at update
env.cr.execute("""
UPDATE ir_ui_view
SET arch_db = replace(arch_db, 'ambassador_details_id',
'advocate_details_id')
WHERE arch_db LIKE '%ambassador_details_id%';
""")
# Delete old translations
env.cr.execute("""
DELETE FROM ir_translation
WHERE value = 'Details of ambassador'
""")
# Update templates
env.cr.execute("""
UPDATE ir_translation
SET value = replace(value, 'ambassador_details_id',
'advocate_details_id'),
src = replace(src, 'ambassador_details_id',
'advocate_details_id')
WHERE value LIKE '%ambassador_details_id%'
""")
def migrate(env, version):
if not version:
return
fields = [
'novelty',
'cataloged',
'discontinued_by_supplier',
'until_end_stock',
'discontinued',
]
openupgrade.drop_columns(env.cr,
[('lighting_product', '%s' % f) for f in fields])
def migrate(env, version):
if not version:
return
# Recompute after improvements in rounding, currency, invoice status,
# w/o stock moves, etc.
logger.info('Recomputing field risk_amount on sale.order.line')
lines = env['sale.order.line'].search(
[('state', '=', 'sale'), ('risk_amount', '!=', 0.0)], order='id')
lines._compute_risk_amount()
# Remove old stored computed fields db columns
openupgrade.drop_columns(env.cr, [
('res_partner', 'risk_sale_order'),
])
def migrate(env, version):
if not version:
return
# Remove old cron
openupgrade.delete_records_safely_by_xml_id(env, [
'account_financial_risk.ir_cron_due_invoice_every_day',
])
# Remove old stored computed fields db columns
openupgrade.drop_columns(env.cr, [
('res_partner', 'risk_invoice_draft'),
('res_partner', 'risk_invoice_open'),
('res_partner', 'risk_invoice_unpaid'),
('res_partner', 'risk_account_amount'),
('res_partner', 'risk_account_amount_unpaid'),
])
def migrate(env, version):
if not version:
return
openupgrade.map_values(
env.cr,
"nbmag_moved0",
"nbmag",
magazine_number_mapping,
table="res_partner"
)
openupgrade.drop_columns(
env.cr,
[("res_partner", "nbmag_moved0")]
)
def migrate(env, version):
if not version:
return
fields = [
'corrosion_resistance',
'recessing_box_included',
'periodic_maintenance',
'anchorage_included',
'post_included',
'post_with_inspection_chamber',
'emergency_light',
'flammable_surfaces',
'mechanical_screwdriver',
]
openupgrade.drop_columns(env.cr, [('lighting_product', '%s_moved0' % f)
for f in fields])
def migrate(cr, version):
if not version:
return
# Restore need call as before communication sent by default
cr.execute("""
UPDATE partner_communication_config
SET need_call = 'before_sending'
WHERE need_call_backup IS TRUE;
""")
cr.execute("""
UPDATE partner_communication_job
SET need_call = 'before_sending'
WHERE need_call_backup IS TRUE;
""")
openupgrade.drop_columns(cr, [
('partner_communication_config', 'need_call_backup'),
('partner_communication_job', 'need_call_backup'),
])
def migrate(env, version):
for model, table in tables:
for old_field, new_field in sparse_field_columns:
field = False
if openupgrade.column_exists(env.cr, table, old_field):
field = old_field
elif openupgrade.column_exists(env.cr, table, new_field):
field = new_field
if not field:
continue
env.cr.execute(
"SELECT id, %s from %s WHERE %s IS NOT NULL" % (
field, table, field
)
)
for data in env.cr.fetchall():
# We need to rewrite the data in order to not lose anything
env[model].browse(data[0]).write({
new_field: data[1]
})
# Once all the data has been migrated, we can delete the column
openupgrade.drop_columns(env.cr, [(table, field)])
def migrate(cr, version):
env = api.Environment(cr, SUPERUSER_ID, {})
migrate_update_module(cr)
migrate_create_temp_table(cr)
migrate_cancel_reason(env)
migrate_old_value(cr)
openupgrade.drop_columns(cr,
[("agreement_agreement", "old_cancel_reason_id")])
migrate_update_base_cancel_reason_config(env)
if openupgrade.table_exists(env.cr, "agreement_cancel_reason"):
openupgrade.logged_query(
cr,
"""
DROP TABLE agreement_cancel_reason CASCADE
""",
)
if openupgrade.table_exists(env.cr, "temp_cancel_reason"):
openupgrade.logged_query(
cr,
"""
DROP TABLE temp_cancel_reason
""",
)
def migrate(cr, version):
if not version:
return
openupgrade.drop_columns(cr, column_drops)
def migrate(cr, version):
env = api.Environment(cr, SUPERUSER_ID, {})
openupgrade.drop_columns(cr, [("loan_in", "date_payment")])
openupgrade.drop_columns(cr, [("loan_out", "date_payment")])
migrate_first_payment_date_loan_in(env)
migrate_first_payment_date_loan_out(env)
