installMe(__DIR__)
->apply();
}
/**
* The setup() method is executed before the test is executed (optional).
*/
public function setUp(): void {
parent::setUp();
}
/**
* The tearDown() method is executed after the test was executed (optional)
* This can be used for cleanup.
*/
public function tearDown(): void {
parent::tearDown();
}
/**
* Simple example test case.
*
* Note how the function name begins with the word "test".
*/
public function testMigrate(): void {
$this->createExampleLegacyTemplate();
$this->assertEquals(1, CRM_Core_DAO::singleValueQuery('SELECT count(*) FROM civicrm_mosaico_msg_template'));
$this->assertEquals(0, CRM_Core_DAO::singleValueQuery('SELECT count(*) FROM civicrm_mosaico_template'));
$result = civicrm_api3('Job', 'mosaico_migrate', []);
$this->assertEquals(1, count($result['values']));
foreach ($result['values'] as $k => $v) {
$this->assertEquals($k, $v['id']);
$this->assertEquals('versafix-1', $v['base']);
}
$this->assertEquals(1, CRM_Core_DAO::singleValueQuery('SELECT count(*) FROM civicrm_mosaico_msg_template'));
$this->assertEquals(1, CRM_Core_DAO::singleValueQuery('SELECT count(*) FROM civicrm_mosaico_template'));
$tpl = civicrm_api3('MosaicoTemplate', 'getsingle', []);
$this->assertEquals('The Name', $tpl['title']);
$this->assertEquals('versafix-1', $tpl['base']);
$result = civicrm_api3('Job', 'mosaico_purge', []);
$this->assertEquals(0, CRM_Core_DAO::singleValueQuery('SELECT count(*) FROM civicrm_mosaico_msg_template'));
$this->assertEquals(1, CRM_Core_DAO::singleValueQuery('SELECT count(*) FROM civicrm_mosaico_template'));
}
protected function createExampleLegacyTemplate(): void {
$msgTpl = civicrm_api3('MessageTemplate', 'create', [
'msg_title' => 'The Title',
'msg_subject' => 'The Subject',
'msg_html' => 'Placeholder
',
]);
CRM_Core_DAO::executeQuery('
INSERT INTO civicrm_mosaico_msg_template (msg_tpl_id, hash_key, name, html, metadata, template)
VALUES (%1, "1234abcd", "The Name", "The markup
", %2, %3)
', [
1 => [$msgTpl['id'], 'Positive'],
2 => [
'{"template":"http://dcase.l/sites/all/modules/civicrm/ext/mosaico/packages/mosaico/templates/versafix-1/template-versafix-1.html","name":"No name","created":1512016950525,"editorversion":"0.15.0","templateversion":"1.0.5","changed":1512016954547}',
'String',
],
3 => [json_encode(['type' => 'template']), 'String'],
]);
}
}