from django.db import models
from django.conf import settings


class UserInfoMisc(models.Model):
    user = models.OneToOneField(
        settings.AUTH_USER_MODEL, on_delete=models.DO_NOTHING,
        related_name='user_info_misc')
    name = models.CharField(max_length=32, blank=True, null=True)
    gender = models.CharField(max_length=8, blank=True, null=True)
    company = models.CharField(max_length=100, blank=True, null=True)
    industry = models.CharField(max_length=32, blank=True, null=True)
    job_title = models.CharField(max_length=32, blank=True, null=True)
    address = models.CharField(max_length=128, blank=True, null=True)
    phone = models.CharField(max_length=16, blank=True, null=True)
    email = models.CharField(max_length=64, blank=True, null=True)
    wechat_id = models.CharField(max_length=64, blank=True, null=True)
    github_id = models.CharField(max_length=64, blank=True, null=True)
    tidb_use_experience = models.CharField(max_length=64, blank=True, null=True)
    tidb_use_stage = models.CharField(max_length=64, blank=True, null=True)
    asktug_topic_count = models.IntegerField(default=0)
    asktug_reply_count = models.IntegerField(default=0)
    asktug_like_count = models.IntegerField(default=0)
    asktug_solved_count = models.IntegerField(default=0)
    asktug_topic_tidb_verion = models.JSONField(default=list)
    blog_article_count = models.IntegerField(default=0)
    recent_half_year_ip_top3_region = models.JSONField(default=list)
    all_ip_top3_region = models.JSONField(default=list)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = 'pingcap_user_info_misc'
        permissions = (
            ('search_user_by_ip_region', 'Can search user by ip & region'),
        )