Method List

internal/instructions/store.go:112–138

List returns all instructions (without installs) ordered by name.

(ctx context.Context)

// List returns all instructions (without installs) ordered by name.
func (s *Store) List(ctx context.Context) ([]Instruction, error) {
	if err := s.Init(ctx); err != nil {
		return nil, err
	}
	db, err := s.open()
	if err != nil {
		return nil, err
	}
	defer db.Close()
	rows, err := db.QueryContext(ctx, `SELECT id, name, description, content, created_at, updated_at FROM instructions ORDER BY name`)
	if err != nil {
		return nil, fmt.Errorf("instructions: list: %w", err)
	}
	defer rows.Close()
	var out []Instruction
	for rows.Next() {
		var in Instruction
		var created, updated string
		if err := rows.Scan(&in.ID, &in.Name, &in.Description, &in.Content, &created, &updated); err != nil {
			return nil, fmt.Errorf("instructions: scan: %w", err)
		}
		in.CreatedAt = parseTime(created)
		in.UpdatedAt = parseTime(updated)
		out = append(out, in)
	}
	return out, rows.Err()
}

// ListWithInstalls returns all instructions with their installs populated.
func (s *Store) ListWithInstalls(ctx context.Context) ([]Instruction, error) {