Insert Array of Structs into DB using gorm

Question

I need to insert into a Postgresql database using gorm. But the struct in question has fields containing arrays of custom types:

type VideoFile struct {
    UID      string
    FileName string
    Format   string
    Path     string
}


type myStruct struct {
    ID                string
    UserId            uint64
    UserType          int
    FaceVideoFiles    []VideoFile
    MeetingVideoFiles []VideoFile
}

func (r *videoRepo) CreateRecord(input *myStruct) error {
    tx := r.base.GetDB().Begin()
    err := tx.Create(input).Error
    if err != nil {
        tx.Rollback()
        return err
    }
    tx.Commit()
    return nil
}

ID field is the primary key in database. I am not sure which tags to add to the struct fields so I leave it empty here (e.g. gorm:"primaryKey" json:"id", etc). If the FaceVideoFiles is not an array of struct, things seem to work, but that is not the case with an array of struct. What should I do so that I can insert those arrays of structs (not individual structs) into my database?

Eddwin Paz · Accepted Answer · 2022-07-28 04:38:06Z

1

You have to use one to many. More information related to this. Please follow documentation. https://gorm.io/docs/has_many.html#Has-Many

type Dog struct {
  ID   int
  Name string
  Toys []Toy `gorm:"polymorphic:Owner;"`
}

type Toy struct {
  ID        int
  Name      string
  OwnerID   int
  OwnerType string
}

db.Create(&Dog{Name: "dog1", Toys: []Toy{{Name: "toy1"}, {Name: "toy2"}}})
// INSERT INTO `dogs` (`name`) VALUES ("dog1")
// INSERT INTO `toys` (`name`,`owner_id`,`owner_type`) VALUES ("toy1","1","dogs"), ("toy2","1","dogs")

answered Jul 28, 2022 at 4:38

Eddwin Paz

2,8885 gold badges32 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mike Abbey Over a year ago

Forgot to mention, but myStruct is also the model for my database table, the only single at the moment. From your reply, I suppose I have to make other separate table(s) to house record about individual videos, then draw a one-to-many relationship with my current single table?

Collectives™ on Stack Overflow

Insert Array of Structs into DB using gorm

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related