func (db *Db) PersistNewsletter(newsletter *newsletters.Newsletter) { stmt, err := db.connection.Prepare("UPDATE broccoli_newsletters SET title=?, pubdate=? WHERE id = ?") if err != nil { fmt.Printf("There was an error\n") } result, err := stmt.Exec(newsletter.GetTitle(), newsletter.GetPubDate(), newsletter.GetId()) rows_affected, err := result.RowsAffected() if rows_affected == 0 { // Use INSERT stmt, err = db.connection.Prepare("INSERT INTO broccoli_newsletters(title, pubdate) VALUES (?, ?)") _, err = stmt.Exec(newsletter.GetTitle(), newsletter.GetPubDate()) } // Now, store the newsletter sources sources := newsletter.GetSources() sources_lastchecked := newsletter.GetSourcesLastChecked() newsletter_id := newsletter.GetId() for i, src := range sources { src_id := (*src).GetId() // Use update stmt, err = db.connection.Prepare("UPDATE broccoli_newsletters_sources SET newsletter_id=?, source_id=?, source_lastchecked=?") result, err = stmt.Exec(newsletter_id, src_id, sources_lastchecked[i]) rows_affected, err = result.RowsAffected() if rows_affected == 0 { // Use insert stmt, err = db.connection.Prepare("INSERT broccoli_newsletters_sources(newsletter_id, source_id, source_lastchecked) VALUES (?, ?, ?)") _, err = stmt.Exec(newsletter.GetId(), newsletter_id, src_id, sources_lastchecked[i]) } } }