def put_in_correct_module(cr, white_list):
# avoid ir_model_data_module_name_uniq_index error
# because the module of this white fields were sale_quotation_builder
for model in white_list:
openupgrade.update_module_moved_fields(
cr, model, white_list[model],
'sale_quotation_builder', 'sale_management')
def migrate(env, version):
copy_global_rules(env)
delete_quants_for_consumable(env)
openupgrade.update_module_moved_fields(
env.cr,
'stock.move',
['has_tracking'],
'mrp',
'stock',
)
openupgrade.update_module_moved_fields(
env.cr,
'stock.move',
['quantity_done'],
'mrp',
'stock',
)
openupgrade.rename_fields(env, [
('stock.quant', 'stock_quant', 'qty', 'quantity'),
])
openupgrade.copy_columns(
env.cr,
{
'stock_picking': [
('state', None, None),
],
},
)
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('state'),
'state',
[('partially_available', 'assigned')],
table='stock_picking',
)
def migrate(env, version):
openupgrade.copy_columns(env.cr, COLUMN_COPIES)
openupgrade.rename_xmlids(env.cr, _xmlid_renames)
openupgrade.rename_xmlids(env.cr, _portal_xmlid_renames)
openupgrade.rename_xmlids(env.cr, _portal_sale_xmlid_renames)
xml_ids_to_remove = [
'sale_payment.orders_followup',
'sale.portal_personal_contact',
]
for xml_id in xml_ids_to_remove:
try:
with env.cr.savepoint():
env.ref(xml_id).unlink()
except Exception:
pass
openupgrade.update_module_moved_fields(
env.cr,
'sale.order',
['procurement_group_id'],
'sale',
'sale_stock',
)
openupgrade.add_fields(env, [
('amt_invoiced', 'sale.order.line', 'sale_order_line', 'monetary',
False, 'sale'),
('amt_to_invoice', 'sale.order.line', 'sale_order_line', 'monetary',
False, 'sale'),
])
def migrate(cr, version):
if not version:
return
# Move t_shirt field from module
openupgrade.update_module_moved_fields(cr, 'ambassador.details',
['t_shirt_size'], 'muskathlon',
'partner_compassion')
def migrate(cr, version):
if not version:
return
# Move t_shirt field from module
openupgrade.update_module_moved_fields(
cr, 'ambassador.details', ['t_shirt_size'], 'muskathlon',
'partner_compassion')
def migrate(env, version):
if not version:
return
# Move fields in module website_event_compassion
openupgrade.update_module_moved_fields(env.cr, 'crm.event.compassion', [
'website_description', 'picture_1', 'filename_1', 'registration_fee',
'website_side_info'
], 'muskathlon', 'website_event_compassion')
def migrate(env, version):
openupgrade.update_module_moved_fields(env.cr, 'event.event',
['twitter_hashtag'],
'website_event', 'event')
migrate_auto_confirm(env)
migrate_reply_to(env)
openupgrade.load_data(
env.cr,
'event',
'migrations/11.0.1.0/noupdate_changes.xml',
)
def migrate(env, version):
openupgrade.rename_tables(env.cr, _table_renames)
openupgrade.rename_fields(env, _field_renames)
openupgrade.rename_columns(env.cr, _column_renames)
openupgrade.copy_columns(env.cr, _column_copies)
openupgrade.rename_xmlids(env.cr, _xmlid_renames)
openupgrade.update_module_moved_fields(
env.cr, "sale.order", ["campaign_id", "medium_id", "source_id"], "sale_crm", "sale"
)
openupgrade.add_fields(
env, [("company_id", "utm.campaign", False, "many2one", False, "sale")],
)
nullify_invoiced_target_when_not_used(env)
def put_in_correct_module(cr, white_list):
# avoid ir_model_data_module_name_uniq_index error
# because the module of this white fields were sale_quotation_builder
for model in white_list:
openupgrade.update_module_moved_fields(
cr, model, white_list[model],
'sale_quotation_builder', 'sale_management')
openupgrade.logged_query(
cr, """
UPDATE ir_model_data
SET module = 'sale_management'
WHERE name = %s""", ('model_' + _white_list_models[model], ),
)
def migrate(env, version):
if not version:
return
# Move fields from muskathlon module
openupgrade.update_module_moved_fields(
env.cr,
'crm.event.compassion',
[
'participants_amount_objective',
'thank_you_text',
],
'muskathlon',
'website_event_compassion',
)
openupgrade.update_module_moved_fields(env.cr, 'event.registration', [
'amount_objective',
'website_published',
], 'muskathlon', 'website_event_compassion')
openupgrade.update_module_moved_fields(env.cr, 'account.invoice.line', [
'registration_id',
], 'muskathlon', 'website_event_compassion')
openupgrade.update_module_moved_fields(env.cr, 'res.partner', [
'registration_ids',
], 'muskathlon', 'website_event_compassion')
def move_fields_from_module(env):
openupgrade.update_module_moved_fields(
env.cr, 'project.project', ['subtask_project_id'],
'hr_timesheet', 'project',
)
openupgrade.update_module_moved_fields(
env.cr, 'project.task', [
'child_ids',
'parent_id',
'subtask_count',
'subtask_project_id',
],
'hr_timesheet', 'project',
)
def migrate(env, version):
delete_quants_for_consumable(env)
remove_company_for_quants_in_vendor_customer(env)
fix_act_window(env)
openupgrade.update_module_moved_fields(
env.cr,
'stock.move',
['has_tracking'],
'mrp',
'stock',
)
openupgrade.update_module_moved_fields(
env.cr,
'stock.move',
['quantity_done'],
'mrp',
'stock',
)
openupgrade.rename_fields(env, [
('stock.quant', 'stock_quant', 'qty', 'quantity'),
])
openupgrade.copy_columns(
env.cr,
{
'stock_picking': [
('state', None, None),
],
},
)
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('state'),
'state',
[('partially_available', 'assigned')],
table='stock_picking',
)
openupgrade.add_fields(
env,
[
('reference', 'stock.move', 'stock_move', 'char', False, 'stock'),
('scheduled_date', 'stock.picking', 'stock_picking', 'date', False,
'stock'),
],
)
openupgrade.set_xml_ids_noupdate_value(env, 'stock', [
'barcode_rule_location',
'barcode_rule_lot',
'barcode_rule_package',
'barcode_rule_weight_three_dec',
], True)
def migrate(env, version):
if not version:
return
# Move field ambassador quote from module Muskathlon
openupgrade.update_module_moved_fields(
env.cr, 'res.partner', ['ambassador_quote'], 'muskathlon',
'partner_compassion')
# Add field to track ambassadors migrated
env.cr.execute("""
ALTER TABLE res_partner ADD COLUMN quote_migrated boolean;
""")
# Move ambassador quote field into new table, ignoring empty html
_split_ambassador_quote(env)
def migrate(cr, version):
if not version:
return
# Move fields in another module
openupgrade.update_module_moved_fields(
cr, 'account.invoice', ['invoice_type'], 'sponsorship_switzerland',
'sponsorship_compassion')
openupgrade.update_module_moved_fields(
cr, 'res.partner',
['is_church', 'church_id', 'church_member_count', 'member_ids'],
'partner_compassion', 'sponsorship_compassion')
openupgrade.rename_xmlids(
cr,
[('partner_compassion.res_partner_category_church',
'sponsorship_compassion.res_partner_category_church')])
def migrate(cr, version):
if not version:
return
# Move fields in another module
openupgrade.update_module_moved_fields(cr, 'account.invoice',
['invoice_type'],
'sponsorship_switzerland',
'sponsorship_compassion')
openupgrade.update_module_moved_fields(
cr, 'res.partner',
['is_church', 'church_id', 'church_member_count', 'member_ids'],
'partner_compassion', 'sponsorship_compassion')
openupgrade.rename_xmlids(
cr, [('partner_compassion.res_partner_category_church',
'sponsorship_compassion.res_partner_category_church')])
def migrate(env, version):
openupgrade.update_module_moved_fields(env.cr, 'product.template',
['hs_code'], 'delivery',
'delivery_hs_code')
openupgrade.update_module_moved_fields(
env.cr,
'product.product',
['hs_code'],
'delivery',
'delivery_hs_code',
)
openupgrade.rename_columns(env.cr, RENAMED_COLUMNS)
openupgrade.delete_records_safely_by_xml_id(
env,
['delivery.mail_template_data_delivery_notification'],
)
def check_optional_products(env):
"""Don't lose this feature if used."""
env.cr.execute("SELECT COUNT(*) FROM product_optional_rel")
if env.cr.fetchone()[0] > 0:
module = env["ir.module.module"].search([
("name", "=", "sale_product_configurator")
])
if module.state == "uninstalled":
module.write({"state": "to install"})
openupgrade.update_module_moved_fields(env.cr, "product.product",
["optional_product_ids"],
"sale",
"sale_product_configurator")
openupgrade.update_module_moved_fields(env.cr, "product.template",
["optional_product_ids"],
"sale",
"sale_product_configurator")
def update_module_moved_fields(env):
if not openupgrade.is_module_installed(env.cr, "hr_timesheet"):
return
openupgrade.update_module_moved_fields(
env.cr,
"account.analytic.account",
["project_count", "project_ids"],
"hr_timesheet",
"project",
)
openupgrade.update_module_moved_fields(
env.cr,
"project.project",
["analytic_account_id"],
"hr_timesheet",
"project",
)
def migrate(env, version):
copy_global_rules(env)
delete_quants_for_consumable(env)
drop_slow_constraint(env)
fix_act_window(env)
openupgrade.update_module_moved_fields(
env.cr,
'stock.move',
['has_tracking'],
'mrp',
'stock',
)
openupgrade.update_module_moved_fields(
env.cr,
'stock.move',
['quantity_done'],
'mrp',
'stock',
)
openupgrade.rename_fields(env, [
('stock.quant', 'stock_quant', 'qty', 'quantity'),
])
openupgrade.copy_columns(
env.cr,
{
'stock_picking': [
('state', None, None),
],
},
)
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('state'),
'state',
[('partially_available', 'assigned')],
table='stock_picking',
)
openupgrade.add_fields(
env,
[
('reference', 'stock.move', 'stock_move', 'char', False, 'stock'),
('scheduled_date', 'stock.picking', 'stock_picking', 'date', False,
'stock'),
],
)
def migrate(env, version):
openupgrade.rename_xmlids(env.cr, _xmlid_renames)
openupgrade.rename_xmlids(env.cr, _portal_xmlid_renames)
openupgrade.rename_xmlids(env.cr, _portal_sale_xmlid_renames)
xml_ids_to_remove = [
'sale_payment.orders_followup',
'sale.portal_personal_contact',
]
for xml_id in xml_ids_to_remove:
try:
with env.cr.savepoint():
env.ref(xml_id).unlink()
except Exception:
pass
openupgrade.update_module_moved_fields(
env.cr,
'sale.order',
['procurement_group_id'],
'sale',
'sale_stock',
)
def migrate(env, version):
openupgrade.update_module_moved_fields(
env.cr, 'stock.move', ['remaining_qty'], 'stock', 'stock_account',
)
update_fifo_cost_method(env)
rename_to_refund_so(env)
def migrate(env, version):
openupgrade.update_module_moved_fields(
env.cr, 'delivery.carrier', ['website_published', 'website_url'],
'website_sale', 'website_sale_delivery')
