import uuid
from django.db import models
from django.utils.timezone import now

class Task(models.Model):
    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    name = models.CharField(max_length=200)
    description = models.TextField(blank=True, null=True)
    code = models.CharField(max_length=100, blank=True, null=True)
    estimated_time = models.CharField(max_length=50, default='0:00', blank=True)
    due_date = models.DateField(blank=True, null=True)
    project = models.ForeignKey('projects.Project', on_delete=models.CASCADE, related_name='tasks', blank=True, null=True)
    created_at = models.DateTimeField(default=now)
    updated_at = models.DateTimeField(auto_now=True)

    def __str__(self):
        return f"{self.name} - {self.project.name if self.project else 'No Project'}"

    class Meta:
        db_table = 'tasks'
        ordering = ['-created_at']