2 ms·
sqlx + squirrel: func dbAllPostsInTag(db *sqlx.DB, tagID int64) ([]post, error) { posts := []post{} query := squirrel.Select("Post.postID,
by d0100 7y ago
sqlx + squirrel:
func dbAllPostsInTag(db *sqlx.DB, tagID int64) ([]post, error) {
posts := []post{}
query := squirrel.Select("Post.postID, Post.published, Post.title, Post.content").
From("Post").
Join("PostTag using(postID)").
Where(sq.Eq{"tagID ": tagID})
qSQL, args, err := query.ToSql()
if err != nil {
return nil, errors.Wrap(err, "Error generating dbAllPostsInTag sql")
}
err = db.Select(&posts, qSQL, args...)
if err != nil {
return nil, errors.Wrap(err, "Error listing dbAllPostsInTag")
}
return posts, nil
}