from __future__ import annotations
from onegov.core.orm import Base
from onegov.core.orm.mixins import content_property
from onegov.core.orm.mixins import ContentMixin
from onegov.core.orm.mixins import TimestampMixin
from onegov.core.orm.types import UUID
from sqlalchemy import Column
from sqlalchemy import Integer
from uuid import uuid4
from typing import TYPE_CHECKING
if TYPE_CHECKING:
import uuid
from onegov.core.orm.mixins import dict_property
[docs]
class RateSet(Base, ContentMixin, TimestampMixin):
""" Sätze """
[docs]
__tablename__ = 'pas_rate_sets'
#: Internal ID
[docs]
id: Column[uuid.UUID] = Column(
UUID, # type:ignore[arg-type]
primary_key=True,
default=uuid4
)
#: The year
[docs]
year: Column[int] = Column(
Integer,
nullable=False
)
[docs]
cost_of_living_adjustment: dict_property[float]
cost_of_living_adjustment = content_property(default=0.0)
# The rates, naming schema is {attendence}_{commission}_{role}_{time}
[docs]
plenary_none_president_halfday: dict_property[int]
plenary_none_president_halfday = content_property(default=0)
[docs]
plenary_none_member_halfday: dict_property[int]
plenary_none_member_halfday = content_property(default=0)
[docs]
commission_normal_president_initial: dict_property[int]
commission_normal_president_initial = content_property(default=0)
[docs]
commission_normal_president_additional: dict_property[int]
commission_normal_president_additional = content_property(default=0)
[docs]
commission_normal_member_initial: dict_property[int]
commission_normal_member_initial = content_property(default=0)
[docs]
commission_normal_member_additional: dict_property[int]
commission_normal_member_additional = content_property(default=0)
[docs]
commission_intercantonal_president_halfday: dict_property[int]
commission_intercantonal_president_halfday = content_property(default=0)
[docs]
commission_intercantonal_member_halfday: dict_property[int]
commission_intercantonal_member_halfday = content_property(default=0)
[docs]
commission_official_president_halfday: dict_property[int]
commission_official_president_halfday = content_property(default=0)
[docs]
commission_official_president_fullday: dict_property[int]
commission_official_president_fullday = content_property(default=0)
[docs]
commission_official_vice_president_halfday: dict_property[int]
commission_official_vice_president_halfday = content_property(default=0)
[docs]
commission_official_vice_president_fullday: dict_property[int]
commission_official_vice_president_fullday = content_property(default=0)
[docs]
shortest_all_president_halfhour: dict_property[int]
shortest_all_president_halfhour = content_property(default=0)
[docs]
shortest_all_member_halfhour: dict_property[int]
shortest_all_member_halfhour = content_property(default=0)
[docs]
study_normal_president_halfhour: dict_property[int]
study_normal_president_halfhour = content_property(default=0)
[docs]
study_normal_member_halfhour: dict_property[int]
study_normal_member_halfhour = content_property(default=0)
[docs]
study_intercantonal_president_hour: dict_property[int]
study_intercantonal_president_hour = content_property(default=0)
[docs]
study_intercantonal_member_hour: dict_property[int]
study_intercantonal_member_hour = content_property(default=0)
[docs]
study_official_president_halfhour: dict_property[int]
study_official_president_halfhour = content_property(default=0)
[docs]
study_official_member_halfhour: dict_property[int]
study_official_member_halfhour = content_property(default=0)