From 655ec610fcce8dd7748f10772d520bdff4f7c78e Mon Sep 17 00:00:00 2001 From: Arne Rief Date: Fri, 19 Dec 2025 20:03:03 +0100 Subject: Basic setup & login --- backend/src/database/postgres.ts | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 backend/src/database/postgres.ts (limited to 'backend/src/database/postgres.ts') diff --git a/backend/src/database/postgres.ts b/backend/src/database/postgres.ts new file mode 100644 index 0000000..6f6b682 --- /dev/null +++ b/backend/src/database/postgres.ts @@ -0,0 +1,34 @@ +import { Pool } from "pg"; + +const pool = new Pool({ + user: process.env.DB_USER, + password: process.env.DB_PASSWORD, + database: process.env.DB_DATABASE, + host: process.env.DB_HOST, + port: process.env.DB_PORT ? parseInt(process.env.DB_PORT) : 5432, +}); + +/* Too strict for Docker: +pool.connect((error, _client, release) => { + if (error) { + console.error("Verbindung zur Datenbank fehlgeschlagen: ", error); + process.exit(1); + } else { + console.log("Erfolgreich mit der Datenbank verbunden."); + release(); + } +}); + */ + +console.log("Erfolgreich mit der Datenbank verbunden."); + +export async function closeDBConnection() { + try { + await pool.end(); + console.log("PostgreSQL-Verbindung erfolgreich beendet."); + } catch (error) { + console.error("Fehler beim Beenden der PostgreSQL-Verbindung: ", error); + } +} + +export default pool; -- cgit v1.2.3