def map_account_tax_template_type(cr):
"""Same comments as in map_account_tax_type"""
openupgrade.map_values(cr,
openupgrade.get_legacy_name('type'),
'type', [('code', 'group')],
table='account_tax_template',
write='sql')
def res_lang_week_start_map_values(env):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name("week_start"),
"week_start",
[(1, "1"), (2, "2"), (3, "3"), (4, "4"), (5, "5"), (6, "6"), (7, "7")],
table="res_lang",
)
def map_project_project_rating_status(env):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name("rating_status"),
"rating_status",
[("no", "stage")],
table="project_project",
)
def deactivate_closed_accounts(cr):
# not using sql to restore account_type but map values
openupgrade.map_values(
cr, openupgrade.get_legacy_name('account_type'),
'active', [('closed', False), ('normal', True)],
table='account_analytic_account',
write='sql'
)
def map_stock_rule_action(cr):
openupgrade.map_values(cr,
openupgrade.get_legacy_name('action'),
'action', [
('move', 'pull'),
],
table='stock_rule',
write='sql')
def map_intrastat_product_declaration_month(env):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name("month"),
"month",
_months,
table="intrastat_product_declaration",
)
def map_account_journal_post_at_bank_rec(env):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('post_at_bank_rec'),
'post_at',
[(True, 'bank_rec')],
table='account_journal',
)
def map_res_company_fiscalyear_last_month(env):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('fiscalyear_last_month'),
'fiscalyear_last_month',
[(x, '%s' % x) for x in range(1, 13, 1)],
table='res_company',
)
def map_calendar_event_byday(env):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name("byday"),
"byday",
[("5", "-1")],
table="calendar_event",
)
def map_account_journal_bank_statements_source(cr):
openupgrade.map_values(
cr,
openupgrade.get_legacy_name('bank_statements_source'),
'bank_statements_source',
[('manual', 'undefined'),
],
table='account_journal', write='sql')
def migrate(env, version):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('timesheet_range'),
'timesheet_range',
[('day', 'month')],
table='res_company',
)
def update_receiptbook_type(env):
cr = env.cr
openupgrade.map_values(
cr,
'type', 'partner_type',
# openupgrade.get_legacy_name('type'), 'partner_type',
[('receipt', 'customer'), ('payment', 'supplier')],
table='account_payment_receiptbook', write='sql')
def res_company_sheet_range_map_values(env):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name("sheet_range"),
"sheet_range",
[(MONTHLY, "MONTHLY"), (WEEKLY, "WEEKLY"), (DAILY, "DAILY")],
table="res_company",
)
def set_company_loc_ar(cr):
_logger.info('Setting loc ar on companies')
openupgrade.map_values(
cr,
# openupgrade.get_legacy_name('type_tax_use'), 'localization',
'use_argentinian_localization', 'localization',
# [('all', 'none')],
[(True, 'argentina')],
table='res_company', write='sql')
def map_track_service(env):
""""Map values for old `track_service` field (copied in sale pre-migration)
according this mapping:
track_service service_tracking
------------- ----------------
'manual' 'no'
'task' if not project_id: 'task_new_project'
if project_id: 'task_global_project'
'timesheet' 'project_only'
Project field depends on company, so this is applicable as soon as one
company has any project set.
"""
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('track_service'),
'service_tracking', [
('manual', 'no'),
('timesheet', 'project_only'),
], table='product_template',
)
# Need to be done through subquery as unique option for proper joining
openupgrade.logged_query(
env.cr, """
UPDATE product_template pt
SET service_tracking = 'task_new_project'
FROM (
SELECT pt.id FROM
product_template pt
JOIN ir_model_fields imf ON imf.name = 'project_id'
AND imf.model = 'product.template'
LEFT JOIN ir_property ip ON ip.fields_id = imf.id
AND ip.res_id = 'product.template,' || pt.id::text
WHERE pt.%s = 'task'
AND ip.value_reference IS NULL
) sub
WHERE sub.id = pt.id""",
(AsIs(openupgrade.get_legacy_name('track_service')), ),
)
openupgrade.logged_query(
env.cr, """
UPDATE product_template pt
SET service_tracking = 'task_global_project'
FROM (
SELECT pt.id FROM
product_template pt
JOIN ir_model_fields imf ON imf.name = 'project_id'
AND imf.model = 'product.template'
LEFT JOIN ir_property ip ON ip.fields_id = imf.id
AND ip.res_id = 'product.template,' || pt.id::text
WHERE pt.%s = 'task'
AND ip.value_reference IS NOT NULL
) sub
WHERE sub.id = pt.id""",
(AsIs(openupgrade.get_legacy_name('track_service')), ),
)
def migrate(env, version):
openupgrade.copy_columns(env.cr, _column_copies)
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('type'),
'type',
[('datetime', 'date')],
table='survey_question',
)
def map_payment_transaction_state(cr):
openupgrade.map_values(cr,
openupgrade.get_legacy_name('state'),
'state', [
('refunding', 'cancel'),
('refunded', 'cancel'),
],
table='payment_transaction',
write='sql')
def migrate(env, version):
openupgrade.copy_columns(env.cr, _column_copies)
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('measure_type'),
'measure_type',
[('time', 'working_time')],
table='uom_category',
)
def map_stock_location_usage(env):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('usage'),
'usage',
[('procurement', 'transit'),
],
table='stock_location',
)
def set_company_loc_ar(env):
cr = env.cr
openupgrade.map_values(
cr,
# openupgrade.get_legacy_name('type_tax_use'), 'localization',
'use_argentinian_localization', 'localization',
# [('all', 'none')],
[(True, 'argentina')],
table='res_company', write='sql')
def map_snailmail_letter_state(env):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('state'),
'state',
[('draft', 'pending'),
],
table='snailmail_letter',
)
def map_account_tax_type(cr):
""" The tax type 'code' is not an option in the account module for v9.
We need to assign a temporary 'dummy' value until module
account_tax_python is installed. In post-migration we will
restore the original value."""
openupgrade.map_values(cr,
openupgrade.get_legacy_name('type'),
'type', [('code', 'group')],
table='account_tax',
write='sql')
def map_journal_state(cr):
openupgrade.map_values(
cr,
openupgrade.get_legacy_name('type'), 'type',
[
('purchase_refund', 'purchase'),
('sale_refund', 'sale'),
('situation', 'general'),
],
table='account_journal', write='sql')
def migrate(env, version):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('category'),
'category',
[('both', 'contract')],
table='fleet_service_type',
)
# Update state of all the contracts
env['fleet.vehicle.log.contract'].scheduler_manage_contract_expiration()
def map_product_template_type(cr):
""" The product template type value 'stockable' is not an option in the
product module for v9. We need to assign a temporary 'dummy' value
until module stock is installed. In post-migration we will
restore the original value."""
openupgrade.map_values(cr,
openupgrade.get_legacy_name('type'),
'type', [('product', 'consu')],
table='product_template',
write='sql')
def map_mail_notification_type(env):
openupgrade.map_values(
env.cr,
openupgrade.get_legacy_name('service_tracking'),
'service_tracking',
[
('task_new_project', 'task_in_project'),
],
table='product_template',
)
def migrate(cr, version):
openupgrade.rename_columns(cr, _column_renames)
cr.execute(
# we rely on the ORM to write this value
'alter table ir_model_fields add column store boolean')
openupgrade.copy_columns(cr, {
'ir_act_window': [
('target', None, None),
],
})
openupgrade.map_values(cr,
openupgrade.get_legacy_name('target'),
'target', [
('inlineview', 'inline'),
],
table='ir_act_window')
cr.execute(
"update ir_ui_view set type='kanban' where type='sales_team_dashboard'"
)
cr.execute('update res_currency set symbol=name where symbol is null')
# create xmlids for installed languages
cr.execute('''insert into ir_model_data
(module, name, model, res_id)
select
'base',
'lang_' ||
case
when char_length(code) > 2 then
case
when upper(substring(code from 1 for 2)) =
upper(substring(code from 4 for 2)) then
substring(code from 1 for 2)
else
code
end
else
code
end,
'res.lang', id
from res_lang''')
openupgrade.update_module_names(
cr,
[
('account_full_reconcile', 'account'),
('project_timesheet', 'hr_timesheet'),
('share', 'base'),
('web_tip', 'web'),
('web_view_editor', 'web'),
('mail_tip', 'mail'),
('im_odoo_support', 'im_livechat'),
# OCA/sale-workflow
('sale_order_back2draft', 'sale'),
],
merge_modules=True,
)
def migrate(cr, version):
openupgrade.load_data(cr, 'hr_recruitment',
'migrations/9.0.1.0/noupdate_changes.xml')
openupgrade.map_values(cr,
openupgrade.get_legacy_name('priority'),
'priority', [('1', '0'), ('2', '0'), ('3', '1'),
('4', '3')],
table='hr_applicant',
write='sql')
update_applicant_availability(cr)
migrate_applicant_source(cr)
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
uid = SUPERUSER_ID
openupgrade_80.set_message_last_post(cr, uid, pool, ['crm.claim'])
openupgrade.map_values(cr,
'priority',
openupgrade.get_legacy_name('priority'),
[('1', '2'), ('3', '1'), ('4', '0'), ('5', '0')],
table='crm_claim')
openupgrade.load_data(cr, 'crm_claim',
'migrations/8.0.1.0/noupdate_changes.xml')
def map_training_participant(env):
openupgrade.map_values(
env.cr,
"state",
"state",
[
("absence", "draft"),
],
table="hr_training_partisipant",
write="sql",
)
