PHP Query::getTable方法代码示例

 public function testShouldReturnRolesTable()
 {
     $query = new Query('roles');
     $result = $query->getTable();
     $expected = 'roles';
     $this->assertEquals($expected, $result);
 }

 public final function query(Query $query)
 {
     $result = $this->queryRaw($query->toDialectString($this->getDialect()));
     if ($query instanceof InsertQuery && !empty($this->sequencePool[$name = $query->getTable() . '_id'])) {
         $id = current($this->sequencePool[$name]);
         Assert::isTrue($id instanceof Identifier, 'identifier was lost in the way');
         $id->setId($this->getInsertId())->finalize();
         unset($this->sequencePool[$name][key($this->sequencePool[$name])]);
     }
     return $result;
 }

 /**
  * Throws UnexpectedValueException if the row class, either gleaned from Query::getTable() or
  * provided directly, does not exist.
  * Throws UnexpectedValueException if the above class does not have Model in its ancestry.
  *
  * @param Query $query
  * @param string $class = null
  */
 public function __construct(Query $query, $class = null)
 {
     if ($class) {
         $this->class = trim($class);
     } else {
         $this->class = trim(StringFormat::className($query->getTable()));
     }
     if (!class_exists($this->class)) {
         throw new UnexpectedValueException(sprintf('Class "%s" does not exist.', $this->class));
     }
     if (!is_a($this->class, 'Model', true)) {
         throw new UnexpectedValueException(sprintf('Class "%s" does not inherit from Model.', $this->class));
     }
     $this->query = $query;
 }

 /**
  * @group subquery
  * @covers Query::getTable
  */
 function testGetTableTwoWordsWithAlias()
 {
     $q = new Query('SELECT testing', 'alias');
     $this->assertEquals('SELECT testing', $q->getTable());
 }

 public function install(array $options = array())
 {
     $toret = false;
     $this->error_msg = false;
     if ($this->checkConnection()) {
         $drop_table = array_key_exists('drop_table', $options) ? $options['drop_table'] : false;
         $query = $this->getInstallSQL();
         if ($query) {
             if ($drop_table) {
                 $table = $this->getSource();
                 $drop_query = new CustomQuery('DROP TABLE IF EXISTS ' . Query::getTable($this) . '', array('connection' => $this->db));
                 $drop_query->execute();
                 Backend::addNotice('Dropping table ' . $table);
                 if (!empty($drop_query->error_msg)) {
                     $this->error_msg = $drop_query->error_msg;
                 }
             }
             $query = new CustomQuery($query, array('connection' => $this->db));
             $toret = $query->execute();
             if (!empty($query->error_msg)) {
                 $this->error_msg = $query->error_msg;
             }
         } else {
             if (class_exists('BackendError', false)) {
                 BackendError::add(get_class($this) . ': No Install SQL', 'install');
             }
             $this->error_msg = 'No Install SQL for ' . class_name($this);
         }
     } else {
         if (class_exists('BackendError', false)) {
             BackendError::add(get_class($this) . ': DB Connection Error', 'install');
         }
         $this->error_msg = 'DB Connection error';
     }
     return $toret;
 }

 function join($type, $table, $conditions, array $options = array())
 {
     $this->query = false;
     $type = strtoupper($type);
     if (!in_array($type, array('RIGHT', 'LEFT', 'INNER', 'OUTER'))) {
         throw new Exception('Unsupported Join Type');
     }
     if (!is_array($conditions)) {
         $conditions = array($conditions);
     }
     if (!array_key_exists($type, $this->joins)) {
         $this->joins[$type] = array();
     }
     if ($table instanceof Query) {
         $table = $table->__toString();
         if (array_key_exists('alias', $options)) {
             $table = '(' . $table . ') AS ' . Query::enclose($options['alias']);
         } else {
             trigger_error('Joined sub queries should have aliases', E_USER_ERROR);
         }
     } else {
         $table = Query::getTable($table);
         if (array_key_exists('alias', $options)) {
             $table = Query::enclose($table) . ' AS ' . Query::enclose($options['alias']);
         }
     }
     if (array_key_exists($table, $this->joins[$type])) {
         $this->joins[$type][$table] = array_merge($this->joins[$type][$table], $conditions);
     } else {
         $this->joins[$type][$table] = $conditions;
     }
     return $this;
 }