PHP Windwalker\Query\Mysql MysqlQueryBuilder::showTableColumns示例

示例#1

文件： MysqlQueryBuilderTest.php 项目： rokite/windwalker

 /**
  * Method to test showTableColumns().
  *
  * @return void
  *
  * @covers Windwalker\Query\Mysql\MysqlQueryBuilder::showTableColumns
  */
 public function testShowTableColumns()
 {
     $expected = "SHOW COLUMNS FROM {$this->qn}foo{$this->qn}";
     $actual = MysqlQueryBuilder::showTableColumns('foo');
     $this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual));
     $expected = "SHOW FULL COLUMNS FROM {$this->qn}foo{$this->qn} WHERE a = b";
     $actual = MysqlQueryBuilder::showTableColumns('foo', true, 'a = b');
     $this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual));
 }

示例#2

文件： MysqlQueryBuilderTest.php 项目： im286er/windwalker

 /**
  * Method to test showTableColumns().
  *
  * @return void
  *
  * @covers Windwalker\Query\Mysql\MysqlQueryBuilder::showTableColumns
  */
 public function testShowTableColumns()
 {
     $expected = "SHOW COLUMNS FROM {$this->qn('foo')}";
     $actual = MysqlQueryBuilder::showTableColumns('foo');
     $this->assertEquals($this->format($expected), $this->format($actual));
     $expected = "SHOW FULL COLUMNS FROM {$this->qn('foo')} WHERE a = b";
     $actual = MysqlQueryBuilder::showTableColumns('foo', true, 'a = b');
     $this->assertEquals($this->format($expected), $this->format($actual));
 }

示例#3

文件： MysqlTable.php 项目： im286er/windwalker

 /**
  * getColumnDetail
  *
  * @param string $column
  * @param bool   $full
  *
  * @return  mixed
  */
 public function getColumnDetail($column, $full = true)
 {
     $query = MysqlQueryBuilder::showTableColumns($this->table, $full, 'Field = ' . $this->db->quote($column));
     return $this->db->setQuery($query)->loadOne();
 }