/**
* Update an email message's folder and save it using SQL
* @param EmailMessage $emailMessage
* @param EmailFolder $folder
* @throws NotSupportedException
*/
protected static function updateFolderForEmailMessageWithSQL(EmailMessage &$emailMessage, EmailFolder $folder)
{
// TODO: @Shoaibi/@Jason: Critical0: This fails CampaignItemsUtilTest.php:243
$folderForeignKeyName = RedBeanModel::getForeignKeyName('EmailMessage', 'folder');
$tableName = EmailMessage::getTableName();
$sql = "UPDATE " . DatabaseCompatibilityUtil::quoteString($tableName);
$sql .= " SET " . DatabaseCompatibilityUtil::quoteString($folderForeignKeyName);
$sql .= " = " . $folder->id;
$sql .= " WHERE " . DatabaseCompatibilityUtil::quoteString('id') . " = " . $emailMessage->id;
$effectedRows = ZurmoRedBean::exec($sql);
if ($effectedRows == 1) {
$emailMessageId = $emailMessage->id;
$emailMessage->forgetAll();
$emailMessage = EmailMessage::getById($emailMessageId);
return true;
}
return false;
}
