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.copy_columns(env.cr, column_copies) openupgrade.rename_columns(env.cr, column_renames) openupgrade.rename_models(env.cr, model_renames_ir_actions_report) env.cr.execute("""UPDATE ir_actions SET type = 'ir.actions.report' WHERE type = 'ir.actions.report.xml'""") rule_xml_ids = ('ir_config_parameter_rule', 'ir_values_default_rule') env.cr.execute( """ DELETE FROM ir_rule WHERE id IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name IN %s) """, (rule_xml_ids, )) env.cr.execute( """ DELETE FROM ir_model_data WHERE module = 'base' AND name IN %s """, (rule_xml_ids, )) # All existing server actions are of type server action env.cr.execute(""" ALTER TABLE ir_act_server ADD COLUMN usage VARCHAR; UPDATE ir_act_server SET usage = 'ir_actions_server'""") # For some window actions, there is a value in the old column # that was inherited from ir_actions before env.cr.execute( """ ALTER TABLE ir_act_window ADD COLUMN usage VARCHAR; UPDATE ir_act_window SET usage = %s""", (AsIs(openupgrade.get_legacy_name('usage')), )) # work_days interval was removed from selection values env.cr.execute(""" UPDATE ir_cron SET interval_type = 'days' WHERE interval_type = 'work_days'""")
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 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(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 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_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): 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): 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(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): 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): 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(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): 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): 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(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(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(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(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 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 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)
def migrate(env, version): # Deactivate the noupdate flag (hardcoded on initial SQL load) for allowing # to update changed data on this group. openupgrade.logged_query( env.cr, """ UPDATE ir_model_data SET noupdate=False WHERE module='base' AND name='group_user'""", ) openupgrade.update_module_names(env.cr, apriori.renamed_modules.items()) openupgrade.update_module_names(env.cr, apriori.merged_modules.items(), merge_modules=True) if openupgrade.table_exists(env.cr, 'product_uom'): openupgrade.rename_models(env.cr, model_renames_product) openupgrade.rename_tables(env.cr, table_renames_product) if openupgrade.table_exists(env.cr, 'stock_incoterms'): openupgrade.rename_models(env.cr, model_renames_stock) openupgrade.rename_tables(env.cr, table_renames_stock) openupgrade.rename_xmlids(env.cr, xmlid_renames) switch_noupdate_flag(env) 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. # Safely, we check first if the `base.user_admin` already exists to # avoid possible conflicts: very old databases may have this record. env.cr.execute(""" SELECT id FROM ir_model_data WHERE name='user_admin' AND module='base' AND model='res.users'""") if env.cr.fetchone(): env.cr.execute(""" UPDATE ir_model_data SET model='res.users',res_id=1,noupdate=true WHERE name='user_admin' AND module='base' AND model='res.users'""") else: 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) # fast compute of res_model_name fill_ir_attachment_res_model_name(env.cr) # for migration of web module openupgrade.rename_columns( env.cr, {'res_company': [('external_report_layout', None)]}) # for migration of website module fill_ir_ui_view_key(env.cr)
def migrate(cr, version): # muchos errores en invoice_views, borramos todo con remove_views en # base upgrade 9.0.1.4 # delete_invoice_views(cr) # delete_payment_views(cr) openupgrade.rename_models(cr, model_renames) openupgrade.rename_tables(cr, table_renames) # openupgrade.copy_columns(cr, column_copies) openupgrade.rename_columns(cr, column_renames) fix_data_on_l10n_ar_account(cr)
def migrate(env, version): openupgrade.rename_models( env.cr, [("email_template.preview", "mail.template.preview")] ) openupgrade.rename_tables( env.cr, [("email_template_preview", "mail_template_preview")] ) openupgrade.set_xml_ids_noupdate_value(env, "mail", ["mail_channel_rule"], True) openupgrade.rename_columns(env.cr, {"mail_tracking_value": [("field", None)]}) fill_mail_tracking_value_field(env)
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) fill_inventory_line_categ(env) prefill_stock_picking_type_sequence_code(env)
def migrate(cr, version): """Update database from previous versions, after updating module.""" openupgrade.rename_tables(cr=cr, table_spec=[('locomotive_backend', 'shopinvader_backend')]) openupgrade.rename_models(cr=cr, model_spec=[('locomotive.backend', 'shopinvader.backend')]) # remove blocking view cr.execute("""DELETE FROM ir_ui_view WHERE arch_db ilike '%locomotive_backend_ids%'""")
def pre_init_hook(cr): """If coming from v9 where only `sale_exception` is installed, when auto-installing this one by dependencies, we should take care of renaming previous table before the new model is loaded. """ cr.execute("SELECT 1 FROM pg_class WHERE relname = 'sale_exception'") if not cr.fetchone(): return # fresh install, so exiting from openupgradelib import openupgrade openupgrade.rename_tables(cr, [('sale_exception', 'exception_rule')]) openupgrade.rename_models(cr, [('sale.exception', 'exception.rule')])
def migrate(env, version): openupgrade.rename_models(env.cr, _model_renames) openupgrade.rename_tables(env.cr, _table_renames) env.cr.execute( "update ir_model_data set module = 'l10n_br_eletronic_document' where name like 'cfop_%' and model = 'nfe.cfop'" ) env.cr.execute( "update ir_model_data set module = 'l10n_br_eletronic_document' where name like 'l10n_br_cnae%' and model = 'account.cnae'" ) env.cr.execute( "update ir_model_data set module = 'l10n_br_eletronic_document' where name like 'service_type_%' and model = 'account.service.type'" )
def migrate(env, version): openupgrade.rename_models(env.cr, _model_renames) openupgrade.rename_fields(env, _field_renames) # Fix image of mail.channel after renaming column to image_128 openupgrade.logged_query( env.cr, """ UPDATE ir_attachment SET res_field = 'image_128' WHERE res_field = 'image' and res_model = 'mail.channel' """, )