How do i close database instance in gorm 1.20.0

Question

As i have not found in Close() function with *gorm instance, any help would be appreciated

dbURI := fmt.Sprintf("user=%s password=%s dbname=%s port=%s sslmode=%s TimeZone=%s",
    "username", "password", "dbname", "5432", "disable", "Asia/Kolkata")
fmt.Println(dbURI)
connection, err := gorm.Open(postgres.Open(dbURI), &gorm.Config{})

if err != nil {
    fmt.Println("Error connecting database")
    panic(err.Error())
} else {
    fmt.Println("Connected to database")
}

Note: connection.Close() is not available for GORM 1.20.0

May I ask why you want to close it? – Alejandro Lorefice Sep 09 '20 at 17:23 — Alejandro Lorefice, Sep 09 '20 at 17:23

score 24 · Answer 1 · edited Jul 05 '21 at 14:54

24

Jinzhu decided to eliminate the Close() method on version 1.20 because GORM supports connection pooling, so the correct use would be to open a connection and share it within your application.

If your specific use-case still requires to use the Close() method, GORM provides the method DB that returns a db generic_interface where you can use it.

For the example

sqlDB, err := db.DB()

// Close
sqlDB.Close()

edited Jul 05 '21 at 14:54

Aditya Kresna Permana

11,869
8
42
48

answered Sep 09 '20 at 18:24

Alejandro Lorefice

797
1
5
18

May that's the reason i have not found any Close() method with it – Rohan Shukla Sep 10 '20 at 11:28

score 8 · Answer 2 · edited Jul 02 '21 at 09:51

8

I think you can use below codes to close your database connection:

sqlDB, err := connection.DB()
if err != nil {
    log.Fatalln(err)
}
defer sqlDB.Close()

edited Jul 02 '21 at 09:51

Max Base

639
1
7
15

answered Sep 10 '20 at 03:06

Tho Quach

1,347
10
26

1

I Guess Close() is not available from 1.20.0 – Rohan Shukla Sep 10 '20 at 11:29
I do not close the connection, i close the connection.DB(), and i already assigned it to sqlDB – Tho Quach Nov 27 '20 at 16:43
The defer sqlDB.Close() is the best way which enables us to close the connection once the whole code runs completely – Codertjay Oct 12 '22 at 15:58

score 2 · Answer 3 · answered Nov 03 '22 at 07:31

Gorm v2 provides a method to close the db connection.

Here is an example:

db, err := gorm.Open(sqlite.Open(dbFile), &gorm.Config{
    Logger: logger.Default.LogMode(logger.Silent),
})
if err != nil {
    t.Error(err)
}

defer func() {
    dbInstance, _ := db.DB()
    _ = dbInstance.Close()
}()

How do i close database instance in gorm 1.20.0

3 Answers3

Related