# accounts/models.py
from django.db import models
from django.contrib.auth import get_user_model
CustomUser = get_user_model()

class LoginHistory(models.Model):
    user = models.ForeignKey(CustomUser, on_delete=models.CASCADE)
    timestamp = models.DateTimeField(auto_now_add=True)
    ip_address = models.GenericIPAddressField(null=True, blank=True)
    user_agent = models.TextField(blank=True)

    def __str__(self):
        return f"{self.user} logged in at {self.timestamp}"
    



class State(models.Model):
    name = models.CharField(max_length=100)
    state_type = models.CharField(max_length=10)  # 'S' or 'UT'


    def __str__(self):
        return self.name


class District(models.Model):
    name = models.CharField(max_length=100)
    state = models.ForeignKey(State, on_delete=models.CASCADE)

    class Meta:
        unique_together = ('state', 'name')  # no duplicate districts in same state

    def __str__(self):
        return f"{self.name}, {self.state.name}"
    

from django.db import models
from django.contrib.auth import get_user_model

User = get_user_model()

class EmailOTP(models.Model):
    user = models.ForeignKey(User, on_delete=models.CASCADE)
    new_email = models.EmailField()
    otp = models.CharField(max_length=6)
    created_at = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return f"{self.user.email} -> {self.new_email}"