如何将记录插入到具有gorm的现有多个表中

Question

I have two tables

type Podcast struct {
    Id       int
    Title    string
    RssUrl   string `sql:"unique_index"`
    Episodes []Episode
}

type Episode struct {
    Id         int
    PodcastID  int
    Title      string
    Url        string `sql:"unique_index"`
    Downloaded bool
}

I know how to insert episodes into a new podcast like so.

podcast := Podcast{
    Title:    "My Podcast",
    RssUrl:   "http://example.com/feed/",
    Url:      "http://www.example.com",
    Episodes: []Episode{{
        Title:      "Episode One Point Oh!", 
        Url:        "http://www.example.com/one-point-oh", 
        Downloaded: false,
    }},
}

db.Create(&podcast)

How do I go about adding episodes to a podcast that already exists later on?

Answer 1

I was able to figure it out.

var id int
row := db.Table("podcasts").Where("id = ?", 1).Select("id").Row()
row.Scan(&id)

episode := Episode{
    Title:      "Episode Two!",
    Url:        "http://www.example.com/episode-two",
    Downloaded: true,
    PodcastID:  id,
}

db.Create(&episode)