from __future__ import annotations
from onegov.core.orm import Base
from onegov.core.orm.mixins import dict_markup_property
from onegov.core.orm.mixins import ContentMixin
from onegov.core.orm.mixins import TimestampMixin
from onegov.core.orm.types import UUID
from onegov.search import ORMSearchable
from sqlalchemy import Column
from sqlalchemy import Date
from sqlalchemy import Text
from sqlalchemy.orm import relationship
from uuid import uuid4
from typing import TYPE_CHECKING
if TYPE_CHECKING:
import uuid
from datetime import date
from onegov.pas.models.parliamentarian_role import ParliamentarianRole
[docs]
class ParliamentaryGroup(Base, ContentMixin, TimestampMixin, ORMSearchable):
""" Fraktion """
[docs]
__tablename__ = 'pas_parliamentary_groups'
[docs]
es_properties = {'name': {'type': 'text'}}
@property
[docs]
def es_suggestion(self) -> str:
return self.name
@property
[docs]
def title(self) -> str:
return self.name
#: Internal ID
[docs]
id: Column[uuid.UUID] = Column(
UUID, # type:ignore[arg-type]
primary_key=True,
default=uuid4
)
#: External ID
[docs]
external_kub_id: Column[uuid.UUID | None] = Column(
UUID, # type:ignore[arg-type]
nullable=True,
default=uuid4,
unique=True
)
#: the name
[docs]
name: Column[str] = Column(
Text,
nullable=False
)
#: The start date
[docs]
start: Column[date | None] = Column(
Date,
nullable=True
)
#: The end date
[docs]
end: Column[date | None] = Column(
Date,
nullable=True
)
#: The description
[docs]
description = dict_markup_property('content')
#: A parliamentary group may have n role
[docs]
roles: relationship[list[ParliamentarianRole]]
roles = relationship(
'ParliamentarianRole',
cascade='all, delete-orphan',
back_populates='parliamentary_group'
)
[docs]
def __repr__(self) -> str:
return f'<ParliamentaryGroup {self.name}>'