Exemple #1
0
 function __construct(ServiceLocatorInterface $sl, $table, $id = null, $id_column = 'id')
 {
     $dbAdapter = $sl->get('Zend\\Db\\Adapter\\Adapter');
     $this->id_column = $id_column;
     $this->id_value = $id;
     $this->tableGateway = new TableGateway($table, $dbAdapter);
     if (!empty($this->id_value)) {
         $rs = $this->tableGateway->select(array($id_column => $id));
         if ($rs->count() > 0) {
             $data = $rs->current();
             foreach ($data as $k => $v) {
                 $this->addColumn($k, $v);
             }
         }
     } else {
         $metadata = new \Zend\Db\Metadata\Metadata($this->tableGateway->adapter);
         $columns = $metadata->getColumnNames($table);
         foreach ($columns as $column_name) {
             $this->addColumn($column_name, null);
         }
     }
 }
 /**
  * Generates PHP files with field names as constants
  */
 public function generateDbConstants()
 {
     $metadata = new \Zend\Db\Metadata\Metadata($this->dbAdapter);
     $schema = $this->dbAdapter->getDriver()->getConnection()->getCurrentSchema();
     $tables = $metadata->getTableNames($schema, true);
     foreach ($tables as $table) {
         $words = explode('_', $table);
         $class = 'Db';
         foreach ($words as $word) {
             $word[0] = strtoupper($word[0]);
             $class = $class . $word;
         }
         $filename = __DIR__ . '/../Utils/DbConsts/' . $class . '.php';
         if (file_exists($filename)) {
             unlink($filename);
         }
         $writer = new \Zend\Log\Writer\Stream($filename);
         $writer->setFormatter(new \Zend\Log\Formatter\Simple('%message%'));
         $logger = new \Zend\Log\Logger();
         $logger->addWriter($writer);
         $logger->info('<?php');
         $logger->info('');
         $logger->info('namespace Application\\Utils\\DbConsts;');
         $logger->info('');
         $logger->info("class {$class}");
         $logger->info('{');
         $logger->info("    const TABLE = '{$table}';");
         $columns = $metadata->getColumnNames($table, $schema);
         foreach ($columns as $column) {
             $logger->info(vsprintf("    const %s = '%s';", array(strtoupper($column), $column)));
         }
         $logger->info('');
         $hasConst = '
 static public function hasField($field) 
 {
     if (!is_string($field)) {
         return false;
     }
     $field = strtoupper($field);
     $reflect = new \\ReflectionClass(__CLASS__);
     foreach ($reflect->getConstants() as $name => $value) {
         if (strtoupper($value) === $field) {
             return true;
         }
     };
     return false;
 }';
         $logger->info($hasConst);
         $logger->info('}');
         $logger = null;
         chmod($filename, 0777);
     }
 }
Exemple #3
0
 /**
  * Returns columns names
  *
  * @todo colocar no cache
  *
  * @return array columns
  */
 public function getColumns()
 {
     if (!isset($this->_columns)) {
         $metadata = new \Zend\Db\Metadata\Metadata($this->getTableGateway()->getAdapter());
         $this->_columns = $metadata->getColumnNames($this->getTable());
     }
     return $this->_columns;
 }