def migrate(cr, installed_version):
if not installed_version:
return
# Update is_first_sponsorship
cr.execute("""
UPDATE recurring_contract c
SET is_first_sponsorship = true
FROM res_partner p
WHERE p.id = correspondent_id
AND p.number_sponsorships = 0
AND c.state in ('waiting','mandate')
AND c.child_id IS NOT NULL;
""")
# Update data
openupgrade.load_xml(cr, "partner_communication_switzerland",
"data/onboarding_process.xml")
# Update New Dossier communication
cr.execute("""
UPDATE partner_communication_config
SET attachments_function = 'get_print_dossier_attachments'
WHERE id IN (19,99,192);
""")
def migrate(cr, version):
if not version:
return
# Force loading new reports
openupgrade.load_xml(cr, "report_compassion",
"report/partner_communication.xml")
def migrate(cr, version):
if not version:
return
# Force reloading security groups
openupgrade.load_xml(cr, "message_center_compassion",
"security/gmc_groups.xml")
def migrate(cr, version):
pool = pooler.get_pool(cr.dbname)
#migrate_invoice_addresses(cr, pool)
migrate_invoice_names(cr, pool)
lock_closing_reconciliations(cr, pool)
migrate_payment_term(cr, pool)
merge_account_cashbox_line(cr, pool)
openupgrade.load_xml(cr, 'account', 'migrations/7.0.1.1/data.xml')
def migrate(env, version):
if not version:
return
openupgrade.load_xml(
env.cr,
"partner_communication_switzerland",
"data/sponsorship_action_rules.xml"
)
def migrate(cr, installed_version):
if not installed_version:
return
# Copy start_date over onboarding_start_date
cr.execute("""
UPDATE recurring_contract
SET onboarding_start_date = start_date
WHERE is_first_sponsorship = true
""")
# Update data
openupgrade.load_xml(cr, "partner_communication_switzerland",
"data/onboarding_process.xml")
def post_init_hook(cr, registry):
"""
Fix some demo data to work with
https://github.com/shopinvader/shopinvader-getting-started
"""
openupgrade.load_xml(
cr,
"shopinvader_demo_app",
"demo/se_backend_elasticsearch_demo.xml",
mode="init",
)
openupgrade.load_xml(
cr,
"shopinvader_demo_app",
"demo/storage_backend_demo.xml",
mode="init",
)
def migrate(cr, version):
if not version:
return
# Force loading new BVR reports
openupgrade.load_xml(cr, "report_compassion", "report/bvr_gift.xml")
openupgrade.load_xml(cr, "report_compassion", "report/bvr_layout.xml")
openupgrade.load_xml(cr, "report_compassion", "report/bvr_sponsorship.xml")
def migrate(cr, version):
if not version:
return
# Force upgrade the reports
openupgrade.load_xml(cr, "report_compassion", "report/childpack.xml")
def migrate(cr, installed_version):
if not installed_version:
return
openupgrade.load_xml(cr, 'partner_communication_switzerland',
'data/sponsorship_action_rules.xml')
def migrate(cr, installed_version):
if not installed_version:
return
openupgrade.load_xml(cr, 'sbc_switzerland', 'data/translator_action_rules.xml')
def migrate(env, version):
if not version:
return
openupgrade.load_xml(env.cr, "sbc_switzerland",
"data/translator_action_rules.xml")
def migrate(cr, version):
if not version:
return
openupgrade.load_xml(cr, 'partner_communication_switzerland',
'report/child_picture.xml')
def migrate(cr, installed_version):
if not installed_version:
return
openupgrade.load_xml(cr, 'crm_compassion', 'data/demand_planning.xml')
def migrate(cr, version):
if not version:
return
openupgrade.load_xml(cr, "payment_ogone_compassion",
"data/payment_icon.xml")
def migrate(env, installed_version):
if not installed_version:
return
env.cr.execute(
"update firebase_notification set stage_id=4 where sent=True")
openupgrade.load_xml(env.cr, 'firebase_connector', 'data/ir_cron.xml')
def migrate(cr, installed_version):
if not installed_version:
return
openupgrade.load_xml(cr, 'sbc_compassion', 'data/gmc_action.xml')
openupgrade.load_xml(cr, 'child_compassion', 'data/gmc_action.xml')
openupgrade.load_xml(cr, 'sponsorship_compassion', 'data/gmc_action.xml')
def migrate(cr, version):
if not version:
return
# Force upgrade the reports
openupgrade.load_xml(cr, "report_compassion",
"report/anniversary_card.xml")
openupgrade.load_xml(cr, "report_compassion", "report/bvr_fund.xml")
openupgrade.load_xml(cr, "report_compassion", "report/bvr_gift.xml")
openupgrade.load_xml(cr, "report_compassion", "report/bvr_sponsorship.xml")
openupgrade.load_xml(cr, "report_compassion", "report/childpack.xml")
openupgrade.load_xml(cr, "report_compassion",
"report/communication_mailing_bvr.xml")
openupgrade.load_xml(cr, "report_compassion",
"report/partner_communication.xml")
openupgrade.load_xml(cr, "report_compassion", "report/tax_receipt.xml")
def migrate(cr, version):
if not version:
return
# Force loading products configuration
openupgrade.load_xml(cr, "crowdfunding_compassion", "data/products.xml")
def migrate(cr, installed_version):
if not installed_version:
return
openupgrade.load_xml(cr, 'intervention_compassion', 'data/gmc_action.xml')
def migrate(cr, installed_version):
if not installed_version:
return
openupgrade.load_xml(cr, 'website_event_compassion',
'data/action_rule_past_event.xml')
def migrate(env, version):
if not version:
return
openupgrade.load_xml()
# Muskathlon registration will become event.registration object:
# Prepare required columns
if not openupgrade.column_exists(env.cr, 'event_registration', 'lead_id'):
env.cr.execute("""
ALTER TABLE event_registration ADD COLUMN lead_id integer;
ALTER TABLE event_registration
ADD COLUMN sport_discipline_id integer;
ALTER TABLE event_registration
ADD COLUMN sport_level character varying;
ALTER TABLE event_registration
ADD COLUMN sport_level_description text;
ALTER TABLE event_registration ADD COLUMN amount_objective integer;
ALTER TABLE event_registration
ADD COLUMN website_published boolean;
ALTER TABLE event_registration ADD COLUMN reg_id character varying;
ALTER TABLE event_registration ADD COLUMN backup_id integer;
""")
# Insert data for events with registrations open
events = env['crm.event.compassion'].search([
('odoo_event_id', '!=', False),
])
env.cr.execute(
"""INSERT INTO event_registration(create_date,write_uid,
partner_id,create_uid,event_id,company_id,state,email,phone,write_date,origin,
name,date_open,lead_id,sport_discipline_id,sport_level,sport_level_description,
amount_objective,website_published,reg_id,backup_id)
SELECT now(),1,r.partner_id,1,odoo_event_id,1,'draft',p.email,p.phone,now(),
'Registration automatically migrated',p.name,r.create_date,r.lead_id,
sport_discipline_id,sport_level,sport_level_description,r.amount_objective,
r.website_published,reg_id,r.id
FROM muskathlon_registration r
JOIN crm_event_compassion e ON r.event_id = e.id
JOIN res_partner p ON r.partner_id = p.id
WHERE event_id = ANY(%s)""", [events.ids])
# Update relations to registration
table_names = [
'account_invoice_line', 'recurring_contract', 'payment_transaction'
]
env.cr.execute("""
ALTER TABLE payment_transaction
RENAME COLUMN registration_id TO muskathlon_registration_id;
ALTER table payment_transaction
DROP CONSTRAINT IF EXISTS payment_transaction_registration_id_fkey;
""")
for table in table_names:
env.cr.execute("""
ALTER table %s
DROP CONSTRAINT IF EXISTS %s_muskathlon_registration_id_fkey;
""" % (table, table))
env.cr.execute("""
UPDATE %s
SET muskathlon_registration_id = (
SELECT id FROM event_registration
WHERE backup_id = muskathlon_registration_id
);
""" % table)
env.cr.execute("""
ALTER TABLE payment_transaction
RENAME COLUMN muskathlon_registration_id TO registration_id;
""")
openupgrade.rename_fields(env, [
('account.invoice.line', 'account_invoice_line',
'muskathlon_registration_id', 'registration_id'),
('recurring.contract', 'recurring_contract',
'muskathlon_registration_id', 'registration_id'),
('crm.event.compassion', 'crm_event_compassion',
'muskathlon_registration_ids', 'registration_ids'),
('res.partner', 'res_partner', 'muskathlon_registration_ids',
'registration_ids'),
])
