Re: Whoosh

[Massimo DiPierro]

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

[Massimo Di Pierro]

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

[Ron Chatterjee]

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.

[Massimo DiPierro]

there should be instructions in the file. You need to install whoosh

[Ron Chatterjee]

Can u fix smart_query for me? Lol

[Massimo DiPierro]

What is wrong with smart_query?

[Ron Chatterjee]

It gives a run time  error on line 110 when I try to pass the variable like u mentioned; list_of_searchble_field =[db.table.field]. It says "field must b a list of fields". I tried to pass it like a set too. Didnt work. I m not the best python guy yet:(. Unfortunately.  Matlab I could fix this in 5 min.

[Ron Chatterjee]

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

[Massimo DiPierro]

Do you have any from …. import Field in your code?

[Ron Chatterjee]

I did what u told me. I have "from pydal.helpers.methods import smart_query" in my default.py

[Ron Chatterjee]

In my db.py I have "from gluon.tools import*". Thats the issue?

[Massimo DiPierro]

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?

[Ron Chatterjee]

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!:-)?

[Ben Lawrence]

Ron, is whoosh faster than the database search e.g. pydal's like, ilike, regexp, startswith, endswith, contains, upper, lower ?