lavkach3

1
import uuid
2
from enum import Enum
3
from typing import Optional
4

5
from sqlalchemy import Sequence, Uuid
6
from sqlalchemy.orm import relationship, mapped_column, Mapped
7

8
from core.db import Base
9
from core.db.mixins import AllMixin
10

11

12
class StoreType(str, Enum):
13
    INTERNAL: str = 'internal'
14
    WMS: str = 'wms'
15

16

17
class Store(Base, AllMixin):
18
    __tablename__ = "store"
19
    lsn_seq = Sequence(f'store_lsn_seq')
20
    id: Mapped[uuid.UUID] = mapped_column(Uuid, primary_key=True, index=True, default=uuid.uuid4)
21
    title: Mapped[str] = mapped_column(index=True)
22
    external_number: Mapped[Optional[str]] = mapped_column(unique=True)
23
    address: Mapped[str]
24
    source: Mapped[str] = mapped_column(default=StoreType.INTERNAL)
25

26

27