interface/modules/zend_modules/library/Zend/Db/Metadata/Metadata.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\Metadata;
  11
  12 use Zend\Db\Adapter\Adapter;
  13
  14 class Metadata implements MetadataInterface
  15 {
  16     /**
  17      * Adapter
  18      *
  19      * @var Adapter
  20      */
  21     protected $adapter = null;
  22
  23     /**
  24      * @var MetadataInterface
  25      */
  26     protected $source = null;
  27
  28     /**
  29      * Constructor
  30      *
  31      * @param Adapter $adapter
  32      */
  33     public function __construct(Adapter $adapter)
  34     {
  35         $this->adapter = $adapter;
  36         $this->source = $this->createSourceFromAdapter($adapter);
  37     }
  38
  39     /**
  40      * Create source from adapter
  41      *
  42      * @param  Adapter $adapter
  43      * @return Source\AbstractSource
  44      */
  45     protected function createSourceFromAdapter(Adapter $adapter)
  46     {
  47         switch ($adapter->getPlatform()->getName()) {
  48             case 'MySQL':
  49                 return new Source\MysqlMetadata($adapter);
  50             case 'SQLServer':
  51                 return new Source\SqlServerMetadata($adapter);
  52             case 'SQLite':
  53                 return new Source\SqliteMetadata($adapter);
  54             case 'PostgreSQL':
  55                 return new Source\PostgresqlMetadata($adapter);
  56         }
  57
  58         throw new \Exception('cannot create source from adapter');
  59     }
  60
  61     // @todo methods
  62
  63     /**
  64      * Get base tables and views
  65      *
  66      * @param string $schema
  67      * @param bool   $includeViews
  68      * @return Object\TableObject[]
  69      */
  70     public function getTables($schema = null, $includeViews = false)
  71     {
  72         return $this->source->getTables($schema, $includeViews);
  73     }
  74
  75     /**
  76      * Get base tables and views
  77      *
  78      * @param string $schema
  79      * @return Object\TableObject[]
  80      */
  81     public function getViews($schema = null)
  82     {
  83         return $this->source->getViews($schema);
  84     }
  85
  86     /**
  87      * Get triggers
  88      *
  89      * @param  string $schema
  90      * @return array
  91      */
  92     public function getTriggers($schema = null)
  93     {
  94         return $this->source->getTriggers($schema);
  95     }
  96
  97     /**
  98      * Get constraints
  99      *
 100      * @param  string $table
 101      * @param  string $schema
 102      * @return array
 103      */
 104     public function getConstraints($table, $schema = null)
 105     {
 106         return $this->source->getConstraints($table, $schema);
 107     }
 108
 109     /**
 110      * Get columns
 111      *
 112      * @param  string $table
 113      * @param  string $schema
 114      * @return array
 115      */
 116     public function getColumns($table, $schema = null)
 117     {
 118         return $this->source->getColumns($table, $schema);
 119     }
 120
 121     /**
 122      * Get constraint keys
 123      *
 124      * @param  string $constraint
 125      * @param  string $table
 126      * @param  string $schema
 127      * @return array
 128      */
 129     public function getConstraintKeys($constraint, $table, $schema = null)
 130     {
 131         return $this->source->getConstraintKeys($constraint, $table, $schema);
 132     }
 133
 134     /**
 135      * Get constraints
 136      *
 137      * @param  string $constraintName
 138      * @param  string $table
 139      * @param  string $schema
 140      * @return Object\ConstraintObject
 141      */
 142     public function getConstraint($constraintName, $table, $schema = null)
 143     {
 144         return $this->source->getConstraint($constraintName, $table, $schema);
 145     }
 146
 147     /**
 148      * Get schemas
 149      */
 150     public function getSchemas()
 151     {
 152         return $this->source->getSchemas();
 153     }
 154
 155     /**
 156      * Get table names
 157      *
 158      * @param  string $schema
 159      * @param  bool   $includeViews
 160      * @return array
 161      */
 162     public function getTableNames($schema = null, $includeViews = false)
 163     {
 164         return $this->source->getTableNames($schema, $includeViews);
 165     }
 166
 167     /**
 168      * Get table
 169      *
 170      * @param  string $tableName
 171      * @param  string $schema
 172      * @return Object\TableObject
 173      */
 174     public function getTable($tableName, $schema = null)
 175     {
 176         return $this->source->getTable($tableName, $schema);
 177     }
 178
 179     /**
 180      * Get views names
 181      *
 182      * @param string $schema
 183      * @return \Zend\Db\Metadata\Object\TableObject
 184      */
 185     public function getViewNames($schema = null)
 186     {
 187         return $this->source->getTable($schema);
 188     }
 189
 190     /**
 191      * Get view
 192      *
 193      * @param string $viewName
 194      * @param string $schema
 195      * @return \Zend\Db\Metadata\Object\TableObject
 196      */
 197     public function getView($viewName, $schema = null)
 198     {
 199         return $this->source->getView($viewName, $schema);
 200     }
 201
 202     /**
 203      * Get trigger names
 204      *
 205      * @param string $schema
 206      * @return array
 207      */
 208     public function getTriggerNames($schema = null)
 209     {
 210         return $this->source->getTriggerNames($schema);
 211     }
 212
 213     /**
 214      * Get trigger
 215      *
 216      * @param string $triggerName
 217      * @param string $schema
 218      * @return \Zend\Db\Metadata\Object\TriggerObject
 219      */
 220     public function getTrigger($triggerName, $schema = null)
 221     {
 222         return $this->source->getTrigger($triggerName, $schema);
 223     }
 224
 225     /**
 226      * Get column names
 227      *
 228      * @param string $table
 229      * @param string $schema
 230      * @return array
 231      */
 232     public function getColumnNames($table, $schema = null)
 233     {
 234         return $this->source->getColumnNames($table, $schema);
 235     }
 236
 237     /**
 238      * Get column
 239      *
 240      * @param string $columnName
 241      * @param string $table
 242      * @param string $schema
 243      * @return \Zend\Db\Metadata\Object\ColumnObject
 244      */
 245     public function getColumn($columnName, $table, $schema = null)
 246     {
 247         return $this->source->getColumn($columnName, $table, $schema);
 248     }
 249 }