/** * 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; }