/** * @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; }