def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
create_workitem_picking(cr, uid, pool)
migrate_product_supply_method(cr)
migrate_procurement_order(cr)
migrate_stock_warehouse(cr, pool)
openupgrade_80.set_message_last_post(cr, uid, pool, ['purchase.order'])
def migrate(cr, version):
"""
It can be the case that procurement was not installed in the 7.0 database,
as in 7.0 stock was a dependency of procurement and not the other way
around like it is in 8.0. So we need to check if we are migrating a
database in which procurement related stuff needs to be migrated.
"""
registry = RegistryManager.get(cr.dbname)
populate_stock_move_fields(cr, registry)
have_procurement = openupgrade.column_exists(
cr, 'product_template', openupgrade.get_legacy_name('procure_method'))
migrate_stock_warehouses(cr, registry)
migrate_stock_picking(cr, registry)
migrate_stock_location(cr, registry)
if have_procurement:
migrate_stock_warehouse_orderpoint(cr)
migrate_product_supply_method(cr, registry)
migrate_procurement_order(cr, registry)
migrate_stock_qty(cr, registry)
migrate_stock_production_lot(cr, registry)
# Initiate defaults before filling.
openupgrade.set_defaults(cr, registry, default_spec, force=False)
migrate_product(cr, registry)
openupgrade.delete_model_workflow(cr, 'stock.picking')
openupgrade_80.set_message_last_post(
cr, uid, registry, ['stock.production.lot', 'stock.picking'])
migrate_move_inventory(cr, registry)
reset_warehouse_data_ids(cr, registry)
def migrate(cr, version):
recompute_date_fields(cr)
import_crm_meeting(cr)
# now we filled new fields, recalculate some stored fields
pool = RegistryManager.get(cr.dbname)
calendar_event = pool['calendar.event']
for field in ['start', 'stop', 'display_start']:
calendar_event._update_store(cr, calendar_event._columns[field], field)
migrate_attendees(cr)
migrate_alarms(cr)
# map renamed and deprecated reminder actions to 'notification'
cr.execute('''update calendar_alarm
set type='notification'
where type in ('audio', 'display', 'procedure')''')
# map renamed event states
cr.execute('''update calendar_event
set state='draft' where state in ('cancelled', 'tentative')''')
cr.execute('''update calendar_event
set state='open' where state in ('confirmed')''')
# map renamed attendee states
cr.execute('''update calendar_attendee
set state='needsAction' where state in ('needs-action')''')
# load modified noupdate data
openupgrade.load_data(cr, 'calendar', 'migrations/8.0.1.0/data.xml')
openupgrade_80.set_message_last_post(cr, SUPERUSER_ID, pool,
['calendar.event'])
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
uid = SUPERUSER_ID
openupgrade_80.set_message_last_post(
cr, uid, pool, ['account.bank.statement', 'account.invoice']
)
update_link_to_moves(cr)
def migrate(cr, version):
if not openupgrade.is_module_installed(cr, 'crm'):
logger.info(
"sales_team post-migration skipped, because crm is not installed")
return
pool = pooler.get_pool(cr.dbname)
uid = SUPERUSER_ID
openupgrade_80.set_message_last_post(cr, uid, pool, ['crm.case.section'])
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
post_messages(cr, pool)
openupgrade_80.set_message_last_post(cr, SUPERUSER_ID, pool,
['procurement.order'])
process_states(cr)
openupgrade.load_data(cr, 'procurement',
'migrations/8.0.1.0/noupdate_changes.xml')
def migrate(cr, version):
registry = RegistryManager.get(cr.dbname)
openupgrade.load_data(cr, 'sale',
'migrations/8.0.1.0/noupdate_changes.xml')
openupgrade_80.set_message_last_post(cr, SUPERUSER_ID, registry,
['sale.order'])
openupgrade.date_to_datetime_tz(cr, 'sale_order', 'user_id',
openupgrade.get_legacy_name('date_order'),
'date_order')
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
map_notify_email(cr)
mail_mail_to_mail_message_migration(cr, uid, pool)
openupgrade_80.set_message_last_post(
cr, uid, pool, ['res.partner', 'mail.group'])
openupgrade_80.update_aliases(cr, pool, 'mail.group', True)
openupgrade_80.update_aliases(cr, pool, 'res.users', True)
openupgrade.load_data(
cr, 'mail', 'migrations/8.0.1.0/noupdate_changes.xml')
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
uid = SUPERUSER_ID
openupgrade_80.set_message_last_post(cr, uid, pool, ['hr.expense.expense'])
openupgrade.move_field_m2o(cr,
pool,
'product.product',
openupgrade.get_legacy_name('hr_expense_ok'),
'product_tmpl_id',
'product.template',
'hr_expense_ok',
compute_func=hr_expense_ok_field_func)
def migrate(cr, version):
pool = RegistryManager.get(cr.dbname)
openupgrade.map_values(cr,
openupgrade.get_legacy_name('priority'),
'priority', [('5', '0'), ('4', '0'), ('3', '1'),
('2', '2'), ('1', '2')],
table='project_issue',
write='sql')
openupgrade_80.set_message_last_post(cr, uid, pool, ['project.issue'])
openupgrade.load_data(cr, 'project_issue',
'migrations/8.0.1.0/noupdate_changes.xml')
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
bom_product_template(cr)
migrate_bom_lines(cr, pool)
fix_domains(cr, pool)
update_stock_moves(cr, pool)
update_stock_picking_name(cr, pool)
migrate_product_supply_method(cr, pool)
migrate_product(cr, pool)
migrate_stock_warehouse(cr, pool)
migrate_procurement_order(cr, pool)
openupgrade_80.set_message_last_post(
cr, uid, pool,
['mrp.bom', 'mrp.production', 'mrp.production.workcenter.line'])
def migrate(cr, version):
registry = RegistryManager.get(cr.dbname)
openupgrade.map_values(
cr, 'priority', openupgrade.get_legacy_name('priority'),
[('5', '0'), ('4', '1'), ('3', '2'), ('2', '3'), ('1', '4')],
table='crm_lead')
openupgrade.map_values(
cr, 'priority', openupgrade.get_legacy_name('priority'),
[('5', '0'), ('4', '0'), ('3', '1'), ('1', '2')],
table='crm_phonecall')
openupgrade.logged_query(
cr, "UPDATE crm_phonecall SET state = %s WHERE state = %s",
('draft', 'pending'))
# Set the date of the last update
subtype_ids = (
registry['ir.model.data'].get_object_reference(
cr, SUPERUSER_ID, 'crm', 'mt_lead_stage')[1],
registry['ir.model.data'].get_object_reference(
cr, SUPERUSER_ID, 'crm', 'mt_salesteam_lead_stage')[1])
# Update event tracking datetime fields
openupgrade_80.set_message_last_post(
cr, SUPERUSER_ID, registry, ['crm.phonecall', 'crm.lead'])
openupgrade.logged_query(
cr,
"""
UPDATE crm_lead l
SET date_last_stage_update = COALESCE(
(SELECT MAX(create_date) FROM mail_message m
WHERE subtype_id in %s
AND m.res_id = l.id),
l.create_date)
""", (subtype_ids,))
# Move opportunity and phonecall to matching calendar_event
openupgrade.logged_query(
cr,
"""
UPDATE calendar_event e
SET opportunity_id = m.opportunity_id,
phonecall_id = m.phonecall_id
FROM crm_meeting m
WHERE e.{} = m.id""".format(
openupgrade.get_legacy_name('crm_meeting_id')))
openupgrade.load_data(cr, 'crm', 'migrations/8.0.1.0/noupdate_changes.xml')
def migrate(cr, version):
with api.Environment.manage():
env = api.Environment(cr, SUPERUSER_ID, {})
pool = pooler.get_pool(cr.dbname)
bom_product_template(cr)
migrate_bom_lines(cr, pool)
fix_domains(cr, pool)
update_stock_moves(env)
update_stock_picking_name(cr, pool)
migrate_product_supply_method(cr, pool)
migrate_product(cr, pool)
migrate_stock_warehouse(cr, pool)
migrate_procurement_order(cr, pool)
openupgrade_80.set_message_last_post(
cr, SUPERUSER_ID, pool,
['mrp.bom', 'mrp.production', 'mrp.production.workcenter.line'])
def migrate(cr, version):
registry = RegistryManager.get(cr.dbname)
openupgrade.map_values(cr,
openupgrade.get_legacy_name('priority'),
'priority', [('4', '0'), ('3', '0'), ('2', '1'),
('1', '2'), ('0', '2')],
table='project_task',
write='sql')
openupgrade_80.update_aliases(cr,
registry,
'project.project',
set_parent_thread_id=True,
defaults_id_key='project_id')
openupgrade_80.set_message_last_post(cr, uid, registry,
['project.project', 'project.task'])
openupgrade.load_data(cr, 'project',
'migrations/8.0.1.1/noupdate_changes.xml')
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
uid = SUPERUSER_ID
openupgrade_80.set_message_last_post(cr, uid, pool, ['hr.expense.expense'])
update_hr_expense_ok(cr, pool)
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
set_message_last_post(cr, SUPERUSER_ID, pool,
['event.event', 'event.registration'])
convert_field_to_html(cr, 'event_event', get_legacy_name('note'),
'description')
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
openupgrade_80.set_message_last_post(cr, SUPERUSER_ID, pool,
['hr.job', 'hr.employee'])
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
openupgrade_80.set_message_last_post(
cr, SUPERUSER_ID, pool, ['hr.job', 'hr.employee'])
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
uid = SUPERUSER_ID
openupgrade_80.set_message_last_post(cr, uid, pool, ["fleet.vehicule"])
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
uid = SUPERUSER_ID
openupgrade_80.set_message_last_post(
cr, uid, pool, ['fleet.vehicule']
)
def migrate(cr, version):
openupgrade_80.set_message_last_post(cr, SUPERUSER_ID,
RegistryManager.get(cr.dbname),
['hr.holidays'])
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
uid = SUPERUSER_ID
openupgrade_80.set_message_last_post(
cr, uid, pool, ['crm.case.section']
)
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
uid = SUPERUSER_ID
openupgrade_80.set_message_last_post(
cr, uid, pool, ['account.voucher']
)
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
uid = SUPERUSER_ID
openupgrade_80.set_message_last_post(cr, uid, pool,
['account.analytic.account'])
