core/internal/database/database.go (view raw)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 |
package database import ( "context" "database/sql" "fmt" "log" "os" "strconv" "time" _ "github.com/jackc/pgx/v5/stdlib" _ "github.com/joho/godotenv/autoload" "github.com/wbrijesh/identity/internal/models" "gorm.io/driver/postgres" "gorm.io/gorm" ) type service struct { dbSql *sql.DB db *gorm.DB } var ( database = os.Getenv("DB_DATABASE") password = os.Getenv("DB_PASSWORD") username = os.Getenv("DB_USERNAME") port = os.Getenv("DB_PORT") host = os.Getenv("DB_HOST") schema = os.Getenv("DB_SCHEMA") dbInstance *service ) func New() Service { // Reuse Connection if dbInstance != nil { return dbInstance } connStr := fmt.Sprintf("postgres://%s:%s@%s:%s/%s?sslmode=disable&search_path=%s", username, password, host, port, database, schema) dbSql, err := sql.Open("pgx", connStr) if err != nil { log.Fatal(err) } dbGorm, err := gorm.Open(postgres.Open(connStr), &gorm.Config{}) if err != nil { log.Fatal(err) } dbInstance = &service{ dbSql: dbSql, db: dbGorm, } return dbInstance } // Health checks the health of the database connection by pinging the database. // It returns a map with keys indicating various health statistics. func (s *service) Health() map[string]string { ctx, cancel := context.WithTimeout(context.Background(), 1*time.Second) defer cancel() stats := make(map[string]string) // Ping the database err := s.dbSql.PingContext(ctx) if err != nil { stats["status"] = "down" stats["error"] = fmt.Sprintf("db down: %v", err) log.Fatalf(fmt.Sprintf("db down: %v", err)) // Log the error and terminate the program return stats } // Database is up, add more statistics stats["status"] = "up" stats["message"] = "It's healthy" // Get database stats (like open connections, in use, idle, etc.) dbStats := s.dbSql.Stats() stats["open_connections"] = strconv.Itoa(dbStats.OpenConnections) stats["in_use"] = strconv.Itoa(dbStats.InUse) stats["idle"] = strconv.Itoa(dbStats.Idle) stats["wait_count"] = strconv.FormatInt(dbStats.WaitCount, 10) stats["wait_duration"] = dbStats.WaitDuration.String() stats["max_idle_closed"] = strconv.FormatInt(dbStats.MaxIdleClosed, 10) stats["max_lifetime_closed"] = strconv.FormatInt(dbStats.MaxLifetimeClosed, 10) // Evaluate stats to provide a health message if dbStats.OpenConnections > 40 { // Assuming 50 is the max for this example stats["message"] = "The database is experiencing heavy load." } if dbStats.WaitCount > 1000 { stats["message"] = "The database has a high number of wait events, indicating potential bottlenecks." } if dbStats.MaxIdleClosed > int64(dbStats.OpenConnections)/2 { stats["message"] = "Many idle connections are being closed, consider revising the connection pool settings." } if dbStats.MaxLifetimeClosed > int64(dbStats.OpenConnections)/2 { stats["message"] = "Many connections are being closed due to max lifetime, consider increasing max lifetime or revising the connection usage pattern." } return stats } // Close closes the database connection. // It logs a message indicating the disconnection from the specific database. // If the connection is successfully closed, it returns nil. // If an error occurs while closing the connection, it returns the error. func (s *service) Close() error { log.Printf("Disconnected from database: %s", database) return s.dbSql.Close() } func (s *service) RunMigrations() error { return s.db.AutoMigrate(&models.Admin{}, &models.Application{}, &models.User{}) } |