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 <[email protected]> wrote:
>>
>> In my db.py I have "from gluon.tools import*". Thats the issue?
>> On Mar 6, 2015 7:31 PM, "Massimo DiPierro" <[email protected]> wrote:
>>
>>> Do you have any from …. import Field in your code?
>>>
>>>
>>> On Mar 6, 2015, at 6:20 PM, Ron Chatterjee <[email protected]> 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" <[email protected]>
>>> wrote:
>>>
>>>> What is wrong with smart_query?
>>>>
>>>> On Fri, Mar 6, 2015 at 5:56 PM, Ron Chatterjee <[email protected]>
>>>> wrote:
>>>>
>>>>> Can u fix smart_query for me? Lol
>>>>> On Mar 6, 2015 6:53 PM, "Massimo DiPierro" <[email protected]>
>>>>> wrote:
>>>>>
>>>>>> there should be instructions in the file. You need to install whoosh
>>>>>>
>>>>>> On Mar 6, 2015, at 5:50 PM, Ron Chatterjee <[email protected]>
>>>>>> 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" <[email protected]>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> https://github.com/mdipierro/web2py-haystack
>>>>>>>>>
>>>>>>>>> On Mar 6, 2015, at 11:29 AM, Ron Chatterjee <[email protected]>
>>>>>>>>> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
