from sqlalchemy_utils import EmailType, PasswordType
from .base import db, BaseMixin


__all__ = ['User', 'UserCharacterLike']


class User(BaseMixin, db.Model):

    __tablename__ = 'star_wars_user'

    name = db.Column(db.Unicode(255), nullable=False)
    email = db.Column(EmailType, nullable=False)
    password = db.Column(PasswordType(
        schemes=[
            'pbkdf2_sha512',
        ],
    ))
    client_id = db.Column(
        db.Integer,
        db.ForeignKey('api_client.id', name='star_wars_user_api_client_id_fk'),
        nullable=False
    )

    client = db.relationship('Client')


class UserCharacterLike(BaseMixin, db.Model):

    __tablename__ = 'user_character_like'

    user_id = db.Column(
        db.Integer,
        db.ForeignKey('star_wars_user.id', name='user_character_like_user_id_fk'),
        nullable=False
    )

    character_id = db.Column(
        db.Integer,
        db.ForeignKey('character.id', name='user_character_like_character_id_fk'),
        nullable=False
    )

    character = db.relationship('Character', foreign_keys=[character_id])
    user = db.relationship('User', foreign_keys=[user_id])

    __table_args__ = (
        db.UniqueConstraint('user_id', 'character_id', name='user_character_like_uix'),
    )