/**
* @param array $columns
*
* @return static
*/
public function columns(array $columns)
{
foreach ($columns as $name => $value) {
$this->columns[$this->grammar->buildId($name)] = $value;
}
return $this;
}
/**
* @param string $column
* @param bool $asc
*
* @return static
*/
public function orderBy($column, $asc = true)
{
if ($asc) {
$this->orders[] = $this->grammar->buildId($column) . ' ASC';
} else {
$this->orders[] = $this->grammar->buildId($column) . ' DESC';
}
return $this;
}
/**
* @param string $id
*
* @return string
*/
public function quoteId($id)
{
return $this->grammar->buildId($id);
}
public function testBuildNestedId()
{
$this->assertSame('"users"."username"', $this->grammar->buildId('users.username'));
$this->assertSame('"db"."users"."username"', $this->grammar->buildId('db.users.username'));
$this->assertSame('"db"."users"."username.foo"', $this->grammar->buildId('db.users.username.foo'));
}
/**
* @param string $column
* @param string $pattern
*
* @return static
*/
public function orNotLike($column, $pattern)
{
$this->conditions[] = 'OR ' . $this->grammar->buildId($column) . ' NOT LIKE ' . $pattern;
return $this;
}
