from django.contrib.postgres.indexes import GinIndex
from django.contrib.auth import get_user_model
from django.db import models


User = get_user_model()


class Blog(models.Model):
    author = models.ForeignKey(
        User,
        on_delete=models.CASCADE
    )
    title = models.CharField(
        verbose_name='Título',
        max_length=255,
        db_index=True,
    )
    content = models.TextField(
        verbose_name='Contenido',
        null=True,
        blank=True
    )
    created_at = models.DateTimeField(
        auto_now_add=True
    )
    updated_at = models.DateTimeField(
        auto_now=True
    )

    class Meta:
        indexes = [
            GinIndex(
                name='title_index',
                fields=['title'],
                opclasses=['varchar_pattern_ops']
            )
        ]
        db_table = 'blog'