func addTagsToSitemap(buf *bytes.Buffer, db *orm.DB, opt *app.Options) error { sql := "SELECT {id} AS ID, {name} AS Name, {title} AS Title, {description} AS Description FROM #tags" rows, err := db.Query(true, sql) if err != nil { return err } defer rows.Close() tags := make([]*front.Tag, 0, 100) if _, err := fetch.Obj(&tags, rows); err != nil { return err } now := time.Now().Unix() for _, tag := range tags { addItemToSitemap(buf, tag.Permalink(), opt.TagsChangefreq, now, opt.TagsPriority) } return nil }
func addPostsToSitemap(buf *bytes.Buffer, db *orm.DB, opt *app.Options) error { sql := `SELECT {id} AS ID, {name} AS Name, {title} AS Title, {summary} AS Summary, {content} AS Content, {created} AS Created, {modified} AS Modified FROM #posts WHERE {state}=?` rows, err := db.Query(true, sql, models.PostStatePublished) if err != nil { return err } defer rows.Close() posts := make([]*front.Post, 0, 100) if _, err := fetch.Obj(&posts, rows); err != nil { return err } for _, p := range posts { addItemToSitemap(buf, p.Permalink(), opt.PostsChangefreq, p.Modified, opt.PostsPriority) } return nil }