from django.db import models
from django.contrib.auth import get_user_model
from django.core.validators import FileExtensionValidator

User = get_user_model()

# Supported video extensions
ALLOWED_VIDEO_EXTENSIONS = [
    'mp4', 'webm', 'ogg', 'ogv', 'mov', 'avi', 'mkv',
    'm4v', 'wmv', 'flv', '3gp', 'mpeg', 'mpg'
]

class Video(models.Model):
    file = models.FileField(
        upload_to='videos/',
        validators=[FileExtensionValidator(allowed_extensions=ALLOWED_VIDEO_EXTENSIONS)]
    )
    created_at = models.DateTimeField(auto_now_add=True)
    created_by = models.ForeignKey(User, on_delete=models.CASCADE, related_name='uploaded_videos')

    class Meta:
        verbose_name = "Video"
        verbose_name_plural = "Videos"
        ordering = ['-created_at']
        indexes = [
            models.Index(fields=['created_at']),
            models.Index(fields=['created_by_id', 'created_at']),
        ]

    def __str__(self):
        return f"Video by {self.created_by.username}"