public function testSelecionarColunasAReceberDoBancoComTablePersonalizada()
 {
     $select = new Select();
     $select->table = 'pages';
     $fields = ['name', 'email', 'password'];
     $select->fields($fields);
     $sql = $select->sql();
     $this->assertEquals('SELECT `name`, `email`, `password` FROM pages;', $sql);
 }
Пример #2
0
 /**
  * Create a new select query builder
  * 
  *     $h->table('users')->select(['name', 'age'])
  *
  * @param string|array                              $fields
  * @return Select
  */
 public function select($fields = null)
 {
     $query = new Select($this);
     return $query->fields($fields);
 }