Exemplo n.º 1
0
 /**
  * Tests Postgresql::hasDefault for autoincrement fields
  *
  * @issue  https://github.com/phalcon/phalcon-devtools/issues/853
  * @author Serghei Iakovlev <*****@*****.**>
  * @since  2016-09-28
  */
 public function testHasAutoIncrementDefault()
 {
     $this->specify('The autoincrement column has default value', function () {
         $column = Column::__set_state(['_columnName' => 'id', '_schemaName' => null, '_type' => 14, '_typeReference' => -1, '_typeValues' => null, '_isNumeric' => true, '_size' => 0, '_scale' => 0, '_default' => "nextval('images_id_seq'::regclass)", '_unsigned' => false, '_notNull' => true, '_primary' => false, '_autoIncrement' => true, '_first' => true, '_after' => null, '_bindType' => 1]);
         expect($column->hasDefault())->false();
         expect($column->isAutoIncrement())->true();
     });
 }
 /**
  * Return a better Phalcon type (Check, Select, Password, ...) according to previous Phalcon type
  * and size of the column
  * @param string $type
  * @param \Phalcon\Db\Column $column
  * @return string
  */
 private function _getType($type, $column)
 {
     $size = $column->getSize();
     $columntype = $type;
     if ($type == "Numeric") {
         if ($size == 1) {
             $columntype = "Check";
         } else {
             if ($size == 11) {
                 $columntype = "Select";
             }
         }
     } else {
         if ($type == "Text") {
             if ($size > 255) {
                 $columntype = "Textarea";
             }
             if (preg_match("#(pass|pwd)#i", $column->getName())) {
                 $columntype = "Password";
             }
         }
     }
     return $columntype;
 }
Exemplo n.º 3
0
 /**
  * Modify table columns.
  *
  * @param string $tableName  Table name.
  * @param string $schemaName Schema name.
  * @param array  $definition Table Definition.
  *
  * @return int
  * @throws \Exception
  */
 protected function _modifyColumns($tableName, $schemaName, $definition)
 {
     if (empty($definition['columns'])) {
         throw new \Exception('Table must have at least one column');
     }
     $counter = 0;
     $db = $this->getDI()->get('db');
     $fields = [];
     foreach ($definition['columns'] as $tableColumn) {
         if (!is_object($tableColumn)) {
             throw new \Exception('Wrong column definition, it must be a object');
         }
         $fields[$tableColumn->getName()] = $tableColumn;
     }
     $localFields = [];
     $description = $db->describeColumns($tableName, $schemaName);
     foreach ($description as $field) {
         $localFields[$field->getName()] = $field;
     }
     foreach ($fields as $fieldName => $tableColumn) {
         if (!isset($localFields[$fieldName])) {
             $db->addColumn($tableName, $tableColumn->getSchemaName(), $tableColumn);
             $counter++;
         } else {
             $currentField = $localFields[$fieldName];
             $changed = false;
             // Hack boolean type.
             if ($currentField->getType() == Column::TYPE_INTEGER && $currentField->getSize() === "1") {
                 $currentField = new Column($fieldName, ['type' => Column::TYPE_BOOLEAN, 'size' => 0, 'notNull' => $currentField->isNotNull(), 'first' => $currentField->isFirst()]);
             }
             if ($currentField->getType() != $tableColumn->getType()) {
                 $changed = true;
             }
             if ($currentField->getSize() != $tableColumn->getSize()) {
                 $changed = true;
             }
             if ($tableColumn->isNotNull() != $currentField->isNotNull()) {
                 $changed = true;
             }
             if ($changed == true) {
                 $db->modifyColumn($tableName, $tableColumn->getSchemaName(), $tableColumn);
                 $counter++;
             }
         }
     }
     foreach (array_keys($localFields) as $fieldName) {
         if (!isset($fields[$fieldName])) {
             $db->dropColumn($tableName, null, $fieldName);
             $counter++;
         }
     }
     return $counter;
 }
Exemplo n.º 4
0
 /**
  * Creates new cassandra column
  * @param   string $name
  * @param   array $definition
  */
 public function __construct($name, $definition)
 {
     parent::__construct($name, $definition);
     if (!empty($definition['autoIncrement'])) {
         throw new CException('Auto increment columns not supported');
     }
     if (!empty($definition['partitionKey'])) {
         $this->_partitionKey = true;
     }
     if (!empty($definition['clusteringKey'])) {
         $this->_clusteringKey = true;
     }
     if (!empty($definition['reversed'])) {
         $this->_reversed = true;
     }
     if (!empty($definition['static'])) {
         $this->_static = true;
     }
     if (!empty($definition['frozen'])) {
         $this->_frozen = true;
     }
 }
Exemplo n.º 5
0
 /**
  * Tests Postgresql::describeColumns for Postgresql autoincrement column
  *
  * @issue  https://github.com/phalcon/phalcon-devtools/issues/853
  * @author Serghei Iakovlev <*****@*****.**>
  * @since  2016-09-28
  */
 public function testDescribeAutoIncrementColumns()
 {
     $this->specify('The table columns array contains incorrect initialized objects', function () {
         $columns = [Column::__set_state(['_columnName' => 'id', '_schemaName' => null, '_type' => 14, '_typeReference' => -1, '_typeValues' => null, '_isNumeric' => true, '_size' => 0, '_scale' => 0, '_default' => "nextval('images_id_seq'::regclass)", '_unsigned' => false, '_notNull' => true, '_primary' => false, '_autoIncrement' => true, '_first' => true, '_after' => null, '_bindType' => 1]), Column::__set_state(['_columnName' => 'base64', '_schemaName' => null, '_type' => 6, '_typeReference' => -1, '_typeValues' => null, '_isNumeric' => false, '_size' => null, '_scale' => 0, '_default' => null, '_unsigned' => false, '_notNull' => false, '_primary' => false, '_autoIncrement' => false, '_first' => false, '_after' => 'id', '_bindType' => 2])];
         expect($this->connection->describeColumns('images', null))->equals($columns);
         expect($this->connection->describeColumns('images', TEST_DB_POSTGRESQL_SCHEMA))->equals($columns);
     });
 }