mongodb/how-to-query-a-random-row-using-pymongo

mongodb: How to query a random row using pymongo

1. Get a count of every row.
2. Create an offset in the range of 1 to count.
3. Query for the item, skipping to the offset, limiting one result, and taking the [0]th index.

.. code-block:: python

def getone( request ):
    id = request.matchdict[ 'id' ]
    if id == 'random':
        from random import randrange
        count  = request.db['people'].count()
        offset = randrange( 1, count )
        person = request.db['people'].find().skip( offset ).limit(1)[0]
    else:
        person = request.db['people'].find_one( { 'id': int(id) } )

    return { 'person': person }