Got [error] failed to initialize database, got error dial tcp 192.168.16.2:3306: connect: connection refused when run docker compose up -d docker-compose.yml version: "3" services: app: container_name: app build: context: . dockerfile: api.Dockerfile restart: always ports: - 8071:8080 environment: - GIN_MODE=$GIN_MODE…
i have a many to many relation like a customers and orders. type EmployeeShiftList struct { ID uint UUID uuid.UUID `gorm:"<-:create"` FirstName string `validate:"required,max=250"` LastName string `validate:"omitempty,max=250"` ShiftMaps []ShiftMap `gorm:"many2many:attendance.employee_shifts;foreignKey:ID;References:ShiftID;joinForeignKey:EmployeeID;joinReferences:ShiftID"} type ShiftMap struct { ShiftID uint `gorm:"primaryKey"` FromDate time.Time ToDate…
this is what my playlist and user's models looks like type Playlist struct { ID uuid.UUID `json:"id" gorm:"primaryKey;type:uuid;default:gen_random_uuid()"` CreatedAt time.Time `json:"created_at"` UpdatedAt time.Time `json:"updated_at"` DeletedAt gorm.DeletedAt `json:"deleted_at" gorm:"index"` Title string `json:"title" gorm:"not null"` // Many 2 many with Back Reference…
I have a table in Postgres id title ..... 1 title1 ..... 2 title2 ..... 3 title1 ..... 4 title13 ..... 5 title4 ..... 6 title7 ..... 7 title1 ..... 8 title1 ..... 9 title53 ..... 10 title11 ..... 11…
I have question regarding fetching foreign key in GORM. I am using golang and POSTGRES for my database. AFAIK, Preload(clause.Associations) will fetch the foreign key from our database. If we are using Gorm .Find(&model), its automatically fetching my foreign key…
I am trying to set foreign key in the data models using gorm this is the code that I have written package main import ( "log" "database/sql/driver" "encoding/json" "errors" "time" "gorm.io/driver/postgres" "gorm.io/gorm" ) type JSONB map[string]interface{} func (j JSONB) Value()…
I tried creating a simple go rest api. I use the Gorm library for DB handling, but it fails connecting to the DB in the container. I feel like this could be an issue of Docker on Apple silicon, but…
I am pretty new to golang and gorm so, probably, this is an old question: I have a table in postgresql named datetime with type timestamp I am trying to retrieve it using gorm in a golang project with this…
In GORM documentation there is an example how to use LIKE conditions: // LIKE db.Where("name LIKE ?", "%jin%").Find(&users) // SELECT * FROM users WHERE name LIKE '%jin%'; The problem that I have with this approach is that if jin is…
My DB connection and its getter is as follow: func connectDB() (*gorm.DB, error) { db, err := gorm.Open(postgres.Open(dbURL), &gorm.Config{}) if err != nil { return nil, err } return db, nil } func GetDB() (*gorm.DB, error) { if db ==…