post_restore-odootest.sql.j2

-- deactivate mail servers
UPDATE ir_mail_server
   SET active = false;

-- deactivate crons
UPDATE ir_cron
   SET active = false;

UPDATE ir_cron
   SET active = true
 WHERE id IN (
       SELECT res_id
         FROM ir_model_data
        WHERE model = 'ir.cron'
          AND (
	    (name = 'autovacuum_job' AND module = 'base')
            OR (name = 'ir_cron_autovacuum_queue_jobs' AND module = 'queue_job')
{% for active_cron in odoo_instance.value.odoo_active_crons | default([]) | sort(attribute='name') %}
            OR (name = '{{ active_cron.name }}' AND module = '{{ active_cron.module }}')
{% endfor %}
          )
);

-- neutralization flag for the database
INSERT INTO ir_config_parameter (key, value)
VALUES ('database.is_neutralized', true)
    ON CONFLICT (key) DO
       UPDATE SET value = true;