Ron, is whoosh faster than the database search e.g. pydal's like, ilike, regexp, startswith, endswith, contains, upper, lower ?
On Saturday, March 7, 2015 at 10:29:58 AM UTC-8, Ron Chatterjee wrote: > > web2py lived up to its promise again and delivered!!! works like a champ. > One line put all the search results in your finger tip and that without > wring one single line of JS like php will make you do. The magic of python. > How cool is that!:-)? > > > > On Saturday, March 7, 2015 at 12:07:35 PM UTC-5, Massimo Di Pierro wrote: >> >> I run some tests and I cannot reproduce the problem but I pointed you to >> the wrong function. >> This works for me and does what you asked: >> >> db = DAL() >> db.define_table('a',Field('b')) >> db.a.insert(b="xxx") >> query = SQLFORM.build_query([db.a.b],'xxx') >> print db(query).select() >> >> Does it work for you? >> >> >> On Mar 6, 2015, at 6:40 PM, Ron Chatterjee <achatte...@gmail.com> wrote: >> >> In my db.py I have "from gluon.tools import*". Thats the issue? >> On Mar 6, 2015 7:31 PM, "Massimo DiPierro" <massimo....@gmail.com> wrote: >> >>> Do you have any from …. import Field in your code? >>> >>> >>> On Mar 6, 2015, at 6:20 PM, Ron Chatterjee <achatte...@gmail.com> wrote: >>> >>> I think the issue is with the line isinstance (field, Field). When I >>> pass the field.it is a gluon.dal.objects.Field n u r comparing that >>> with pydal.object.Field. I m not sure but its failing both if and else. So >>> it goes to raise. Lol >>> On Mar 6, 2015 6:59 PM, "Massimo DiPierro" <massimo....@gmail.com> >>> wrote: >>> >>>> What is wrong with smart_query? >>>> >>>> On Fri, Mar 6, 2015 at 5:56 PM, Ron Chatterjee <achatte...@gmail.com> >>>> wrote: >>>> >>>>> Can u fix smart_query for me? Lol >>>>> On Mar 6, 2015 6:53 PM, "Massimo DiPierro" <massimo....@gmail.com> >>>>> wrote: >>>>> >>>>>> there should be instructions in the file. You need to install whoosh >>>>>> >>>>>> On Mar 6, 2015, at 5:50 PM, Ron Chatterjee <achatte...@gmail.com> >>>>>> wrote: >>>>>> >>>>>> Does anyone know how to install haystack? I see a python file with >>>>>> .py extension. I need to install whoosk and sunburnt first? Thought >>>>>> may be give haystack a try. >>>>>> >>>>>> >>>>>> >>>>>> On Friday, March 6, 2015 at 1:08:28 PM UTC-5, Massimo Di Pierro wrote: >>>>>>> >>>>>>> It may need some love. Very few people have used this. It should >>>>>>> work fine. It works for me. >>>>>>> >>>>>>> On Friday, 6 March 2015 11:40:25 UTC-6, Ron Chatterjee wrote: >>>>>>>> >>>>>>>> Omg, this is exactly what I was looking for. Sooo spooky >>>>>>>> On Mar 6, 2015 12:35 PM, "Massimo DiPierro" <massimo....@gmail.com> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> https://github.com/mdipierro/web2py-haystack >>>>>>>>> >>>>>>>>> On Mar 6, 2015, at 11:29 AM, Ron Chatterjee <achatte...@gmail.com> >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>> Is whoosh is supported in DAL. Any example? Or have a js that >>>>>>>>> create SQLFORM.search like SQLFOrM.smartgrid? Searching is important >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>> >>>> >>> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.