/** * @param AbstractQueryBuilder $query * @return string */ public function compileDelete(AbstractQueryBuilder $query) { $stmt = "DELETE FROM {$query->getTable()} "; $stmt .= $this->compileWheres($query->getWheres()); $stmt .= !is_null($query->getGroupBy()) ? $this->compileGroupBy($query->getGroupBy()) : ""; $stmt .= !is_null($query->getOrderBy()) ? $this->compileOrderBy($query->getOrderBy()) : ""; $stmt .= !is_null($query->getLimit()) ? "LIMIT " . $query->getLimit() . " " : ""; $stmt .= !is_null($query->getOffset()) ? "OFFSET " . $query->getOffset() : ""; return trim($stmt) . ';'; }
/** * @param AbstractQueryBuilder $query * @return mixed */ public function compileDelete(AbstractQueryBuilder $query) { $stmt = "DELETE FROM {$query->getTable()} "; $stmt .= $this->compileWheres($query->getWheres())[0]; $stmt .= !is_null($query->getGroupBy()) ? $this->compileGroupBy($query->getGroupBy()) : ""; $stmt .= !is_null($query->getOrderBy()) ? $this->compileOrderBy($query->getOrderBy()) : ""; $stmt .= !is_null($query->getLimit()) ? "LIMIT " . $query->getLimit() . " " : ""; $stmt .= !is_null($query->getOffset()) ? "OFFSET " . $query->getOffset() : ""; $bindings = $this->compileWheres($query->getWheres())[1]; $stmt = trim($stmt) . ';'; var_dump($stmt); var_dump($bindings); $sql[0] = $stmt; $sql[1] = $bindings; return $sql; }