Method GetSessions

pkg/session/store.go:819–850

GetSessions retrieves all root sessions (excludes sub-sessions)

(ctx context.Context)

// GetSessions retrieves all root sessions (excludes sub-sessions)
func (s *SQLiteSessionStore) GetSessions(ctx context.Context) ([]*Session, error) {
	rows, err := s.db.QueryContext(ctx,
		"SELECT "+sessionSelectColumns+" FROM sessions WHERE parent_id IS NULL OR parent_id = '' ORDER BY created_at DESC")
	if err != nil {
		return nil, err
	}
	defer rows.Close()

	// Collect sessions first to close the rows before loading items
	var sessions []*Session
	for rows.Next() {
		session, err := scanSession(rows)
		if err != nil {
			return nil, err
		}
		sessions = append(sessions, session)
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}

	// Load messages for each session
	for _, session := range sessions {
		items, err := s.loadSessionItems(ctx, s.db, session.ID)
		if err != nil {
			return nil, fmt.Errorf("loading items for session %s: %w", session.ID, err)
		}
		session.Messages = items
	}

	return sessions, nil
}

// GetSessionSummaries retrieves lightweight session metadata for listing (excludes sub-sessions).
// This is much faster than GetSessions as it doesn't load message content.