def migrate(cr, version):
if not version:
return
openupgrade.rename_tables(cr, [
('icp_interventions', 'fcp_interventions'),
('icp_global_interventions', 'fcp_global_interventions'),
('compassion_intervention_search_icp',
'compassion_intervention_search_fcp'),
])
openupgrade.rename_columns(
cr, {
'fcp_interventions': [('icp_id', 'fcp_id')],
'compassion_intervention_search_fcp': [('icp_id', 'fcp_id')],
'fcp_global_interventions': [('icp_id', 'fcp_id')],
'intervention_spiritual_activities': [
('icp_spiritual_activity_id', 'fcp_spiritual_activity_id')
],
'intervention_cognitive_activities': [
('icp_cognitive_activity_id', 'fcp_cognitive_activity_id')
],
'intervention_physical_activities': [
('icp_physical_activity_id', 'fcp_physical_activity_id')
],
'intervention_socio_activities':
[('icp_sociological_activity_id', 'fcp_sociological_activity_id')],
})
def migrate(env, version):
cr = env.cr
openupgrade.copy_columns(cr, _column_copies)
openupgrade.rename_columns(cr, _column_renames)
openupgrade.rename_fields(env, _field_renames)
if openupgrade.table_exists(cr, 'sale_order'):
openupgrade.rename_fields(env, _field_sale_renames)
# https://github.com/odoo/odoo/commit/ca25a692bd19fdca2b2600f2054eb419aae28999
openupgrade.logged_query(
env.cr, """
UPDATE ir_config_parameter
SET key = 'account.use_invoice_terms'
WHERE key = 'sale.use_sale_note'"""
)
openupgrade.rename_models(cr, _model_renames)
openupgrade.rename_tables(cr, _table_renames)
type_change_account_fiscal_position_zips(env)
create_account_invoice_amount_tax_company_signed(env)
create_account_move_new_columns(env)
fill_account_move_line_parent_state(env)
fill_account_move_line_account_internal_type(env)
create_res_partner_ranks(env)
add_helper_invoice_move_rel(env)
if openupgrade.table_exists(cr, 'account_voucher'):
add_helper_voucher_move_rel(env)
def migrate(env, version):
if openupgrade.table_exists(env.cr, "crm_lead_tag"):
openupgrade.rename_models(
env.cr,
[
("crm.lead.tag", "crm.tag"),
],
)
openupgrade.rename_tables(
env.cr,
[
("crm_lead_tag", "crm_tag"),
],
)
openupgrade.set_xml_ids_noupdate_value(
env, "sales_team", ["crm_rule_all_salesteam", "sale_team_comp_rule"], True
)
openupgrade.rename_xmlids(
env.cr,
[
("crm.crm_lead_tag_action", "sales_team.sales_team_crm_tag_action"),
("crm.crm_lead_tag_form", "sales_team.sales_team_crm_tag_view_form"),
("crm.crm_lead_tag_tree", "sales_team.sales_team_crm_tag_view_tree"),
("crm.access_crm_lead_tag", "sales_team.access_crm_tag"),
("crm.access_crm_lead_tag_manager", "sales_team.access_crm_tag_manager"),
("crm.access_crm_lead_tag_salesman", "sales_team.access_crm_tag_salesman"),
],
)
def migrate(cr, version):
if not version:
return
openupgrade.rename_tables(cr, [('printing_tray', 'printing_tray_input')])
openupgrade.rename_models(cr, [
('printing.tray', 'printing.tray.input'),
])
def migrate(env, version):
cr = env.cr
openupgrade.rename_columns(cr, column_renames)
openupgrade.rename_fields(env, field_renames)
openupgrade.copy_columns(cr, column_copies)
openupgrade.rename_tables(cr, table_renames)
map_order_state(cr)
def migrate(env, version):
install_new_modules(env.cr)
openupgrade.rename_columns(env.cr, column_renames_account_payment)
if openupgrade.is_module_installed(env.cr, 'account_direct_debit'):
openupgrade.update_module_names(
env.cr, [('account_direct_debit', 'account_payment_order')],
merge_modules=True)
if openupgrade.is_module_installed(env.cr,
'account_banking_payment_export'):
openupgrade.update_module_names(
env.cr,
[('account_banking_payment_export', 'account_payment_order')],
merge_modules=True)
openupgrade.rename_columns(env.cr, column_renames_payment_export)
migrate_payment_mode_types(env)
if openupgrade.is_module_installed(env.cr,
'account_banking_payment_transfer'):
openupgrade.rename_columns(env.cr, column_renames_payment_transfer)
openupgrade.update_module_names(
env.cr,
[('account_banking_payment_transfer', 'account_payment_order')],
merge_modules=True)
openupgrade.rename_models(env.cr, models_renames)
openupgrade.rename_tables(env.cr, table_renames)
populate_computed_fields(env)
def migrate_base_action_rule(cr):
""" base.action.rule renamed base.automation
Models, table and xmlid renaming
"""
openupgrade.rename_models(cr, model_renames_base_action_rule)
openupgrade.rename_tables(cr, table_renames_base_action_rule)
openupgrade.rename_xmlids(cr, xmlid_renames_base_action_rule)
def migrate(env, version):
openupgrade.update_module_names(env.cr, apriori.renamed_modules.items())
openupgrade.update_module_names(env.cr,
apriori.merged_modules.items(),
merge_modules=True)
openupgrade.rename_models(env.cr, model_renames)
openupgrade.rename_tables(env.cr, table_renames)
if openupgrade.table_exists(env.cr, 'stock_incoterms'):
openupgrade.rename_models(
env.cr,
[('stock.incoterms', 'account.incoterms')],
)
openupgrade.rename_tables(
env.cr,
[('stock_incoterms', 'account_incoterms')],
)
openupgrade.rename_xmlids(env.cr, xmlid_renames)
eliminate_duplicate_translations(env.cr)
# Make the system and admin user XML ids refer to the same entry for now to
# prevent errors when base data is loaded. The users are picked apart in
# this module's end stage migration script.
env.cr.execute(""" INSERT INTO ir_model_data
(module, name, model, res_id, noupdate)
VALUES('base', 'user_admin', 'res.users', 1, true)""")
env.cr.execute(""" INSERT INTO ir_model_data
(module, name, model, res_id, noupdate)
(SELECT module, 'partner_admin', model, res_id, noupdate
FROM ir_model_data WHERE module = 'base' AND name = 'partner_root')
""")
fix_lang_constraints(env)
fix_lang_table(env)
# for migration of web module
openupgrade.rename_columns(
env.cr, {'res_company': [('external_report_layout', None)]})
def migrate(env, version):
if openupgrade.table_exists(env.cr,
"product_template_res_company_assignment_rel"):
openupgrade.rename_tables(
env.cr,
[
(
"product_template_res_company_assignment_rel",
"product_template_res_company_rel",
),
],
)
openupgrade.rename_columns(
env.cr,
{
"product_template_res_company_rel": [
("res_company_assignment_id", "res_company_id"),
],
},
)
hooks.set_security_rule(env, "product.product_comp_rule")
env.ref("stock.product_pulled_flow_comp_rule").write({
"domain_force": ("['|', ('company_id', '=', False), ('company_id', "
"'in', company_ids)]"),
})
env.ref("stock.stock_location_route_comp_rule").write({
"domain_force": ("['|', ('company_id', '=', False), ('company_id', "
"'in', company_ids)]"),
})
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(env, version):
openupgrade.rename_models(env.cr, _model_renames)
openupgrade.rename_tables(env.cr, _table_renames)
openupgrade.rename_fields(env, _field_renames)
openupgrade.rename_xmlids(env.cr, _xmlid_renames)
fill_website_rewrite_name(env.cr)
openupgrade.cow_templates_mark_if_equal_to_upstream(env.cr)
def migrate(env, version):
cr = env.cr
openupgrade.rename_columns(cr, _column_renames)
openupgrade.rename_fields(env, _field_renames)
openupgrade.rename_models(cr, _model_renames)
openupgrade.rename_tables(cr, _table_renames)
avoid_new_constraint_in_product_template_attribute_line(cr)
def migrate(env, version):
cr = env.cr
openupgrade.rename_models(cr, models_to_rename)
openupgrade.rename_tables(cr, tables_to_rename)
openupgrade.rename_xmlids(cr, xmlids_to_rename)
openupgrade.copy_columns(cr, columns_to_copy)
create_contract_records(cr)
def migrate(env, version):
cr = env.cr
openupgrade.rename_models(cr,
[("patterned.import.export", "pattern.file")])
openupgrade.rename_tables(cr,
[("patterned_import_export", "pattern_file")])
openupgrade.rename_columns(cr, {"pattern_file": [("status", "state")]})
def rename_attachment_queue(cr):
openupgrade.rename_tables(
cr, [('account_analytic_line', 'timesheet_analytic_line')]
)
openupgrade.rename_models(
cr, [('account.analytic.line', 'timesheet.analytic.line')]
)
def migrate(cr, version):
if not version:
return
from openupgradelib import openupgrade
### rename model
openupgrade.rename_models(
cr, [('lighting.product.leddriver', 'lighting.product.ledchip'),
]
)
### rename DB
# rename table and sequence
openupgrade.rename_tables(
cr, [('lighting_product_leddriver', 'lighting_product_ledchip')]
)
# rename constraints
cr.execute(
"COMMENT ON TABLE lighting_product_ledchip "
"IS 'lighting.product.ledchip'"
)
cr.execute(
"ALTER TABLE lighting_product_ledchip "
"RENAME CONSTRAINT lighting_product_leddriver_leddriver_uniq "
"TO lighting_product_ledchip_ledchip_uniq"
)
cr.execute(
"ALTER TABLE lighting_product_ledchip "
"RENAME CONSTRAINT lighting_product_leddriver_pkey "
"TO lighting_product_ledchip_pkey"
)
cr.execute(
"ALTER TABLE lighting_product_ledchip "
"RENAME CONSTRAINT lighting_product_leddriver_brand_id_fkey "
"TO lighting_product_ledchip_brand_id_fkey"
)
cr.execute(
"ALTER TABLE lighting_product_ledchip "
"RENAME CONSTRAINT lighting_product_leddriver_create_uid_fkey "
"TO lighting_product_ledchip_create_uid_fkey"
)
cr.execute(
"ALTER TABLE lighting_product_ledchip "
"RENAME CONSTRAINT lighting_product_leddriver_product_id_fkey "
"TO lighting_product_ledchip_product_id_fkey"
)
cr.execute(
"ALTER TABLE lighting_product_ledchip "
"RENAME CONSTRAINT lighting_product_leddriver_write_uid_fkey "
"TO lighting_product_ledchip_write_uid_fkey"
)
def migrate(env, version):
# No need to check existence, as if getting to this, it will exist
# Many2many field
openupgrade.rename_tables(
env.cr, [('analytic_account_analytic_line',
'magnus_timesheet_timesheet_analytic_line')],
)
def migrate(env, version):
cr = env.cr
openupgrade.rename_columns(cr, _column_renames)
openupgrade.rename_fields(env, _field_renames)
openupgrade.rename_models(cr, _model_renames)
openupgrade.rename_tables(cr, _table_renames)
openupgrade.logged_query(
env.cr, "ALTER TABLE hr_leave_type ADD validity_start DATE")
def migrate(cr, version):
# 9.0 introduces a constraint enforcing this
cr.execute("update account_account set reconcile=True "
"where type in ('receivable', 'payable')")
openupgrade.rename_tables(cr, table_renames)
openupgrade.rename_columns(cr, column_renames)
openupgrade.copy_columns(cr, column_copies)
migrate_properties(cr)
def migrate(cr, version):
openupgrade.rename_models(cr, model_renames)
openupgrade.rename_tables(cr, table_renames)
openupgrade.rename_columns(cr, column_renames)
fix_data_on_l10n_ar_account(cr)
fix_data_on_l10n_ar_partner(cr)
delete_payment_views(cr)
def migrate(env, version):
openupgrade.copy_columns(env.cr, _column_copies)
openupgrade.rename_models(env.cr, _model_renames)
openupgrade.rename_tables(env.cr, _table_renames)
openupgrade.rename_fields(env, _field_renames)
openupgrade.rename_columns(env.cr, _column_renames)
openupgrade.rename_xmlids(env.cr, _xmlid_renames)
assure_stock_rule_company_is_correct(env)
def migrate(env, version):
cr = env.cr
openupgrade.rename_xmlids(cr, [
('sales_team.section_sales_department',
'sales_team.team_sales_department'),
])
openupgrade.rename_tables(cr, [('crm_case_section', 'crm_team')])
openupgrade.rename_models(cr, [('crm.case.section', 'crm.team')])
openupgrade.rename_fields(env, field_renames)
def migrate(env, version):
cr = env.cr
openupgrade.copy_columns(cr, column_copies)
openupgrade.rename_fields(env, field_renames)
# This should be run before table renames
openupgrade.rename_columns(env.cr, column_renames)
openupgrade.rename_tables(env.cr, table_renames)
map_order_state(cr)
purchase_invoice_lines(cr)
def migrate_account_analytic_distribution_pre(cr):
"""Prepare data for migrating OCA module."""
# Check if the module was installed in previous version checking the
# existence of one of its tables
if openupgrade.table_exists(cr, 'account_analytic_distribution'):
openupgrade.rename_tables(
cr,
[('account_analytic_distribution', None)],
)
def migrate(env, version):
cr = env.cr
if openupgrade.table_exists(cr, 'licence_licence'):
openupgrade.rename_models(cr, _model_renames)
if openupgrade.table_exists(cr, 'software_license'):
cr.execute("DROP TABLE software_license;")
if openupgrade.table_exists(cr, 'software_license_application'):
cr.execute("DROP TABLE software_license_application;")
openupgrade.rename_tables(cr, _table_renames)
def migrate(env, version):
cr = env.cr
if openupgrade.table_exists(
cr,
'account_account_history',
):
_create_partner_history(cr)
openupgrade.rename_models(cr, _model_renames)
openupgrade.rename_tables(cr, _table_renames)
def migrate(env, version):
cr = env.cr
fill_missing_delivery_grid_records(cr)
create_delivery_products(env)
correct_object_references(cr)
openupgrade.rename_columns(cr, column_renames)
openupgrade.rename_fields(env, field_renames)
correct_rule_prices(cr)
openupgrade.rename_tables(cr, table_renames)
def migrate(cr, version):
openupgrade.update_module_names(
cr,
[('email_template', 'mail')],
merge_modules=True,
)
openupgrade.rename_models(cr, model_renames)
openupgrade.rename_tables(cr, table_renames)
openupgrade.rename_columns(cr, column_renames)
def migrate(cr, version):
openupgrade.rename_xmlids(cr, [
('sales_team.section_sales_department',
'sales_team.team_sales_department'),
])
openupgrade.rename_tables(cr, [('crm_case_section', 'crm_team')])
openupgrade.rename_models(cr, [('crm.case.section', 'crm.team')])
openupgrade.rename_columns(
cr, {'res_users': [('default_section_id', 'sale_team_id')]})
def migrate(env, version):
cr = env.cr
if openupgrade.table_exists(env.cr, 'sale_quote_line'):
openupgrade.rename_columns(cr, _column_renames)
openupgrade.rename_fields(env, _field_renames)
put_in_correct_module(cr, _white_list_fields)
openupgrade.rename_models(cr, _model_renames)
openupgrade.rename_tables(cr, _table_renames)
fill_sale_order_template_line_sections(cr)
