blob: fef670590d9c92f500d163d1cbbc37cc1cbd70c1 (
plain)
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
|
package database
import (
"metachan/config"
"metachan/enums"
"metachan/utils/logger"
"time"
"gorm.io/driver/mysql"
"gorm.io/driver/postgres"
"gorm.io/driver/sqlite"
"gorm.io/driver/sqlserver"
"gorm.io/gorm"
gormlogger "gorm.io/gorm/logger"
)
var DB *gorm.DB
func init() {
var dialector gorm.Dialector
switch enums.DatabaseDriver(config.Database.Driver) {
case enums.SQLite:
dialector = sqlite.Open(config.Database.DSN)
case enums.MySQL:
dialector = mysql.Open(config.Database.DSN)
case enums.Postgres:
dialector = postgres.Open(config.Database.DSN)
case enums.SQLServer:
dialector = sqlserver.Open(config.Database.DSN)
default:
logger.Fatalf("Database", "Invalid database driver: %s", config.Database.Driver)
}
var err error
DB, err = gorm.Open(dialector, &gorm.Config{
Logger: gormlogger.Default.LogMode(gormlogger.Silent),
})
if err != nil {
logger.Fatalf("Database", "Error connecting to database: %v", err)
}
sqlDB, err := DB.DB()
if err != nil {
logger.Fatalf("Database", "Failed to get underlying sql.DB: %v", err)
}
sqlDB.SetMaxOpenConns(25)
sqlDB.SetMaxIdleConns(5)
sqlDB.SetConnMaxLifetime(time.Hour)
logger.Successf("Database", "Database connection established successfully")
migrate()
}
|
