you need to make a migration to apply the index.
https://www.endpoint.com/blog/2016/09/17/executing-custom-sql-in-django-migration
something like
class Migration(migrations.Migration):
dependencies = [
('blog', '0001_initial'),
]
operations = [
migrations.RunSQL(
"CREATE INDEX pgweb_idx ON pgweb USING GIN
(to_tsvector('english', title || ' ' || body));",
)
]
On Wednesday, August 29, 2018 at 7:16:15 AM UTC-4, Максим Родин wrote:
>
> Hello,
> I'm trying to make the text search index like this:
>
> https://www.postgresql.org/docs/current/static/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX
> :
> "CREATE INDEX pgweb_idx ON pgweb USING GIN (to_tsvector('english', title
> || ' ' || body));"
>
> I cannot imagine how to do it in django
> Here is my table:
>
> from django.contrib.postgres.indexes import GinIndex
> from django.contrib.postgres.search import SearchQuery
> from django.contrib.postgres.search import SearchVector
> import django.contrib.postgres.search as pg_search
>
>
> class Request(models.Model):
>
> open_date = models.DateTimeField(verbose_name='Creation Date',
> blank=True)
> close_date = models.DateTimeField(verbose_name='Closing Date',
> blank=True,
> null=True,
> )
>
>
> def in_work_time(self):
> return timezone.now() - self.open_date
>
>
> def set_open_time(self):
> self.open_date = timezone.now()
>
>
> subject = models.CharField(max_length=500,
> verbose_name='Request subject')
> author = models.CharField(max_length=500,
> verbose_name='Request author')
> content = models.TextField(verbose_name='Request content')
> engineer = models.ForeignKey(User, on_delete=models.PROTECT,
> blank=True,
> verbose_name='Engineer assigned')
> priority = models.IntegerField(default=10,
> verbose_name='Priority')
>
>
> def __str__(self):
> return self.subject
>
>
> And here are my thoughts how it could look like.
> (It doesn't work):
>
> en_sv = pg_search.SearchVectorField(SearchVector(
> 'subject', 'content', config='english'), null=True)
> ru_sv = pg_search.SearchVectorField(SearchVector(
> 'subject', 'content', config='russian'), null=True)
>
>
> class Meta:
> indexes = [
> GinIndex(fields=['ru_sv'],
> fastupdate=False, name='gin_search_ru_idx'),
> GinIndex(fields=['en_sv'],
> fastupdate=False, name='gin_search_en_idx'),
> ]
>
>
> Any thoughts?
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/101662a8-770b-4b39-8185-015c2f236656%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
