Exemplo n.º 1
0
 /**
  * Gets the TableSchema for this model.
  *
  * @return TableSchema
  */
 public function getTableSchema()
 {
     if (empty($this->tableSchema)) {
         if (empty($this->schema)) {
             $this->getSchema();
         }
         $this->tableSchema = $this->schema->getTable($this->table);
     }
     return $this->tableSchema;
 }
Exemplo n.º 2
0
 public static function formatValue($value, $type)
 {
     if ('int' === $type && '' === $value) {
         // Postgresql strangely returns "" for null integers
         return null;
     }
     return parent::formatValue($value, $type);
 }
Exemplo n.º 3
0
 public static function formatValue($value, $type)
 {
     $value = parent::formatValue($value, $type);
     if (' ' === $value) {
         // SQL Anywhere strangely returns empty string as a single space string
         return '';
     }
     return $value;
 }
Exemplo n.º 4
0
 /**
  * Compares two table names.
  * The table names can be either quoted or unquoted. This method
  * will consider both cases.
  *
  * @param string $name1 table name 1
  * @param string $name2 table name 2
  *
  * @return boolean whether the two table names refer to the same table.
  */
 public function compareTableNames($name1, $name2)
 {
     return parent::compareTableNames(strtolower($name1), strtolower($name2));
 }
Exemplo n.º 5
0
 /**
  * Compares two table names.
  * The table names can be either quoted or unquoted. This method
  * will consider both cases.
  *
  * @param string $name1 table name 1
  * @param string $name2 table name 2
  *
  * @return boolean whether the two table names refer to the same table.
  */
 public function compareTableNames($name1, $name2)
 {
     $name1 = str_replace(['[', ']'], '', $name1);
     $name2 = str_replace(['[', ']'], '', $name2);
     return parent::compareTableNames(strtolower($name1), strtolower($name2));
 }
Exemplo n.º 6
0
 /**
  * @param ColumnSchema $field_info
  * @param bool         $as_quoted_string
  * @param string       $out_as
  *
  * @return string
  */
 public function parseFieldForSelect($field_info, $as_quoted_string = false, $out_as = null)
 {
     $field = $as_quoted_string ? $this->quoteColumnName($field_info->name) : $field_info->name;
     $alias = $as_quoted_string ? $this->quoteColumnName($field_info->getName(true)) : $field_info->getName(true);
     switch ($field_info->dbType) {
         case 'datetime':
         case 'datetimeoffset':
             return "(CONVERT(nvarchar(30), {$field}, 127)) AS {$alias}";
         case 'geometry':
         case 'geography':
         case 'hierarchyid':
             return "({$field}.ToString()) AS {$alias}";
         default:
             return parent::parseFieldForSelect($field_info, $as_quoted_string, $out_as);
     }
 }
Exemplo n.º 7
0
 /**
  * {@InheritDoc}
  */
 public function addForeignKey($name, $table, $columns, $refTable, $refColumns, $delete = null, $update = null)
 {
     // ON UPDATE not supported by Oracle
     return parent::addForeignKey($name, $table, $columns, $refTable, $refColumns, $delete, null);
 }
Exemplo n.º 8
0
 public static function formatValue($value, $type)
 {
     switch (strtolower(strval($type))) {
         case 'int':
         case 'integer':
             if ('' === $value) {
                 // Postgresql strangely returns "" for null integers
                 return null;
             }
     }
     return parent::formatValue($value, $type);
 }