ejemplo.go

type MateriaConConteoDeTarea struct {
	Conteo    int64  `json:"conteo"`
	Materia   string `json:"materia"`
	IdMateria string `json:"idMateria"`
}


func obtenerMateriasConConteoDeTareas(idPeriodo int64) ([]MateriaConConteoDeTarea, error) {
	materias := []MateriaConConteoDeTarea{}
	bd, err := obtenerBd()
	if err != nil {
		return materias, err
	}
	defer bd.Close()
	rows, err := bd.Raw(`select count(*) AS conteo,
materia.nombre AS materia, materia.id AS id_materia from tareas
inner join materia on materia.id = tareas.id_materia
where id_periodo = ? group by materia.id;`, idPeriodo).
		Rows()
	if err != nil {
		return materias, err
	}
	defer rows.Close()
	for rows.Next() {
		var m MateriaConConteoDeTarea
		bd.ScanRows(rows, &m)
		if err != nil {
			return materias, err
		}
		materias = append(materias, m)
	}
	return materias, bd.Error
}