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