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


  Source:
  https://foxhop.net/f3466a67-2f95-11f1-8e6a-e86a64d24d78/mongodb-how-to-query-a-random-row-using-pymongo
  Snapshot: 2026-10-16T05:58:38Z
  Generator: Remarkbox d747782

  This is a thread snapshot. The living document lives at the source URI
  above — it may have been edited, extended, or replied-to since.

[Scan for living source]

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.

    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 }

------------------------------------------------------------------------

Source:
https://foxhop.net/f3466a67-2f95-11f1-8e6a-e86a64d24d78/mongodb-how-to-query-a-random-row-using-pymongo
Snapshot: 2026-10-16T05:58:38Z
Generator: Remarkbox d747782