当前位置: 首页>>代码示例>>PHP>>正文


PHP Meta::setMetaStorageDatatype方法代码示例

本文整理汇总了PHP中Meta::setMetaStorageDatatype方法的典型用法代码示例。如果您正苦于以下问题:PHP Meta::setMetaStorageDatatype方法的具体用法?PHP Meta::setMetaStorageDatatype怎么用?PHP Meta::setMetaStorageDatatype使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Meta的用法示例。


在下文中一共展示了Meta::setMetaStorageDatatype方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: decrementMeta

 /**
  * @param NodeRef $nodeRef
  * @param $metaID
  * @param int $value
  *
  * @throws NodeException
  * @throws SQLException
  * @throws Exception
  */
 public function decrementMeta(NodeRef $nodeRef, $metaID, $value = 1)
 {
     $metaID = ltrim($metaID, '#');
     $this->NodeEvents->fireNodeEvents(__FUNCTION__, '', $nodeRef, $metaID);
     $db = $this->getConnectionForWrite($nodeRef);
     $id = $this->getRecordIDFromNodeRef($nodeRef);
     // determine the meta storage
     $metaDef = $nodeRef->getElement()->getSchema()->getMetaDef($metaID);
     $datatype = $metaDef->getDatatype();
     $table = $db->quoteIdentifier($this->NodeDBMeta->getMetaTable($nodeRef, $datatype));
     $tableid = $this->NodeDBMeta->getPrimaryKey($nodeRef);
     $datatypeCol = $this->NodeDBMeta->getMetaDatatypeColumn($datatype);
     $value = intval($value);
     $newValue = false;
     $oldValue = false;
     $originalMeta = null;
     $maxValue = $this->getMaxIntForDatatype($datatype);
     $minValue = $this->getMinIntForDatatype($datatype);
     try {
         $affectedRows = $db->write("UPDATE {$table} SET {$datatypeCol}Value = LAST_INSERT_ID({$datatypeCol}Value-{$value}) WHERE {$tableid} = {$db->quote($id)} AND Name = {$db->quote($metaID)}", DatabaseInterface::AFFECTED_ROWS);
         if ($affectedRows == 1) {
             $newValue = intval($db->readField("SELECT LAST_INSERT_ID()"));
             $oldValue = $newValue + $value;
         }
     } catch (SQLException $e) {
         if ($e->getCode() != 22003 || strpos($e->getMessage(), 'Numeric value out of range') === false) {
             throw $e;
         }
         // must ask the DB for its current value
         $oldValue = intval($db->readField("SELECT {$datatypeCol}Value FROM {$table} WHERE {$tableid} = {$db->quote($id)} AND Name = {$db->quote($metaID)}"));
         $newValue = $oldValue - $value;
         // ensure the new values don't overflow (note that $value can be positive or negative and isn't necessarily 1)
         if ($newValue > $maxValue) {
             $newValue = $maxValue;
         } elseif ($newValue < $minValue) {
             $newValue = $minValue;
         }
         if ($newValue === $oldValue) {
             $affectedRows = 1;
         } else {
             $affectedRows = $db->write("UPDATE {$table} SET {$datatypeCol}Value = {$newValue} WHERE {$tableid} = {$db->quote($id)} AND Name = {$db->quote($metaID)}", DatabaseInterface::AFFECTED_ROWS);
         }
     } catch (Exception $e) {
         throw $e;
     }
     // new value didn't get set because the meta record hasn't been created yet.
     if ($newValue === false) {
         $newValue = $value * -1;
         // ensure the new values don't overflow (note that $value can be positive or negative and isn't necessarily 1)
         if ($newValue > $maxValue) {
             $newValue = $maxValue;
         } elseif ($newValue < $minValue) {
             $newValue = $minValue;
         }
     }
     if ($affectedRows == 0) {
         $affectedRows = $db->write("INSERT INTO {$table} ({$tableid}, Name, {$datatypeCol}Value) Values ({$db->quote($id)}, {$db->quote($metaID)}, {$newValue}) ON DUPLICATE KEY UPDATE {$datatypeCol}Value = LAST_INSERT_ID({$datatypeCol}Value-{$value})", DatabaseInterface::AFFECTED_ROWS);
         // new record inserted
         if ($affectedRows == 1) {
             $metaEvent = 'add';
             $newMeta = new Meta($metaID, $newValue);
             $newMeta->setMetaStorageDatatype($metaDef->Datatype);
             $originalMeta = null;
             // duplicate key update encountered
         } else {
             if ($affectedRows == 2) {
                 $metaEvent = 'update';
                 $newValue = intval($db->readField("SELECT LAST_INSERT_ID()"));
                 $oldValue = $newValue + $value;
                 $newMeta = new Meta($metaID, $newValue);
                 $newMeta->setMetaStorageDatatype($metaDef->Datatype);
                 $originalMeta = new Meta($metaID, $oldValue);
                 $originalMeta->setMetaStorageDatatype($metaDef->Datatype);
             } else {
                 throw new NodeException('Unable to decrement meta ID [' . $metaID . '] on record [' . $nodeRef . ']');
             }
         }
     } else {
         $metaEvent = 'update';
         $newMeta = new Meta($metaID, $newValue);
         $newMeta->setMetaStorageDatatype($metaDef->Datatype);
         $originalMeta = new Meta($metaID, $oldValue);
         $originalMeta->setMetaStorageDatatype($metaDef->Datatype);
     }
     $this->NodeEvents->fireMetaEvents('meta', $metaEvent, $nodeRef, $newMeta, $originalMeta);
 }
开发者ID:wb-crowdfusion,项目名称:crowdfusion,代码行数:95,代码来源:NodeMetaDAO.php


注:本文中的Meta::setMetaStorageDatatype方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。