PHP ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts方法代码示例

 /**
  * At some point if performance is a problem with rebuilding activity models, then the stored procedure
  * needs to be refactored to somehow support more joins dynamically.
  * @see https://www.pivotaltracker.com/story/show/38804909
  * @param boolean $forcePhp
  */
 public static function rebuild($forcePhp = false)
 {
     //Forcing php way until we can fix failing tests here: AccountReadPermissionsOptimizationScenariosTest
     $forcePhp = true;
     assert('is_bool($forcePhp)');
     foreach (self::getMungableModelClassNames() as $modelClassName) {
         if (!SECURITY_OPTIMIZED || $forcePhp) {
             self::rebuildViaSlowWay($modelClassName);
         } else {
             //models that extend activity are special and can only be done with the PHP process.  They cannot
             //be done using the stored procedure because it does not support the extra joins needed to determine
             //which securable items to look at.
             if (is_subclass_of($modelClassName, 'Activity')) {
                 self::rebuildViaSlowWay($modelClassName);
             } else {
                 $modelTableName = RedBeanModel::getTableName($modelClassName);
                 $mungeTableName = self::getMungeTableName($modelClassName);
                 if (!is_subclass_of($modelClassName, 'OwnedSecurableItem')) {
                     throw new NotImplementedException($message, $code, $previous);
                 }
                 if (is_subclass_of($modelClassName, 'Person')) {
                     if ($modelClassName != 'Contact') {
                         throw new NotSupportedException();
                     } else {
                         $modelTableName = Person::getTableName('Person');
                     }
                 }
                 ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts("rebuild('{$modelTableName}', '{$mungeTableName}')");
             }
         }
     }
 }

 public static function forgetAll($forgetDbLevelCache = true)
 {
     if (static::supportsAndAllowsDatabaseCaching() && $forgetDbLevelCache) {
         ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts("clear_cache_actual_rights()");
     }
     parent::forgetAll();
 }

 /**
  * @return bool
  */
 public function generateCampaignItemsForDueCampaigns()
 {
     $nowTimestamp = DateTimeUtil::convertTimestampToDbFormatDateTime(time());
     // Begin Not Coding Standard
     $sql = "`generate_campaign_items`(" . Campaign::STATUS_ACTIVE . "," . Campaign::STATUS_PROCESSING . ",'{$nowTimestamp}')";
     // End Not Coding Standard
     ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts($sql);
     Yii::app()->jobQueue->add('CampaignQueueMessagesInOutbox', 5);
     return true;
 }

 /**
  * At some point if performance is a problem with rebuilding activity models, then the stored procedure
  * needs to be refactored to somehow support more joins dynamically.
  * @see https://www.pivotaltracker.com/story/show/38804909
  * @param boolean $overwriteExistingTables
  * @param boolean $forcePhp
  */
 public static function rebuild($overwriteExistingTables = true, $forcePhp = false, $messageStreamer = null)
 {
     //Forcing php way until we can fix failing tests here: AccountReadPermissionsOptimizationScenariosTest
     $forcePhp = true;
     assert('is_bool($overwriteExistingTables)');
     assert('is_bool($forcePhp)');
     foreach (PathUtil::getAllMungableModelClassNames() as $modelClassName) {
         $mungeTableName = self::getMungeTableName($modelClassName);
         $readTableExists = ZurmoRedBean::$writer->doesTableExist($mungeTableName);
         if (!$overwriteExistingTables && $readTableExists) {
             if (isset($messageStreamer)) {
                 $messageStreamer->add(Zurmo::t('ZurmoModule', "Skipping {{tableName}}", array('{{tableName}}' => $mungeTableName)));
             }
             // skip if we don't want to overwrite existing tables and table already exists
             continue;
         }
         if (isset($messageStreamer)) {
             $messageStreamer->add(Zurmo::t('ZurmoModule', "Building {{tableName}}", array('{{tableName}}' => $mungeTableName)));
         }
         if (!SECURITY_OPTIMIZED || $forcePhp) {
             self::rebuildViaSlowWay($modelClassName);
         } else {
             //models that extend activity are special and can only be done with the PHP process.  They cannot
             //be done using the stored procedure because it does not support the extra joins needed to determine
             //which securable items to look at.
             if (is_subclass_of($modelClassName, 'Activity')) {
                 self::rebuildViaSlowWay($modelClassName);
             } else {
                 $modelTableName = $modelClassName::getTableName();
                 if (!is_subclass_of($modelClassName, 'OwnedSecurableItem')) {
                     throw new NotImplementedException();
                 }
                 if (is_subclass_of($modelClassName, 'Person')) {
                     if ($modelClassName != 'Contact') {
                         throw new NotSupportedException();
                     } else {
                         $modelTableName = Person::getTableName();
                     }
                 }
                 ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts("rebuild('{$modelTableName}', '{$mungeTableName}')");
             }
         }
     }
 }

 public function testPermissionsCachingBasics()
 {
     if (!SECURITY_OPTIMIZED) {
         return;
     }
     $accounts = Account::getAll();
     $account = $accounts[0];
     $user = User::getByUsername('bobby');
     $this->assertNotEquals($account->owner->id, $user->id);
     $account->addPermissions($user, Permission::READ);
     $this->assertTrue($account->save());
     $securableItemId = $account->getClassId('SecurableItem');
     $permitableId = $user->getClassId('Permitable');
     R::exec("call get_securableitem_cached_actual_permissions_for_permitable({$securableItemId}, {$permitableId}, @allow_permissions, @deny_permissions)");
     $allow_permissions = intval(R::getCell('select @allow_permissions'));
     $deny_permissions = intval(R::getCell('select @deny_permissions'));
     $this->assertEquals(Permission::NONE, $allow_permissions);
     $this->assertEquals(Permission::NONE, $deny_permissions);
     ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts("cache_securableitem_actual_permissions_for_permitable({$securableItemId}, {$permitableId}, 1, 0)");
     R::exec("call get_securableitem_cached_actual_permissions_for_permitable({$securableItemId}, {$permitableId}, @allow_permissions, @deny_permissions)");
     $allow_permissions = intval(R::getCell('select @allow_permissions'));
     $deny_permissions = intval(R::getCell('select @deny_permissions'));
     $this->assertEquals(Permission::READ, $allow_permissions);
     $this->assertEquals(Permission::NONE, $deny_permissions);
     ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts("clear_cache_securableitem_actual_permissions({$securableItemId})");
     R::exec("call get_securableitem_cached_actual_permissions_for_permitable({$securableItemId}, {$permitableId}, @allow_permissions, @deny_permissions)");
     $allow_permissions = intval(R::getCell('select @allow_permissions'));
     $deny_permissions = intval(R::getCell('select @deny_permissions'));
     $this->assertEquals(Permission::NONE, $allow_permissions);
     $this->assertEquals(Permission::NONE, $deny_permissions);
     $account->removeAllPermissions();
     $this->assertTrue($account->save());
     $this->assertEquals(Permission::NONE, $account->getEffectivePermissions($user));
     $this->assertEquals(array(Permission::NONE, Permission::NONE), $account->getExplicitActualPermissions($user));
     $this->assertEquals(array(Permission::NONE, Permission::NONE), $account->getInheritedActualPermissions($user));
 }

 public static function forgetAll($forgetDbLevelCache = true)
 {
     if (PHP_CACHING_ON) {
         self::$securableItemToPermitableToCombinedPermissions = array();
         self::$namedSecurableItemActualPermissions = array();
     }
     if (SECURITY_OPTIMIZED && DB_CACHING_ON && $forgetDbLevelCache) {
         ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts("clear_cache_all_actual_permissions()");
     }
     if (MEMCACHE_ON && Yii::app()->cache !== null) {
         self::incrementCacheIncrementValue(static::$cacheType);
     }
 }

 public static function forgetAll($forgetDbLevelCache = true)
 {
     if (static::supportsAndAllowsPhpCaching()) {
         static::$securableItemToPermitableToCombinedPermissions = array();
         static::$namedSecurableItemActualPermissions = array();
     }
     if (SECURITY_OPTIMIZED && static::supportsAndAllowsDatabaseCaching() && $forgetDbLevelCache) {
         ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts("clear_cache_all_actual_permissions()");
     }
     if (static::supportsAndAllowsDatabaseCaching() && $forgetDbLevelCache) {
         ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts("clear_cache_named_securable_all_actual_permissions()");
     }
     static::clearMemcacheCache();
 }

 /**
  * Updates the email message using stored procedure
  * @param EmailMessage $emailMessage
  */
 protected function updateEmailMessageForSending(EmailMessage $emailMessage, $useSQL = false)
 {
     if (!$useSQL) {
         Yii::log("EmailMessage should have been saved by this point. Anyways, saving now", CLogger::LEVEL_INFO);
         // we save it and return. No need to call SP as the message is saved already;
         $emailMessage->save(false);
         return;
     }
     $nowTimestamp = "'" . DateTimeUtil::convertTimestampToDbFormatDateTime(time()) . "'";
     $sendAttempts = $emailMessage->sendAttempts ? $emailMessage->sendAttempts : 1;
     $sentDateTime = $emailMessage->sentDateTime ? "'" . $emailMessage->sentDateTime . "'" : 'null';
     $serializedData = $emailMessage->error->serializedData ? "'" . $emailMessage->error->serializedData . "'" : 'null';
     $sql = '`update_email_message_for_sending`(
                                                                     ' . $emailMessage->id . ',
                                                                     ' . $sendAttempts . ',
                                                                     ' . $sentDateTime . ',
                                                                     ' . $emailMessage->folder->id . ',
                                                                     ' . $serializedData . ',
                                                                     ' . $nowTimestamp . ')';
     ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts($sql);
     $emailMessage->forget();
 }