winterthur.models.mission_report

Attributes

MissionType
MISSION_TYPES

Classes

MissionReportFile	A general file (image, document, pdf, etc), referenced in the database.
MissionReport	Mixin providing a meta/content JSON pair. Meta is a JSON column loaded
MissionReportVehicle	Mixin providing a meta/content JSON pair. Meta is a JSON column loaded
MissionReportVehicleUse	Many to many association between vehicles and reports.

Module Contents

type winterthur.models.mission_report.MissionType = Literal['single', 'multi']

winterthur.models.mission_report.MISSION_TYPES: tuple[MissionType, Ellipsis] = ('single', 'multi')

class winterthur.models.mission_report.MissionReportFile

Bases: onegov.file.File

A general file (image, document, pdf, etc), referenced in the database.

Thanks to the use of Depot files can be seemingly stored in the database (with transaction guarantees), without actually storing it in the database.

__mapper_args__

class winterthur.models.mission_report.MissionReport

Bases: onegov.core.orm.Base, onegov.core.orm.mixins.ContentMixin, onegov.org.models.AccessExtension

Mixin providing a meta/content JSON pair. Meta is a JSON column loaded with each request, content is a JSON column loaded deferred (to be shown only in the detail view).

__tablename__ = 'mission_reports'

id: sqlalchemy.Column[uuid.UUID]

date: sqlalchemy.Column[datetime.datetime]

duration: sqlalchemy.Column[decimal.Decimal]

nature: sqlalchemy.Column[str]

location: sqlalchemy.Column[str]

personnel: sqlalchemy.Column[int]

backup: sqlalchemy.Column[int]

civil_defence: sqlalchemy.Column[bool]

pictures = None

mission_count: sqlalchemy.Column[int]

mission_type: sqlalchemy.Column[MissionType]

used_vehicles: sqlalchemy.orm.relationship[list[MissionReportVehicleUse]]

property title: str

property readable_duration: str

property local_date: datetime.datetime

class winterthur.models.mission_report.MissionReportVehicle

Bases: onegov.core.orm.Base, onegov.core.orm.mixins.ContentMixin, onegov.org.models.AccessExtension

Mixin providing a meta/content JSON pair. Meta is a JSON column loaded with each request, content is a JSON column loaded deferred (to be shown only in the detail view).

__tablename__ = 'mission_report_vehicles'

id: sqlalchemy.Column[uuid.UUID]

name: sqlalchemy.Column[str]

description: sqlalchemy.Column[str]

symbol = None

website: sqlalchemy.Column[str | None]

uses: sqlalchemy.orm.relationship[list[MissionReportVehicleUse]]

property title: str

property readable_website: str | None

class winterthur.models.mission_report.MissionReportVehicleUse

Bases: onegov.core.orm.Base

Many to many association between vehicles and reports.

__tablename__ = 'mission_report_vehicle_usees'

mission_report_id: sqlalchemy.Column[uuid.UUID]

mission_report: sqlalchemy.orm.relationship[MissionReport]

vehicle_id: sqlalchemy.Column[uuid.UUID]

vehicle: sqlalchemy.orm.relationship[MissionReportVehicle]

count