/** * {@inheritdoc} */ public function toSql() { $parts = ['DELETE FROM `' . $this->table . '`']; if ($part = parent::toSql()) { $parts[] = $part; } return implode(' ', $parts); }
/** * {@inheritdoc} */ public function toSql() { $parts = ['UPDATE `' . $this->table . '`']; if (count($this->attributes)) { $columns = array_keys($this->attributes); $parts[] = "SET " . Helper::arrayImplode(', ', $columns, "`", "` = ?"); } if ($part = parent::toSql()) { $parts[] = $part; } return implode(' ', $parts); }
/** * {@inheritdoc} */ public function toSql() { $columnSqlParts = []; foreach ($this->columns as $key => $column) { if ($column === '*') { $columnSqlParts[] = '*'; } else { $columnSqlParts[] = "`{$column}`"; } } $parts = ["SELECT " . implode(', ', $columnSqlParts) . " FROM `{$this->table}`"]; if ($part = parent::toSql()) { $parts[] = $part; } return implode(' ', $parts); }
public function testNothing() { $builder = new HasWhereExpression(); static::assertEquals('', $builder->toSql()); static::assertEquals([], $builder->getBindings()); }