from sqlalchemy.orm import Mapped
from sqlalchemy.orm import mapped_column
from sqlalchemy.orm import relationship
from .base import Base

from typing import TYPE_CHECKING

if TYPE_CHECKING:
    from isp_connection import IspConnection


class Isp(Base):
    name: Mapped[str]
    manager_name: Mapped[str] = mapped_column(nullable=True)
    manager_phone: Mapped[str] = mapped_column(nullable=True)
    manager_email: Mapped[str] = mapped_column(nullable=True)
    tech_support_phone: Mapped[str] = mapped_column(nullable=True)
    tesh_support_email: Mapped[str] = mapped_column(nullable=True)
    comment: Mapped[str] = mapped_column(nullable=True)

    isp_connections: Mapped[list["IspConnection"]] = relationship(back_populates="isp")