from sqlalchemy import (
    Column,
    String,
    DateTime,
    Boolean,
    func,
)

from community_qa_bot.db import Base
from community_qa_bot.types import Platform


class User(Base):
    id = Column(String(50), primary_key=True)
    username = Column(String(100))
    display_name = Column(String(100))
    real_name = Column(String(100))
    name = Column(String(100))
    email = Column(String(100))
    is_email_confirmed = Column(Boolean, default=False)
    is_staff = Column(Boolean, default=False)
    user_type = Column(String(10), nullable=False, default=Platform.SLACK.value)
    created_at = Column(DateTime, default=func.now())
    updated_at = Column(DateTime, default=func.now(), onupdate=func.now())

    __tablename__ = 'users'