ECOM-7501

filter() and exclude() calls made by the serializer after prefetching were causing prefetched data to be discarded. Moving that filtering ahead of the prefetch prevents prefetched data from being discarded and saves many duplicate queries.

ECOM-7301

ECOM-7500

ECOM-6466

ECOM-7531

filter() and exclude() calls made to narrow the set of course runs after prefetching were causing prefetched data to be discarded. This resulted in the endpoint making many duplicate queries. These expensive duplicate queries are eliminated by prefetching the filtered set of course runs instead of prefetching all course runs and then trying to filter them.

ECOM-6473

ECOM-7415

File with size 1mb or less can be added.

ECOM-7469

A course is considered to be "available" if it contains at least one course run that can be enrolled in immediately, is ongoing or yet to start, and appears on the marketing site. The catalog API should only list courses which are available. An earlier attempt at this fell short because it filtered courses to those which contained at least one active *or* marketable run.

ECOM-6473

ECOM-7032

ECOM-7438

ECOM-6815

Chained calls to queryset methods like filter() and exclude() imply a new database query and will cause prefetched results to be ignored. This change is an incremental improvement which more than halves the query count for requests which don't use the marketable_course_runs_only or marketable_enrollable_course_runs_with_archived querystring parameters (from 51 to 22 queries on a system with 1 course and 3 nested course runs). Reducing the query count for requests which do use those parameters requires filtering in Python which mimics the active, marketable, and enrollable queryset methods.

ECOM-7493

ECOM-7493

ECOM-7413

ECOM-7472