Method FindByCourseID

13-GraphQL/internal/database/category.go:47–55

(courseID string)

}

func (c *Category) FindByCourseID(courseID string) (Category, error) {
    var id, name, description string
    err := c.db.QueryRow("SELECT c.id, c.name, c.description FROM categories c JOIN courses co ON c.id = co.category_id WHERE co.id = $1", courseID).
    Scan(&id, &name, &description)
    if err != nil {
        return Category{}, err
    }
    return Category{ID: id, Name: name, Description: description}, nil
}