[storm] Limit clause

Jamu Kakar jamshed.kakar at canonical.com
Thu Jul 26 16:52:47 BST 2007


Hi Akira,

akira wrote:
> Is there an actual LIMIT clause? If yes, could someone show an example
> of its use?

You can use the following, in addition to the slicing method Chris
suggested:

result = store.find(Person, Person.name.like("Bob%"))
result.config(limit=5, offset=2)

Note, that you can also pass 'distinct=True' to ResultSet.config to
make it use 'SELECT DISTINCT' queries.

Hope this helps,
J.




More information about the storm mailing list