Code Coverage for /home/jrf/repos/projom-storage/src/Storage/SQL/Statement/Delete.php

1	<?php
2
3	declare(strict_types=1);
4
5	namespace Projom\Storage\SQL\Statement;
6
7	use Stringable;
8
9	use Projom\Storage\SQL\Component\Filter;
10	use Projom\Storage\SQL\Component\Join;
11	use Projom\Storage\SQL\Component\Table;
12	use Projom\Storage\SQL\Statement\StatementInterface;
13	use Projom\Storage\SQL\QueryObject;
14	use Projom\Storage\SQL\Util;
15
16	class Delete implements StatementInterface, Stringable
17	{
18	private readonly Table $table;
19	private readonly Join $join;
20	private readonly Filter $filter;
21
22	public function __construct(QueryObject $queryDelete)
23	{
24	$this->table = Table::create($queryDelete->collections);
25	$this->join = Join::create($queryDelete->joins);
26	$this->filter = Filter::create($queryDelete->filters);
27	}
28
29	public function __toString(): string
30	{
31	[$statement, $params] = $this->statement();
32	return $statement;
33	}
34
35	public static function create(QueryObject $queryDelete): Delete
36	{
37	return new Delete($queryDelete);
38	}
39
40	public function statement(): array
41	{
42	$queryParts[] = "DELETE FROM {$this->table}";
43
44	if (!$this->join->empty())
45	$queryParts[] = "{$this->join}";
46
47	if (!$this->filter->empty())
48	$queryParts[] = "WHERE {$this->filter}";
49
50	$query = Util::join($queryParts, ' ');
51	$params = $this->filter->params() ?: null;
52
53	return [
54	$query,
55	$params
56	];
57	}
58	}