Returning documents
From NoSQLZoo
Revision as of 16:21, 26 July 2015 by 40166222 (talk | contribs) (40166222 moved page Returning the first document to Returning documents)
#ENCODING import io import sys sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-16') #MONGO from pymongo import MongoClient client = MongoClient() client.progzoo.authenticate('scott','tiger') db = client['progzoo'] #PRETTY import pprint pp = pprint.PrettyPrinter(indent=4) #CODE from bson.code import Code
Returning the first document
pp.pprint(db.world.find_one()) pp.pprint(db.world.find()[0]) pp.pprint(list(db.world.find().limit(1))[0]) pp.pprint(list(db.world.aggregate([{"$limit":1}]))[0])
Returning the nth document
n = 50; pp.pprint(db.world.find()[n-1]) pp.pprint(list(db.world.find().skip(n-1).limit(1))[0]) pp.pprint(list(db.world.aggregate([{"$skip":n-1},{"$limit":1}]))[0])
Returning the last document
pp.pprint(db.world.find()[db.world.count()-1]) pp.pprint(list(db.world.find().skip(db.world.count()-1).limit(1))[0]) pp.pprint(list(db.world.aggregate([{"$skip":db.world.count()-1},{"$limit":1}]))[0])