Re: Full Text Search

maybe i misunderstood your question, but maybe it will help

On Fri, Oct 1, 2010 at 8:19 PM, m1chael <mykhul@gmail.com> wrote:
> Hello!
>
> I use PostgreSQL, and this is how I accomplished a full text search:
>
> def search(request):
>  # how to set up postgresql for full text searching
>  #alter table quote_quote add column body_tsv tsvector;
>  #CREATE TRIGGER quote_quote_tsvectorupdate BEFORE INSERT OR UPDATE
> ON quote_quote FOR EACH ROW EXECUTE PROCEDURE
> tsvector_update_trigger(quote_tsv, 'pg_catalog.english', quote);
>  #CREATE INDEX quote_quote_tsv ON quote_quote USING gin(quote_tsv);
>  #UPDATE quote_quote SET quote_tsv=to_tsvector(quote);
>
>  q = request.GET['q']
>
>  quotes = Quote.objects.extra(
>    select={
>        'snippet': "ts_headline(quote, plainto_tsquery(%s))",
>        'rank': "ts_rank_cd(quote_tsv, plainto_tsquery(%s), 32)",
>    },
>    where=["quote_tsv @@ plainto_tsquery(%s)"],
>    params=[q],
>    select_params=[q, q],
>    order_by=('-rank',)
>  )
>
>  paginator = Paginator(quotes, 50)
>
>  try:
>    page = int(request.GET.get('page', '1'))
>  except ValueError:
>    page = 1
>
>  try:
>    quotes = paginator.page(page)
>  except (EmptyPage, InvalidPage):
>    quotes = paginator.page(paginator.num_pages)
>
>  my_data_dictionary = {
>        'quotes': quotes,
>        'q' : q,
>  }
>
>  return render_to_response('results.html',
>                               my_data_dictionary,
>                               context_instance=RequestContext(request))
>
> urlpatterns = patterns('',
>    url(r'^search/$', search),
> )
>
> On Fri, Oct 1, 2010 at 7:26 PM, Andrej <amasiar@gmail.com> wrote:
>> Check this out:
>>
>> http://www.julienphalip.com/blog/2008/08/16/adding-search-django-site-snap/
>>
>> On Oct 1, 6:52 am, Alessandro Ronchi <alessandro.ron...@soasi.com>
>> wrote:
>>> On Fri, Oct 1, 2010 at 3:35 AM, Steve Holden <holden...@gmail.com> wrote:
>>> > On 9/30/2010 8:26 PM, Nick Arnett wrote:
>>> > > Brain is mush, though.
>>>
>  >> Thank you. I'm waiting with hope :)
>>>
>>> --
>>> Alessandro Ronchihttp://www.soasi.com
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Django users" group.
>> To post to this group, send email to django-users@googlegroups.com.
>> To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
>> For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
>>
>>
>

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.