PHP Column::getType方法代码示例

 protected function addTranslatedColumnSetter(Column $column)
 {
     $visibility = $column->getTable()->isReadOnly() ? 'protected' : $column->getMutatorVisibility();
     $typeHint = '';
     $null = '';
     if ($column->getTypeHint()) {
         $typeHint = $column->getTypeHint();
         if ('array' !== $typeHint) {
             $typeHint = $this->declareClass($typeHint);
         }
         $typeHint .= ' ';
         if (!$column->isNotNull()) {
             $null = ' = null';
         }
     }
     $typeHint = "{$typeHint}\$v{$null}";
     $i18nTablePhpName = $this->builder->getClassNameFromBuilder($this->builder->getNewStubObjectBuilder($this->behavior->getI18nTable()));
     $tablePhpName = $this->builder->getObjectClassName();
     $objectBuilder = $this->builder->getNewObjectBuilder($this->behavior->getI18nTable());
     $comment = '';
     if ($this->isDateType($column->getType())) {
         $objectBuilder->addTemporalMutatorComment($comment, $column);
     } else {
         $objectBuilder->addMutatorComment($comment, $column);
     }
     $comment = preg_replace('/^\\t/m', '', $comment);
     $comment = str_replace('@return     $this|' . $i18nTablePhpName, '@return     $this|' . $tablePhpName, $comment);
     return $this->renderTemplate('objectTranslatedColumnSetter', ['comment' => $comment, 'column' => $column, 'visibility' => $visibility, 'typeHint' => $typeHint, 'columnPhpName' => $column->getPhpName(), 'localeColumnName' => $this->behavior->getLocaleColumn()->getPhpName()]);
 }

    /**
     * @param \Propel\Generator\Model\Column $col
     *
     * @return string
     */
    protected function addFilterByColIn(Column $col)
    {
        $script = '';
        if ($col->isNumericType() || $col->isTemporalType() || $col->getType() == PropelTypes::ENUM || $col->isTextType()) {
            $colPhpName = $col->getPhpName();
            $variableName = $col->getCamelCaseName();
            $queryClassName = $this->getQueryClassName();
            $script .= <<<SCRIPT

    /**
     * Applies Criteria::IN filtering criteria for the column.
     *
     * @param array \${$variableName}s Filter value.
     *
     * @return \$this|{$queryClassName} The current query, for fluid interface
     */
    public function filterBy{$colPhpName}_In(array \${$variableName}s)
    {
        return \$this->filterBy{$colPhpName}(\${$variableName}s, Criteria::IN);
    }

SCRIPT;
        }
        return $script;
    }

 /**
  * Get the PHP snippet for binding a value to a column.
  * Warning: duplicates logic from OracleAdapter::bindValue().
  * Any code modification here must be ported there.
  */
 public function getColumnBindingPHP(Column $column, $identifier, $columnValueAccessor, $tab = "            ")
 {
     if ($column->getPDOType() == PropelTypes::CLOB_EMU) {
         return sprintf("%s\$stmt->bindParam(%s, %s, %s, strlen(%s));\n", $tab, $identifier, $columnValueAccessor, PropelTypes::getPdoTypeString($column->getType()), $columnValueAccessor);
     }
     return parent::getColumnBindingPHP($column, $identifier, $columnValueAccessor, $tab);
 }

 /**
  * Adds a remove method for an array column.
  * @param string &$script The script will be modified in this method.
  * @param Column $col     The current column.
  */
 protected function addRemoveArrayElement(&$script, Column $col)
 {
     $clo = $col->getLowercasedName();
     $cfc = $col->getPhpName();
     $visibility = $col->getAccessorVisibility();
     $singularPhpName = $col->getPhpSingularName();
     $columnType = $col->getType() === PropelTypes::PHP_ARRAY ? 'array' : 'set';
     $script .= "\n    /**\n     * Removes a value from the [{$clo}] {$columnType} column value.\n     * @param  mixed \$value\n     * " . $col->getDescription();
     if ($col->isLazyLoad()) {
         $script .= "\n     * @param  ConnectionInterface \$con An optional ConnectionInterface connection to use for fetching this lazy-loaded column.";
     }
     $script .= "\n     * @return \$this|" . $this->getObjectClassName(true) . " The current object (for fluent API support)\n     */\n    {$visibility} function remove{$singularPhpName}(\$value";
     if ($col->isLazyLoad()) {
         $script .= ", ConnectionInterface \$con = null";
     }
     // we want to reindex the array, so array_ functions are not the best choice
     $script .= ")\n    {\n        \$targetArray = array();\n        foreach (\$this->get{$cfc}(";
     if ($col->isLazyLoad()) {
         $script .= "\$con";
     }
     $script .= ") as \$element) {\n            if (\$element != \$value) {\n                \$targetArray []= \$element;\n            }\n        }\n        \$this->set{$cfc}(\$targetArray);\n\n        return \$this;\n    } // remove{$singularPhpName}()\n";
 }

 public function getColumnDDL(Column $col)
 {
     $domain = $col->getDomain();
     $ddl = array($this->quoteIdentifier($col->getName()));
     $sqlType = $domain->getSqlType();
     $table = $col->getTable();
     if ($col->isAutoIncrement() && $table && $table->getIdMethodParameters() == null) {
         $sqlType = $col->getType() === PropelTypes::BIGINT ? 'bigserial' : 'serial';
     }
     if ($this->hasSize($sqlType) && $col->isDefaultSqlType($this)) {
         $ddl[] = $sqlType . $domain->printSize();
     } else {
         $ddl[] = $sqlType;
     }
     if ($default = $this->getColumnDefaultValueDDL($col)) {
         $ddl[] = $default;
     }
     if ($notNull = $this->getNullString($col->isNotNull())) {
         $ddl[] = $notNull;
     }
     if ($autoIncrement = $col->getAutoIncrementString()) {
         $ddl[] = $autoIncrement;
     }
     return implode(' ', $ddl);
 }

 /**
  * Get the PHP snippet for binding a value to a column.
  * Warning: duplicates logic from AdapterInterface::bindValue().
  * Any code modification here must be ported there.
  */
 public function getColumnBindingPHP(Column $column, $identifier, $columnValueAccessor, $tab = "            ")
 {
     $script = '';
     if ($column->isTemporalType()) {
         $columnValueAccessor = $columnValueAccessor . " ? " . $columnValueAccessor . "->format(\"" . $this->getTimeStampFormatter() . "\") : null";
     } elseif ($column->isLobType()) {
         // we always need to make sure that the stream is rewound, otherwise nothing will
         // get written to database.
         $script .= "\nif (is_resource({$columnValueAccessor})) {\n    rewind({$columnValueAccessor});\n}";
     }
     $script .= sprintf("\n\$stmt->bindValue(%s, %s, %s);", $identifier, $columnValueAccessor, PropelTypes::getPdoTypeString($column->getType()));
     return preg_replace('/^(.+)/m', $tab . '$1', $script);
 }

 /**
  * Adds the function body for the lazy loader method.
  *
  * @param string &$script
  * @param Column $column
  */
 protected function addLazyLoaderBody(&$script, Column $column)
 {
     $platform = $this->getPlatform();
     $clo = $column->getLowercasedName();
     // pdo_sqlsrv driver requires the use of PDOStatement::bindColumn() or a hex string will be returned
     if ($column->getType() === PropelTypes::BLOB && $platform instanceof SqlsrvPlatform) {
         $script .= "\n        \$c = \$this->buildPkeyCriteria();\n        \$c->addSelectColumn(" . $this->getColumnConstant($column) . ");\n        try {\n            \$row = array(0 => null);\n            \$dataFetcher = " . $this->getQueryClassName() . "::create(null, \$c)->setFormatter(ModelCriteria::FORMAT_STATEMENT)->find(\$con);\n            if (\$dataFetcher instanceof PDODataFetcher) {\n                \$dataFetcher->bindColumn(1, \$row[0], PDO::PARAM_LOB, 0, PDO::SQLSRV_ENCODING_BINARY);\n            }\n            \$row = \$dataFetcher->fetch(PDO::FETCH_BOUND);\n            \$dataFetcher->close();";
     } else {
         $script .= "\n        \$c = \$this->buildPkeyCriteria();\n        \$c->addSelectColumn(" . $this->getColumnConstant($column) . ");\n        try {\n            \$dataFetcher = " . $this->getQueryClassName() . "::create(null, \$c)->setFormatter(ModelCriteria::FORMAT_STATEMENT)->find(\$con);\n            \$row = \$dataFetcher->fetch();\n            \$dataFetcher->close();";
     }
     $script .= "\n\n        \$firstColumn = \$row ? current(\$row) : null;\n";
     if ($column->getType() === PropelTypes::CLOB && $platform instanceof OraclePlatform) {
         // PDO_OCI returns a stream for CLOB objects, while other PDO adapters return a string...
         $script .= "\n            if (\$firstColumn) {\n                \$this->{$clo} = stream_get_contents(\$firstColumn);\n            }";
     } elseif ($column->isLobType() && !$platform->hasStreamBlobImpl()) {
         $script .= "\n            if (\$firstColumn !== null) {\n                \$this->{$clo} = fopen('php://memory', 'r+');\n                fwrite(\$this->{$clo}, \$firstColumn);\n                rewind(\$this->{$clo});\n            } else {\n                \$this->{$clo} = null;\n            }";
     } elseif ($column->isPhpPrimitiveType()) {
         $script .= "\n            \$this->{$clo} = (\$firstColumn !== null) ? (" . $column->getPhpType() . ") \$firstColumn : null;";
     } elseif ($column->isPhpObjectType()) {
         $script .= "\n            \$this->{$clo} = (\$firstColumn !== null) ? new " . $column->getPhpType() . "(\$firstColumn) : null;";
     } else {
         $script .= "\n            \$this->{$clo} = \$firstColumn;";
     }
     $script .= "\n            \$this->" . $clo . "_isLoaded = true;\n        } catch (Exception \$e) {\n            throw new PropelException(\"Error loading value for [{$clo}] column on demand.\", 0, \$e);\n        }";
 }

 /**
  * Returns the SQL for the default value of a Column object
  * @return     string
  */
 public function getColumnDefaultValueDDL(Column $col)
 {
     $default = '';
     $defaultValue = $col->getDefaultValue();
     if ($defaultValue !== null) {
         $default .= 'DEFAULT ';
         if ($defaultValue->isExpression()) {
             $default .= $defaultValue->getValue();
         } else {
             if ($col->isTextType()) {
                 $default .= $this->quote($defaultValue->getValue());
             } elseif ($col->getType() == PropelTypes::BOOLEAN || $col->getType() == PropelTypes::BOOLEAN_EMU) {
                 $default .= $this->getBooleanString($defaultValue->getValue());
             } elseif ($col->getType() == PropelTypes::ENUM) {
                 $default .= array_search($defaultValue->getValue(), $col->getValueSet());
             } else {
                 $default .= $defaultValue->getValue();
             }
         }
     }
     return $default;
 }

 protected function addTranslatedColumnSetter(Column $column)
 {
     $i18nTablePhpName = $this->builder->getNewStubObjectBuilder($this->behavior->getI18nTable())->getClassname();
     $tablePhpName = $this->builder->getStubObjectBuilder()->getClassname();
     $objectBuilder = $this->builder->getNewObjectBuilder($this->behavior->getI18nTable());
     $comment = '';
     $functionStatement = '';
     if ($column->getType() === PropelTypes::DATE || $column->getType() === PropelTypes::TIME || $column->getType() === PropelTypes::TIMESTAMP) {
         $objectBuilder->addTemporalMutatorComment($comment, $column);
         $objectBuilder->addMutatorOpenOpen($functionStatement, $column);
     } else {
         $objectBuilder->addMutatorComment($comment, $column);
         $objectBuilder->addMutatorOpenOpen($functionStatement, $column);
     }
     $comment = preg_replace('/^\\t/m', '', $comment);
     $comment = str_replace('@return     ' . $i18nTablePhpName, '@return     ' . $tablePhpName, $comment);
     $functionStatement = preg_replace('/^\\t/m', '', $functionStatement);
     preg_match_all('/\\$[a-z]+/i', $functionStatement, $params);
     return $this->behavior->renderTemplate('objectTranslatedColumnSetter', array('comment' => $comment, 'functionStatement' => $functionStatement, 'columnPhpName' => $column->getPhpName(), 'params' => implode(', ', $params[0])));
 }

 /**
  * Adds the function body for the lazy loader method
  * @param      string &$script The script will be modified in this method.
  * @param      Column $col The current column.
  * @see        addLazyLoader()
  **/
 protected function addLazyLoaderBody(&$script, Column $col)
 {
     $platform = $this->getPlatform();
     $clo = strtolower($col->getName());
     // pdo_sqlsrv driver requires the use of PDOStatement::bindColumn() or a hex string will be returned
     if ($col->getType() === PropelTypes::BLOB && $platform instanceof SqlsrvPlatform) {
         $script .= "\n        \$c = \$this->buildPkeyCriteria();\n        \$c->addSelectColumn(" . $this->getColumnConstant($col) . ");\n        try {\n            \$row = array(0 => null);\n            \$stmt = " . $this->getPeerClassname() . "::doSelectStmt(\$c, \$con);\n            \$stmt->bindColumn(1, \$row[0], PDO::PARAM_LOB, 0, PDO::SQLSRV_ENCODING_BINARY);\n            \$stmt->fetch(PDO::FETCH_BOUND);\n            \$stmt->closeCursor();";
     } else {
         $script .= "\n        \$c = \$this->buildPkeyCriteria();\n        \$c->addSelectColumn(" . $this->getColumnConstant($col) . ");\n        try {\n            \$stmt = " . $this->getPeerClassname() . "::doSelectStmt(\$c, \$con);\n            \$row = \$stmt->fetch(PDO::FETCH_NUM);\n            \$stmt->closeCursor();";
     }
     if ($col->getType() === PropelTypes::CLOB && $platform instanceof OraclePlatform) {
         // PDO_OCI returns a stream for CLOB objects, while other PDO adapters return a string...
         $script .= "\n            \$this->{$clo} = stream_get_contents(\$row[0]);";
     } elseif ($col->isLobType() && !$platform->hasStreamBlobImpl()) {
         $script .= "\n            if (\$row[0] !== null) {\n                \$this->{$clo} = fopen('php://memory', 'r+');\n                fwrite(\$this->{$clo}, \$row[0]);\n                rewind(\$this->{$clo});\n            } else {\n                \$this->{$clo} = null;\n            }";
     } elseif ($col->isPhpPrimitiveType()) {
         $script .= "\n            \$this->{$clo} = (\$row[0] !== null) ? (" . $col->getPhpType() . ") \$row[0] : null;";
     } elseif ($col->isPhpObjectType()) {
         $script .= "\n            \$this->{$clo} = (\$row[0] !== null) ? new " . $col->getPhpType() . "(\$row[0]) : null;";
     } else {
         $script .= "\n            \$this->{$clo} = \$row[0];";
     }
     $script .= "\n            \$this->" . $clo . "_isLoaded = true;\n        } catch (Exception \$e) {\n            throw new PropelException(\"Error loading value for [{$clo}] column on demand.\", 0, \$e);\n        }";
 }

 /**
  * Appends the generated <column> XML node to its parent node.
  *
  * @param Column   $column     The Column model instance
  * @param \DOMNode $parentNode The parent DOMNode object
  */
 private function appendColumnNode(Column $column, \DOMNode $parentNode)
 {
     $columnNode = $parentNode->appendChild($this->document->createElement('column'));
     $columnNode->setAttribute('name', $column->getName());
     if ($phpName = $column->getPhpName()) {
         $columnNode->setAttribute('phpName', $phpName);
     }
     $columnNode->setAttribute('type', $column->getType());
     $domain = $column->getDomain();
     if ($size = $domain->getSize()) {
         $columnNode->setAttribute('size', $size);
     }
     if (null !== ($scale = $domain->getScale())) {
         $columnNode->setAttribute('scale', $scale);
     }
     $platform = $column->getPlatform();
     if ($platform && !$column->isDefaultSqlType($platform)) {
         $columnNode->setAttribute('sqlType', $domain->getSqlType());
     }
     if ($description = $column->getDescription()) {
         $columnNode->setAttribute('description', $description);
     }
     if ($column->isPrimaryKey()) {
         $columnNode->setAttribute('primaryKey', 'true');
     }
     if ($column->isAutoIncrement()) {
         $columnNode->setAttribute('autoIncrement', 'true');
     }
     if ($column->isNotNull()) {
         $columnNode->setAttribute('required', 'true');
     }
     $defaultValue = $domain->getDefaultValue();
     if ($defaultValue) {
         $type = $defaultValue->isExpression() ? 'defaultExpr' : 'defaultValue';
         $columnNode->setAttribute($type, $defaultValue->getValue());
     }
     if ($column->isInheritance()) {
         $columnNode->setAttribute('inheritance', $column->getInheritanceType());
         foreach ($column->getInheritanceList() as $inheritance) {
             $this->appendInheritanceNode($inheritance, $columnNode);
         }
     }
     if ($column->isNodeKey()) {
         $columnNode->setAttribute('nodeKey', 'true');
         if ($nodeKeySeparator = $column->getNodeKeySep()) {
             $columnNode->setAttribute('nodeKeySep', $nodeKeySeparator);
         }
     }
     foreach ($column->getVendorInformation() as $vendorInformation) {
         $this->appendVendorInformationNode($vendorInformation, $columnNode);
     }
 }

 /**
  * Returns the SQL for the default value of a Column object
  * @return string
  */
 public function getColumnDefaultValueDDL(Column $col)
 {
     $default = '';
     $defaultValue = $col->getDefaultValue();
     if (null !== $defaultValue) {
         $default .= 'DEFAULT ';
         if ($defaultValue->isExpression()) {
             $default .= $defaultValue->getValue();
         } else {
             if ($col->isTextType()) {
                 $default .= $this->quote($defaultValue->getValue());
             } elseif (in_array($col->getType(), [PropelTypes::BOOLEAN, PropelTypes::BOOLEAN_EMU])) {
                 $default .= $this->getBooleanString($defaultValue->getValue());
             } elseif ($col->getType() == PropelTypes::ENUM) {
                 $default .= array_search($defaultValue->getValue(), $col->getValueSet());
             } elseif ($col->isPhpArrayType()) {
                 $value = $this->getPhpArrayString($defaultValue->getValue());
                 if (null === $value) {
                     $default = '';
                 } else {
                     $default .= $value;
                 }
             } else {
                 $default .= $defaultValue->getValue();
             }
         }
     }
     return $default;
 }