func (pg *PostgresDBManager) SaveFeed(feed *models.Feed) bool {
var feedStmt, itemStmt *sql.Stmt
var err error
var randID uuid.UUID
// save feed to db
feedStmt, err = pg.db.Prepare("INSERT INTO feeds VALUES($1, $2, $3, $4, $5, $6, $7)")
if err != nil {
log.Fatal(err)
return false
}
// add id
randID, err = uuid.V4()
if err != nil {
log.Fatal(err)
return false
}
feed.ID = randID.String()
_, err = feedStmt.Exec(feed.ID, feed.Title, feed.Description, feed.URL, feed.FeedURL, feed.LastPubDate, feed.ImageURL)
if err != nil {
log.Fatal(err)
return false
}
// save feed Items
itemStmt, err = pg.db.Prepare("INSERT INTO feed_items VALUES($1, $2, $3, $4, $5, $6, $7, $8)")
if err != nil {
log.Fatal(err)
return false
}
for _, item := range feed.Items {
randID, err = uuid.V4()
if err != nil {
log.Fatal(err)
return false
}
item.ID = randID.String()
_, err = itemStmt.Exec(item.ID, item.Title, item.Description, item.URL, item.MediaURL, item.PubDate, item.ImageURL, feed.ID)
if err != nil {
log.Fatal(err)
return false
}
}
return true
}
