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)