From 0055858f30dc3244a887a516277284202da14197 Mon Sep 17 00:00:00 2001
From: JoySystem_v <fvv2011@gmail.com>
Date: Mon, 26 Aug 2024 12:36:53 +0300
Subject: [PATCH] =?utf8?q?=D0=B2=D0=BE=D1=81=D1=81=D1=82=D0=B0=D0=BD=D0=BE?=
 =?utf8?q?=D0=B2=D0=BB=D0=B5=D0=BD=D0=B8=D0=B5=20=D1=84=D0=B0=D0=B9=D0=BB?=
 =?utf8?q?=D0=BE=D0=B2?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 docker/db/dev.db-pgsql.env |  8 ++++++++
 erp24/config/db.php        | 38 ++++++++++++++++++++++++++++++++++++++
 2 files changed, 46 insertions(+)
 create mode 100644 docker/db/dev.db-pgsql.env
 create mode 100644 erp24/config/db.php

diff --git a/docker/db/dev.db-pgsql.env b/docker/db/dev.db-pgsql.env
new file mode 100644
index 00000000..f6c696d6
--- /dev/null
+++ b/docker/db/dev.db-pgsql.env
@@ -0,0 +1,8 @@
+POSTGRES_USER=root
+POSTGRES_PASSWORD=root
+PGADMIN_DEFAULT_EMAIL=admin@admin.com
+PGADMIN_DEFAULT_PASSWORD=admin
+POSTGRES_DB=erp24
+POSTGRES_HOSTNAME=db-pgsql-yii_erp24
+POSTGRES_PORT=5432
+POSTGRES_SCHEMA=erp24
\ No newline at end of file
diff --git a/erp24/config/db.php b/erp24/config/db.php
new file mode 100644
index 00000000..1e278e47
--- /dev/null
+++ b/erp24/config/db.php
@@ -0,0 +1,38 @@
+<?php
+
+return 1 == 1 ? [
+    'class' => yii\db\Connection::class,
+    'dsn' => strtr('pgsql:host={host};port={port};dbname={dbname}', [
+        '{host}' => getenv('POSTGRES_HOSTNAME') ?: '127.0.0.1',
+        '{port}' => getenv('POSTGRES_PORT') ?: 5432,
+        '{dbname}' => getenv('POSTGRES_SCHEMA') ?: 'erp24',
+    ]),
+    'username' => getenv('POSTGRES_USER') ?: 'bazacvetov24',
+    'password' => getenv('POSTGRES_PASSWORD') ?: 'JVJruro_Xdg456o3ir',
+    'schemaMap' => [
+        'pgsql' => [
+            'class' => 'yii\db\pgsql\Schema',
+            'defaultSchema' => 'erp24' //specify your schema here, public is the default schema
+        ]
+    ], // PostgreSQL
+//    'charset' => 'utf8',
+//    'enableSchemaCache' => true,
+//    'schemaCacheDuration' => 300,
+]: [
+    'class' => yii\db\Connection::class,
+    'dsn' => strtr('mysql:host={host};port={port};dbname={dbname}', [
+        '{host}' => getenv('DB_HOST') ?: '127.0.0.1',
+        '{port}' => getenv('DB_PORT') ?: 3306,
+        '{dbname}' => getenv('DB_SCHEMA') ?: 'erp24',
+    ]),
+    'username' => getenv('DB_USER') ?: 'bazacvetov24',
+    'password' => getenv('DB_PASSWORD') ?: 'JVJruro_Xdg456o3ir',
+    'charset' => 'utf8',
+    'enableSchemaCache' => true,
+    'schemaCacheDuration' => 300,
+
+    // Schema cache options (for production environment)
+    //'enableSchemaCache' => true,
+    //'schemaCacheDuration' => 60,
+    //'schemaCache' => 'cache',
+];
-- 
2.39.5