fsi.collections.audit

Attributes

T

Classes

AuditCollection

Displays the list of attendees filtered by a course and organisation

Module Contents

fsi.collections.audit.T

class fsi.collections.audit.AuditCollection(session: sqlalchemy.orm.Session, course_id: uuid.UUID | None, auth_attendee: onegov.fsi.models.CourseAttendee, organisations: list[str] | None = None, letter: str | None = None, page: int = 0, exclude_inactive: bool = True)

Bases: onegov.core.collection.GenericCollection[AuditRow], onegov.core.collection.Pagination[AuditRow]

Displays the list of attendees filtered by a course and organisation for evaluation if they subscribed and completed a course event.

The organisation filter should also be exact and not fuzzy.

batch_size = 20

page = 0

course_id

auth_attendee

organisations = []

letter = None

exclude_inactive = True

subset() → sqlalchemy.orm.Query[AuditRow]

Returns an SQLAlchemy query containing all records that should be considered for pagination.

property page_index: int

Returns the current page index (starting at 0).

page_by_index(index: int) → Self

Returns the page at the given index. A page here means an instance of the class inheriting from the Pagination base class.

by_letter_and_orgs(letter: str | None = None, orgs: list[str] | None = None) → Self

by_letter(letter: str | None) → Self

__eq__(other: object) → bool

Returns True if the current and the other Pagination instance are equal. Used to find the current page in a list of pages.

ranked_subscription_query(past_only: bool = True) → sqlalchemy.orm.Query[RankedSubscriptionRow]

Ranks all subscriptions of all events of a course windowed over the attendee_id and ranked after completed, most recent Use this query to make a join with any collection of attendees.

last_subscriptions() → sqlalchemy.orm.Query[LastSubscriptionRow]

Retrieve the last completed subscription by attemdee for a given the course_id.

filter_attendees_by_role(query: sqlalchemy.orm.Query[T]) → sqlalchemy.orm.Query[T]

Filter permissions of editor, exclude external,

query() → sqlalchemy.orm.Query[AuditRow]

next_subscriptions(request: onegov.fsi.request.FsiRequest) → dict[uuid.UUID, tuple[str, datetime.datetime]]

property model_class: type[onegov.fsi.models.CourseAttendee]

property course: onegov.fsi.models.Course | None

property used_letters: list[str]

Returns a list of all the distinct first letters of the peoples last names.

property relevant_courses: tuple[tuple[uuid.UUID, str], Ellipsis]