from __future__ import annotations
import datetime, hashlib, logging, os, pytz, redis, secrets

from typing import Dict, List, Optional, Set, Union
from pydantic import BaseModel, EmailStr, Field, Json, PrivateAttr, ValidationError, validator

from app.db_sql import redis_lookup_id_random
from app.lib_general import log, logging

from app.models.common_field_schema import base_fields, default_num_bytes
# from app.models.membership_cfg_models import Membership_Cfg_Base
from app.models.membership_group_models import Membership_Group_Base
from app.models.product_models import Product_Base


class Membership_Person_Group_Base(BaseModel):
    log.setLevel(logging.WARNING)
    log.debug(locals())

    id_random: Optional[str] = Field(
        **base_fields['membership_person_group_id_random'],
        alias = 'membership_person_group_id_random',
        default_factory = lambda:secrets.token_urlsafe(default_num_bytes),
    )
    id: Optional[int] = Field(
        alias = 'membership_person_group_id'
    )

    account_id_random: Optional[str]
    account_id: Optional[int]

    membership_group_id_random: Optional[str] = Field(
        alias = 'group_id_random',
        ) # NOTE: This is not optional
    membership_group_id: Optional[int] = Field(
        alias = 'group_id',
        ) # NOTE: This is not optional
    membership_group_name: Optional[str] = Field(
        alias = 'group_name',
        )

    membership_person_id_random: Optional[str]
    membership_person_id: Optional[int]

    product_id_random: Optional[str]
    product_id: Optional[int] # The product they purchased to get this membership

    membership_group_status_id: Optional[int] = Field(
        alias = 'status_id'
        )
    membership_group_status_name: Optional[str] = Field(
        alias = 'status_name'
        )

    flag: Optional[bool]
    flag_message: Optional[str]

    enable: Optional[bool]
    hide: Optional[bool]
    priority: Optional[bool]
    sort: Optional[int]
    group: Optional[str]

    notes: Optional[str]

    created_on: Optional[datetime.datetime] = None
    updated_on: Optional[datetime.datetime] = None

    # Including other related objects
    # membership_cfg: Optional[Membership_Cfg_Base] = Field(
    #     alias = 'cfg',
    #     )
    membership_group: Optional[Membership_Group_Base]
    product: Optional[Product_Base] # The product used to be a part of the group?

    _processed_at: datetime.datetime = PrivateAttr(default_factory=datetime.datetime.now)

    #@validator('membership_person_group_id_random', always=True)
    def membership_person_group_id_random_copy(cls, v, values, **kwargs):
        log.setLevel(logging.WARNING)
        log.debug(locals())

        if values['id_random']:
            return values['id_random']
        return None

    @validator('id', always=True)
    def membership_person_group_id_lookup(cls, v, values, **kwargs):
        log.setLevel(logging.WARNING)
        log.debug(locals())

        if values['id_random']:
            return redis_lookup_id_random(record_id_random=values['id_random'], table_name='membership_person_group')
        return None

    @validator('membership_group_id', always=True)
    def membership_group_id_lookup(cls, v, values, **kwargs):
        log.setLevel(logging.WARNING)
        log.debug(locals())

        if values['membership_group_id_random']:
            return redis_lookup_id_random(record_id_random=values['membership_group_id_random'], table_name='membership_group')
        return None

    @validator('membership_person_id', always=True)
    def membership_person_id_lookup(cls, v, values, **kwargs):
        log.setLevel(logging.WARNING)
        log.debug(locals())

        if values['membership_person_id_random']:
            return redis_lookup_id_random(record_id_random=values['membership_person_id_random'], table_name='membership_person')
        return None

    @validator('product_id', always=True)
    def product_id_lookup(cls, v, values, **kwargs):
        log.setLevel(logging.WARNING)
        log.debug(locals())

        if values['product_id_random']:
            return redis_lookup_id_random(record_id_random=values['product_id_random'], table_name='product')
        return None

    class Config:
        underscore_attrs_are_private = True
        fields = base_fields
        allow_population_by_field_name = True

# Membership_Base.update_forward_refs()