fsi.models.course_attendee

Attributes

external_attendee_org

Classes

CourseAttendee

Comprises the user base mirrored by one-to-one relationship with

Module Contents

fsi.models.course_attendee.external_attendee_org = 'Externe Kursteilnehmer'

class fsi.models.course_attendee.CourseAttendee

Bases: onegov.core.orm.Base, onegov.search.ORMSearchable

Comprises the user base mirrored by one-to-one relationship with onegov.user.User which is linked to the LDAP System including external users, that are created by an admin role.

The onegov.user.User model should only contain email and role and is only used for authentication and permissions.

All other attributes should be stored in here.

Entries - external attendees: the do not have a link to a user - CourseAttendees linked to an admin role, aka Kursverantwortlicher - CourseAttendess linked to a member role, aka Kursbesucher

__tablename__ = 'fsi_attendees'

fts_public = False

Returns True if the model is available to be found by the public. If false, only editors/admins will see this object in the search results.

fts_properties

id: sqlalchemy.Column[uuid.UUID]

user_id: sqlalchemy.Column[uuid.UUID | None]

user: sqlalchemy.orm.relationship[onegov.user.User | None]

active: sqlalchemy.Column[bool]

source_id: sqlalchemy.Column[str | None]

first_name: sqlalchemy.Column[str | None]

last_name: sqlalchemy.Column[str | None]

organisation: sqlalchemy.Column[str | None]

permissions: sqlalchemy.Column[list[str] | None]

_email: sqlalchemy.Column[str | None]

__str__() → str

meta: sqlalchemy.Column[dict[str, Any] | None]

subscriptions: sqlalchemy.orm.relationship[onegov.core.types.AppenderQuery[fsi.models.course_subscription.CourseSubscription]]

property title: str

property lead: str | None

property is_external: bool

property role: str

property email: str

Needs a switch for external users

property course_events: sqlalchemy.orm.Query[onegov.fsi.models.CourseEvent]

Will return the query for not completed (future) courses events

the attendee has a subscription record.

property confirmed_course_events: sqlalchemy.orm.Query[onegov.fsi.models.CourseEvent]

Registered future course events which have been confirmed

property total_done_course_events: sqlalchemy.orm.Query[onegov.fsi.models.CourseSubscription]

property repeating_courses: sqlalchemy.orm.Query[onegov.fsi.models.CourseEvent]

Will return query to filter for all upcoming courses the attendee has to refresh.

This is necessary to answer: if one course, how many course events has an attendee: a) not registered if he had to or b) from the perspective of a course_event, was there a succeeding course event in the range of the refresh interval?

property undone_registered_courses: sqlalchemy.orm.Query[onegov.fsi.models.CourseEvent]

possible_course_events(show_hidden: bool = True, show_locked: bool = False) → sqlalchemy.orm.Query[onegov.fsi.models.CourseEvent]

Used for the subscription form. Should exclude past courses and courses already registered