From d08f4c83470c25d35d24594bd73e4effdac191a0 Mon Sep 17 00:00:00 2001
From: Daniel Weipert <git@mail.dweipert.de>
Date: Tue, 19 Aug 2025 15:50:42 +0200
Subject: database migrations and models for users, devices, tokens

---
 src/Database.php | 36 ++++++++++++++++++++++++++++++++++++
 1 file changed, 36 insertions(+)
 create mode 100644 src/Database.php

(limited to 'src/Database.php')

diff --git a/src/Database.php b/src/Database.php
new file mode 100644
index 0000000..3fff863
--- /dev/null
+++ b/src/Database.php
@@ -0,0 +1,36 @@
+<?php
+
+namespace App;
+
+use PDO;
+use PDOStatement;
+
+class Database
+{
+  use Singleton;
+
+  private \PDO $connection;
+
+  public function __construct()
+  {
+    #$driver = $_ENV['DB_DRIVER'] ?? 'pgsql';
+    $host = $_ENV['DB_HOST'] ?? 'localhost';
+    $port = $_ENV['DB_PORT'] ?? 5432;
+    $dbname = $_ENV['DB_NAME'];
+    $user = $_ENV['DB_USER'];
+    $password = $_ENV['DB_PASSWORD'];
+
+    $this->connection = new \PDO("pgsql:host=$host;port=$port;dbname=$dbname", $user, $password);
+  }
+
+  /**
+   * @param array<mixed> $parameters
+   */
+  public function query(string $query, array $parameters = []): \PDOStatement|false
+  {
+    $statement = $this->connection->prepare($query);
+    $statement->execute($parameters);
+
+    return $statement;
+  }
+}
-- 
cgit v1.2.3