https://medium.com/canopas/automation-dynamic-sitemap-generation-with-golang-api-584f6c53ea9c - jobs

jobs.go

package jobs

import (
	"db"
  
	log "github.com/sirupsen/logrus"
)

type Job struct {
	Id          int    `json:"id"`
	Title       string `json:"title"`
	Description string `json:"description"`
}

func GetJobs() (jobs []Job, err error) {
	err = db.Select(&jobs, `SELECT id, title, description FROM jobs WHERE is_active = 1`)
	if err != nil {
		log.Error(err)
		return nil, err
	}
	return jobs, nil
}