7 files changed, 459 insertions, 0 deletions
diff --git a/services/app/src/Sql/Internal/Delete.php b/services/app/src/Sql/Internal/Delete.php
new file mode 100644
index 0000000..c0761a2
--- /dev/null
+++ b/services/app/src/Sql/Internal/Delete.php
@@ -0,0 +1,51 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Nsfisis\Albatross\Sql\Internal;
+
+use Nsfisis\Albatross\Sql\QueryBuilder;
+
+final class Delete
+{
+    private string $where = '';
+
+    /**
+     * @internal
+     */
+    public function __construct(
+        private readonly QueryBuilder $sql,
+        private readonly string $table,
+    ) {
+    }
+
+    public function where(string $where): self
+    {
+        $this->where = $where;
+        return $this;
+    }
+
+    /**
+     * @param array<string, string|int> $params
+     */
+    public function execute(array $params = []): void
+    {
+        $this->sql->_executeDelete($this, $params);
+    }
+
+    /**
+     * @internal
+     */
+    public function _getTable(): string
+    {
+        return $this->table;
+    }
+
+    /**
+     * @internal
+     */
+    public function _getWhere(): string
+    {
+        return $this->where;
+    }
+}
diff --git a/services/app/src/Sql/Internal/Insert.php b/services/app/src/Sql/Internal/Insert.php
new file mode 100644
index 0000000..1bdd06f
--- /dev/null
+++ b/services/app/src/Sql/Internal/Insert.php
@@ -0,0 +1,62 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Nsfisis\Albatross\Sql\Internal;
+
+use Nsfisis\Albatross\Exceptions\InvalidSqlException;
+use Nsfisis\Albatross\Sql\QueryBuilder;
+
+final class Insert
+{
+    /**
+     * @var ?array<string, string|int|Select> $values
+     */
+    private ?array $values;
+
+    /**
+     * @internal
+     */
+    public function __construct(
+        private readonly QueryBuilder $sql,
+        private readonly string $table,
+    ) {
+    }
+
+    /**
+     * @param array<string, string|int|Select> $values
+     */
+    public function values(array $values): self
+    {
+        $this->values = $values;
+        return $this;
+    }
+
+    /**
+     * @return positive-int
+     */
+    public function execute(): int
+    {
+        return $this->sql->_executeInsert($this);
+    }
+
+    /**
+     * @internal
+     */
+    public function _getTable(): string
+    {
+        return $this->table;
+    }
+
+    /**
+     * @internal
+     * @return array<string, string|int|Select>
+     */
+    public function _getValues(): array
+    {
+        if (!isset($this->values)) {
+            throw new InvalidSqlException('INSERT: $values must be set before calling execute()');
+        }
+        return $this->values;
+    }
+}
diff --git a/services/app/src/Sql/Internal/InsertFromSelect.php b/services/app/src/Sql/Internal/InsertFromSelect.php
new file mode 100644
index 0000000..c003aa4
--- /dev/null
+++ b/services/app/src/Sql/Internal/InsertFromSelect.php
@@ -0,0 +1,78 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Nsfisis\Albatross\Sql\Internal;
+
+use Nsfisis\Albatross\Exceptions\InvalidSqlException;
+use Nsfisis\Albatross\Sql\QueryBuilder;
+
+final class InsertFromSelect
+{
+    /**
+     * @var ?list<string>
+     */
+    private ?array $fields;
+
+    private ?Select $from;
+
+    /**
+     * @internal
+     */
+    public function __construct(
+        private readonly QueryBuilder $sql,
+        private readonly string $table,
+    ) {
+    }
+
+    /**
+     * @param list<string> $fields
+     */
+    public function fields(array $fields): self
+    {
+        $this->fields = $fields;
+        return $this;
+    }
+
+    public function from(Select $from): self
+    {
+        $this->from = $from;
+        return $this;
+    }
+
+    /**
+     * @param array<string, string|int> $params
+     */
+    public function execute(array $params = []): void
+    {
+        $this->sql->_executeInsertFromSelect($this, $params);
+    }
+
+    /**
+     * @internal
+     */
+    public function _getTable(): string
+    {
+        return $this->table;
+    }
+
+    /**
+     * @internal
+     * @return list<string>
+     */
+    public function _getFields(): array
+    {
+        if (!isset($this->fields)) {
+            throw new InvalidSqlException('INSERT SELECT: $fields must be set before calling execute()');
+        }
+        return $this->fields;
+    }
+
+    public function _getFrom(): Select
+    {
+        if (!isset($this->from)) {
+            throw new InvalidSqlException('INSERT SELECT: $from must be set before calling execute()');
+        }
+        return $this->from;
+    }
+}
diff --git a/services/app/src/Sql/Internal/Join.php b/services/app/src/Sql/Internal/Join.php
new file mode 100644
index 0000000..4c85fd8
--- /dev/null
+++ b/services/app/src/Sql/Internal/Join.php
@@ -0,0 +1,18 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Nsfisis\Albatross\Sql\Internal;
+
+final class Join
+{
+    /**
+     * @param 'LEFT JOIN' $type
+     */
+    public function __construct(
+        public readonly string $type,
+        public readonly string $table,
+        public readonly string $on,
+    ) {
+    }
+}
diff --git a/services/app/src/Sql/Internal/Select.php b/services/app/src/Sql/Internal/Select.php
new file mode 100644
index 0000000..cf3f77a
--- /dev/null
+++ b/services/app/src/Sql/Internal/Select.php
@@ -0,0 +1,146 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Nsfisis\Albatross\Sql\Internal;
+
+use Nsfisis\Albatross\Exceptions\InvalidSqlException;
+use Nsfisis\Albatross\Sql\QueryBuilder;
+
+/**
+ * @internal
+ */
+final class Select
+{
+    /**
+     * @var ?list<string>
+     */
+    private ?array $fields;
+
+    private ?Join $join = null;
+
+    private string $where = '';
+
+    /**
+     * @var list<array{string, string}>
+     */
+    private array $orderBy = [];
+
+    /**
+     * @var ?positive-int
+     */
+    private ?int $limit = null;
+
+    public function __construct(
+        private readonly QueryBuilder $sql,
+        private readonly string $table,
+    ) {
+    }
+
+    public function leftJoin(string $table, string $on): self
+    {
+        $this->join = new Join('LEFT JOIN', $table, $on);
+        return $this;
+    }
+
+    /**
+     * @param list<string> $fields
+     */
+    public function fields(array $fields): self
+    {
+        $this->fields = $fields;
+        return $this;
+    }
+
+    public function where(string $where): self
+    {
+        $this->where = $where;
+        return $this;
+    }
+
+    /**
+     * @param list<array{string, string}> $orderBy
+     */
+    public function orderBy(array $orderBy): self
+    {
+        $this->orderBy = $orderBy;
+        return $this;
+    }
+
+    /**
+     * @param positive-int $limit
+     */
+    public function limit(int $limit): self
+    {
+        $this->limit = $limit;
+        return $this;
+    }
+
+    public function first(): SelectFirst
+    {
+        $this->limit = 1;
+        return new SelectFirst($this);
+    }
+
+    /**
+     * @param array<string, string|int> $params
+     * @return list<array<string, string>>
+     */
+    public function execute(array $params = []): array
+    {
+        return $this->sql->_executeSelect($this, $params);
+    }
+
+    /**
+     * @internal
+     */
+    public function _getTable(): string
+    {
+        return $this->table;
+    }
+
+    /**
+     * @internal
+     * @return list<string>
+     */
+    public function _getFields(): array
+    {
+        if (!isset($this->fields)) {
+            throw new InvalidSqlException('SELECT: $fields must be set before calling execute()');
+        }
+        return $this->fields;
+    }
+
+    /**
+     * @internal
+     */
+    public function _getJoin(): ?Join
+    {
+        return $this->join;
+    }
+
+    /**
+     * @internal
+     */
+    public function _getWhere(): string
+    {
+        return $this->where;
+    }
+
+    /**
+     * @internal
+     * @return list<array{string, string}>
+     */
+    public function _getOrderBy(): array
+    {
+        return $this->orderBy;
+    }
+
+    /**
+     * @return ?positive-int
+     */
+    public function _getLimit(): ?int
+    {
+        return $this->limit;
+    }
+}
diff --git a/services/app/src/Sql/Internal/SelectFirst.php b/services/app/src/Sql/Internal/SelectFirst.php
new file mode 100644
index 0000000..baf5aae
--- /dev/null
+++ b/services/app/src/Sql/Internal/SelectFirst.php
@@ -0,0 +1,26 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Nsfisis\Albatross\Sql\Internal;
+
+/**
+ * @internal
+ */
+final class SelectFirst
+{
+    public function __construct(
+        private readonly Select $inner,
+    ) {
+    }
+
+    /**
+     * @param array<string, string|int> $params
+     * @return ?array<string, string>
+     */
+    public function execute(array $params = []): ?array
+    {
+        $result = $this->inner->execute($params);
+        return $result[0] ?? null;
+    }
+}
diff --git a/services/app/src/Sql/Internal/Update.php b/services/app/src/Sql/Internal/Update.php
new file mode 100644
index 0000000..a9e9816
--- /dev/null
+++ b/services/app/src/Sql/Internal/Update.php
@@ -0,0 +1,78 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Nsfisis\Albatross\Sql\Internal;
+
+use Nsfisis\Albatross\Exceptions\InvalidSqlException;
+use Nsfisis\Albatross\Sql\QueryBuilder;
+
+final class Update
+{
+    /**
+     * @var ?array<string, string|int>
+     */
+    private ?array $set;
+
+    private string $where = '';
+
+    /**
+     * @internal
+     */
+    public function __construct(
+        private readonly QueryBuilder $sql,
+        private readonly string $table,
+    ) {
+    }
+
+    /**
+     * @param array<string, string|int> $set
+     */
+    public function set(array $set): self
+    {
+        $this->set = $set;
+        return $this;
+    }
+
+    public function where(string $where): self
+    {
+        $this->where = $where;
+        return $this;
+    }
+
+    /**
+     * @param array<string, string|int> $params
+     */
+    public function execute(array $params = []): void
+    {
+        $this->sql->_executeUpdate($this, $params);
+    }
+
+    /**
+     * @internal
+     */
+    public function _getTable(): string
+    {
+        return $this->table;
+    }
+
+    /**
+     * @internal
+     */
+    public function _getWhere(): string
+    {
+        return $this->where;
+    }
+
+    /**
+     * @internal
+     * @return array<string, string|int>
+     */
+    public function _getSet(): array
+    {
+        if (!isset($this->set)) {
+            throw new InvalidSqlException('UPDATE: $set must be set before calling execute()');
+        }
+        return $this->set;
+    }
+}