add subspesialis query

database/database.go

@@ -1,6 +1,7 @@
 package database
 
 import (
+	"fmt"
 	"log"
 	"os"
 
@@ -9,16 +10,40 @@ import (
 )
 
 var DB *gorm.DB
+var SatuDataDB *gorm.DB
 var err error
 
 func ConnectDB() {
-	dsn := os.Getenv("POSTGRES_DSN")
-	if dsn == "" {
-		log.Fatal("POSTGRES_DSN environment variable not set")
-	}
+	// host := os.Getenv("DB_HOST")
+	// userName := os.Getenv("DB_USERNAME")
+	// password := os.Getenv("DB_PASSWORD")
+	// dbName := os.Getenv("DB_NAME")
+	// port := os.Getenv("DB_PORT")
 
-	DB, err = gorm.Open(postgres.Open(dsn), &gorm.Config{})
+	hostSatuData := os.Getenv("SATUDATA_HOST")
+	userNameSatuData := os.Getenv("SATUDATA_USERNAME")
+	passwordSatuData := os.Getenv("SATUDATA_PASSWORD")
+	dbNameSatuData := os.Getenv("SATUDATA_NAME")
+	portSatuData := os.Getenv("SATUDATA_PORT")
+
+	// dsn := fmt.Sprintf("host=%s user=%s password=%s dbname=%s port=%s sslmode=disable TimeZone=Asia/Jakarta", host, userName, password, dbName, port)
+	// if dsn == "" {
+	// 	log.Fatal("POSTGRES_DSN environment variable not set")
+	// }
+
+	satuData := fmt.Sprintf("host=%s user=%s password=%s dbname=%s port=%s sslmode=disable TimeZone=Asia/Jakarta", hostSatuData, userNameSatuData, passwordSatuData, dbNameSatuData, portSatuData)
+
+	// DB, err = gorm.Open(postgres.Open(dsn), &gorm.Config{})
+	// if err != nil {
+	// 	log.Fatal("Failed to connect to database: ", err)
+	// } else {
+	// 	log.Println("Successfully connected to the database")
+	// }
+
+	SatuDataDB, err = gorm.Open(postgres.Open(satuData), &gorm.Config{})
 	if err != nil {
-		log.Fatal("Failed to connect to database: ", err)
+		log.Fatal("Failed to connect to Satu Data database: ", err)
+	} else {
+		log.Println("Successfully connected to the database")
 	}
 }