Golang defer db.close() undenified (has no field or method)

Question

I have below code its giving undefined error on the defer db.close(). unsure how to fix this error.

Any help to resolve this error?

error run code :

./main.go:24:11: db.Close undefined (type *gorm.DB has no field or method Close)

code :

package main

import (
    "fmt"
    "gorm.io/driver/postgres"
    "gorm.io/gorm"
)

type User struct {
    ID   uint
    Name string
}

func main() {

    // Konfigurasi koneksi ke database
    dsn := "user=my-user password=my-password dbname=my-db host=my-host port=5432 sslmode=require"

    // Membuka koneksi ke database
    db, err := gorm.Open(postgres.Open(dsn), &gorm.Config{})
    if err != nil {
        panic("Failed to connect to database")
    }
    defer db.Close()

    fmt.Println("Successfully connected to the database")

    // Melakukan migrasi (opsional, tergantung kebutuhan)
    db.AutoMigrate(&User{})

    // Contoh operasi mengambil data
    var users []User
    db.Find(&users)

    fmt.Println("Users:")
    for _, user := range users {
        fmt.Printf("ID: %d, Name: %s\n", user.ID, user.Name)
    }
}

I am stuck on *gorm.DB has no field on method Close

Golang defer db.close() undenified (has no field or method)

0 Answers0