"""Model for contact."""

from sqlalchemy import Column, Integer, String

from permissions.connectors import mysql


class Contact(mysql.Base):
    """Model for contact."""

    __tablename__ = 'contact'

    contact_id = Column(Integer, primary_key=True)
    contact_first_name = Column(String)
    contact_last_name = Column(String)
    contact_email = Column(String)

    @classmethod
    def create(cls, first_name: str, last_name: str, email: str):
        """Create a contact with the given attributes."""
        return cls(
            contact_first_name=first_name,
            contact_last_name=last_name,
            contact_email=email,
        )