[google-appengine] Re: Performing a LIKE query in GQL ??
check out project Yaac! (http://code.google.com/p/yaac/) it now supports LIKE query -- You received this message because you are subscribed to the Google Groups Google App Engine group. To view this discussion on the web visit https://groups.google.com/d/msg/google-appengine/-/npV0s2XxoU4J. To post to this group, send email to google-appengine@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
[google-appengine] Re: Performing a LIKE query in GQL ??
Remember you can use inequality filters to match different suffixes at once: [use, useless, useful] will be matched by this query: db.GqlQuery('SELECT * FROM nowhere WHERE prop = use and prop = use' + u'\u' + ' ') because useL use and useL use[the bigger char in unicode] -- You received this message because you are subscribed to the Google Groups Google App Engine group. To post to this group, send email to google-appengine@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
[google-appengine] Re: Performing a LIKE query in GQL ??
Have a look at ListProperty if u're on the Python stack or in java you can do this : class { private ListString props; } query.setFilter( props == 'foo'); So, basically, create a list containing all the searchable tokens and then you can easily search in the way described above. -- You received this message because you are subscribed to the Google Groups Google App Engine group. To post to this group, send email to google-appengine@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
[google-appengine] Re: Performing a LIKE query in GQL ??
I also need a similiar function, I was thinking of: - putting everything to one document and manually searching for something (memory limit? - for some reason no one gives an estimation on a request's memory limit) - searching every element one by one using background tasks (expensive) - combining idea 1 and 2 When I asked about this on IRC pfn recommended what nischalshetty recommended Pros: - Very simple to implement Cons: - Deciding how deep the indexing will go (will you add each prefix?) - Limited search I am thinking of doing it like: phrase: the action game [the,action,game,the action,action game,the action game] it may also be every subsets which is 2^N, but I guess its a lot, so continuous sequences sound better I am definitely not diving into prefixes Thinking about it now, continuous sequences up to length 2 is the way to go for me phrase: very good game action [very,good,game,action,very good,good game,game action] and probably adding the whole thing too: [very,good,game,action,very good,good game,game action,very good game action] On Apr 19, 11:41 am, Chathum Henegama chathu...@gmail.com wrote: Hi i need to do a search for some data store in a table. If a user searches for foo i should get all the values containing foo.. Can anyone help me with this ? -- You received this message because you are subscribed to the Google Groups Google App Engine group. To post to this group, send email to google-appengine@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.