1
|
|
|
""" |
2
|
|
|
byceps.services.user.dbmodels.detail |
3
|
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
4
|
|
|
|
5
|
|
|
:Copyright: 2014-2024 Jochen Kupperschmidt |
6
|
|
|
:License: Revised BSD (see `LICENSE` file for details) |
7
|
|
|
""" |
8
|
|
|
|
9
|
1 |
|
from datetime import date |
10
|
|
|
from typing import Any |
11
|
1 |
|
|
12
|
1 |
|
from sqlalchemy.ext.mutable import MutableDict |
13
|
|
|
from sqlalchemy.orm import Mapped, mapped_column, relationship |
14
|
1 |
|
|
15
|
1 |
|
from byceps.database import db |
16
|
|
|
from byceps.services.user.models.user import UserID |
17
|
1 |
|
from byceps.util.instances import ReprBuilder |
18
|
1 |
|
|
19
|
1 |
|
|
20
|
|
|
class DbUserDetail(db.Model): |
21
|
|
|
"""Detailed information about a specific user.""" |
22
|
1 |
|
|
23
|
|
|
__tablename__ = 'user_details' |
24
|
|
|
|
25
|
1 |
|
user_id: Mapped[UserID] = mapped_column( |
26
|
|
|
db.Uuid, db.ForeignKey('users.id'), primary_key=True |
27
|
1 |
|
) |
28
|
|
|
user: Mapped['DbUser'] = relationship( # noqa: F821, UP037 |
29
|
|
|
'DbUser', backref=db.backref('detail', uselist=False) |
30
|
1 |
|
) |
31
|
|
|
first_name: Mapped[str | None] = mapped_column(db.UnicodeText) |
32
|
|
|
last_name: Mapped[str | None] = mapped_column(db.UnicodeText) |
33
|
1 |
|
date_of_birth: Mapped[date | None] |
34
|
|
|
country: Mapped[str | None] = mapped_column(db.UnicodeText) |
35
|
|
|
zip_code: Mapped[str | None] = mapped_column(db.UnicodeText) |
36
|
1 |
|
city: Mapped[str | None] = mapped_column(db.UnicodeText) |
37
|
|
|
street: Mapped[str | None] = mapped_column(db.UnicodeText) |
38
|
|
|
phone_number: Mapped[str | None] = mapped_column(db.UnicodeText) |
39
|
1 |
|
internal_comment: Mapped[str | None] = mapped_column(db.UnicodeText) |
40
|
1 |
|
extras: Mapped[Any | None] = mapped_column(MutableDict.as_mutable(db.JSONB)) |
41
|
|
|
|
42
|
|
|
@property |
43
|
1 |
|
def full_name(self) -> str | None: |
44
|
|
|
names = [self.first_name, self.last_name] |
45
|
|
|
return ' '.join(filter(None, names)) or None |
46
|
1 |
|
|
47
|
1 |
|
def __repr__(self) -> str: |
48
|
1 |
|
return ( |
49
|
|
|
ReprBuilder(self) |
50
|
|
|
.add_with_lookup('user_id') |
51
|
1 |
|
.add_with_lookup('first_name') |
52
|
|
|
.add_with_lookup('last_name') |
53
|
|
|
.build() |
54
|
|
|
) |
55
|
|
|
|