// WARNING: Mutation of newsletter here
func (db *Db) FetchNewsletterSources(newsletter *newsletters.Newsletter) {
output, err := db.connection.Query("SELECT source_id, source_lastchecked FROM broccoli_newsletters_sources WHERE newsletter_id = ?", newsletter.GetId())
if err != nil {
fmt.Printf("There was an error fetching all the source IDs\n%s\n", err)
}
for output.Next() {
var source_id int
var source_lastchecked int64
output.Scan(&source_id, &source_lastchecked)
fmt.Printf("Source last checked = %d\n", source_lastchecked)
source := db.FetchSource(source_id)
newsletter.AddSource(source, source_lastchecked)
}
}
