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'
""",
)
