interface/modules/zend_modules/library/Zend/Db/Sql/Ddl/Column/Decimal.php

   1 <?php
   2 /**
   3  * Zend Framework (http://framework.zend.com/)
   4  *
   5  * @link      http://github.com/zendframework/zf2 for the canonical source repository
   6  * @copyright Copyright (c) 2005-2013 Zend Technologies USA Inc. (http://www.zend.com)
   7  * @license   http://framework.zend.com/license/new-bsd New BSD License
   8  */
   9
  10 namespace Zend\Db\Sql\Ddl\Column;
  11
  12 class Decimal extends Column
  13 {
  14     /**
  15      * @var int
  16      */
  17     protected $precision;
  18
  19     /**
  20      * @var int
  21      */
  22     protected $scale;
  23
  24     /**
  25      * @var string
  26      */
  27     protected $specification = '%s DECIMAL(%s) %s %s';
  28
  29     /**
  30      * @param null|string $name
  31      * @param int $precision
  32      * @param null|int $scale
  33      */
  34     public function __construct($name, $precision, $scale = null)
  35     {
  36         $this->name      = $name;
  37         $this->precision = $precision;
  38         $this->scale     = $scale;
  39     }
  40
  41     /**
  42      * @return array
  43      */
  44     public function getExpressionData()
  45     {
  46         $spec   = $this->specification;
  47         $params = array();
  48
  49         $types    = array(self::TYPE_IDENTIFIER, self::TYPE_LITERAL);
  50         $params[] = $this->name;
  51         $params[] = $this->precision;
  52
  53         if ($this->scale !== null) {
  54             $params[1] .= ', ' . $this->scale;
  55         }
  56
  57         $types[]  = self::TYPE_LITERAL;
  58         $params[] = (!$this->isNullable) ? 'NOT NULL' : '';
  59
  60         $types[]  = ($this->default !== null) ? self::TYPE_VALUE : self::TYPE_LITERAL;
  61         $params[] = ($this->default !== null) ? $this->default : '';
  62
  63         return array(array(
  64             $spec,
  65             $params,
  66             $types,
  67         ));
  68     }
  69 }