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'[source]

class fsi.models.course_attendee.CourseAttendee[source]

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'[source]

es_properties[source]

es_public = False[source]: 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.

id: sqlalchemy.Column[uuid.UUID][source]

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

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

active: sqlalchemy.Column[bool][source]

source_id: sqlalchemy.Column[str | None][source]

first_name: sqlalchemy.Column[str | None][source]

last_name: sqlalchemy.Column[str | None][source]

organisation: sqlalchemy.Column[str | None][source]

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

_email: sqlalchemy.Column[str | None][source]

__str__() → str[source]

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

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

property title: str[source]

property lead: str | None[source]

property is_external: bool[source]

property role: str[source]

property email: str[source]: Needs a switch for external users

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

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][source]: Registered future course events which have been confirmed

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

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

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][source]

possible_course_events(show_hidden: bool = True, show_locked: bool = False) → sqlalchemy.orm.Query[onegov.fsi.models.CourseEvent][source]: Used for the subscription form. Should exclude past courses and courses already registered