Gorm How to create foreign key for embedded hasmany relation during migration?

Your Question

How to create foreign key for embedded hasmany relation during migration? For example:

type VirtualMachine struct {
    gorm.Model
    AccountID uint
    Account   Account
}

type Disk struct {
    gorm.Model
    AccountID uint
    Account   Account
}

type Database struct {
    gorm.Model
    AccountID uint
    Account   Account
}

type Domain struct {
    gorm.Model
    AccountID uint
    Account   Account
}

type Resources struct {
    VirtualMachines []*VirtualMachine
    Disks           []*Disk
    Databases       []*Database
    Domains         []*Domain
}

type Account struct {
    gorm.Model
    Name string
    Resources
}

func main() {
    db, err := gorm.Open(sqlite.Open("gorm.db"), &gorm.Config{})
    check(err)
    err = db.AutoMigrate(&Account{}, &VirtualMachine{}, &Disk{}, &Database{}, &Domain{})
    check(err)
}

func check(err error) {
    if err != nil {
        panic(err)
    }
}

GORM will not create foreign keys virtual_machine.account_id -> account.id and so on. This is caused by: https://github.com/go-gorm/gorm/blob/9d82aa56734999bb28e0c4d60fba69ae7cde66d5/schema/relationship.go#L95-L96. So, if I move fields in Resources to Account, GORM will create foreign keys, but can I keep Resources struct independent?

The document you expected this should be explained

Expected answer

The solution that I can keep Resources struct independent, and GORM also creates foreign keys.

Comment From: github-actions[bot]

This issue has been automatically marked as stale because it has been open 360 days with no activity. Remove stale label or comment or this will be closed in 180 days