DONT PAY ATTENTION TO THE EARLY POST WAS MISTAKEN SUBMMITED This is not a proper full text but i want to make a better search cause in gae don't have like operator, so i use new introduce list:string that is supported in both gae and sqlite. So in the search I use contains in that field, but at the moment there are a bug in web2py http://code.google.com/p/web2py/issues/detail?id=105
For example i have: db.define_table('posts', db.Field('id', 'id'), db.Field('content', 'text'), db.Field('keywords', 'list:string'), #tags db.Field('fulltext', 'list:string'), migrate=True) When i want to process content of text I use clean_words = get_clean_words(searchable) post.update_record(content= value, fulltext = clean_words) To search i Use contains(). This remove the stop words of the text and save in a list string. http://code.google.com/p/instant-press/source/browse/trunk/models/fulltext.py If you have a better ideas i am listening :) On 6 sep, 07:45, "Martin.Mulone" <mulone.mar...@gmail.com> wrote: > This is not a proper full text but i want to make a better search > cause in gae don't have like operator, so i use new introduce > list:string that is supported in both gae and sqlite. So in the search > I use contains in that field, but at the moment there are a bug in > web2pyhttp://code.google.com/p/web2py/issues/detail?id=105 > > For example i have: > > db.define_table('posts', > db.Field('id', 'id'), > > db.Field('keywords', 'list:string'), > #tags > db.Field('fulltext', > 'list:string'), > migrate=True) > > http://code.google.com/p/instant-press/source/browse/trunk/models/ful... > > On 5 sep, 13:53, John <dr.schmu...@gmail.com> wrote: > > > > > Hi all. > > I'm newby in web2py. > > How to implement full text search in my web2py web application? > > I am a big fan of the Xapian search engine library. Any plugin, > > recipes suggestion ? > > Thanks , > > John