Difference between revisions of "Largest and smallest documents"
From NoSQLZoo
| Line 23: | Line 23: | ||
biggest = 0 | biggest = 0 | ||
smallest = sys.maxsize | smallest = sys.maxsize | ||
| + | big_doc = {} | ||
small_doc = {} | small_doc = {} | ||
| − | |||
for x in db.world.find(): | for x in db.world.find(): | ||
| Line 30: | Line 30: | ||
if(size > biggest): | if(size > biggest): | ||
biggest = size; | biggest = size; | ||
| − | + | big_doc = x | |
if(size < smallest): | if(size < smallest): | ||
smallest = size; | smallest = size; | ||
| − | + | small_doc = x | |
| + | pp.pprint(big_doc) | ||
pp.pprint(small_doc) | pp.pprint(small_doc) | ||
| − | |||
</pre> | </pre> | ||
</div> | </div> | ||
Latest revision as of 19:29, 26 July 2015
#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
import bson, sys
biggest = 0
smallest = sys.maxsize
big_doc = {}
small_doc = {}
for x in db.world.find():
size = len(bson.BSON.encode(x))
if(size > biggest):
biggest = size;
big_doc = x
if(size < smallest):
smallest = size;
small_doc = x
pp.pprint(big_doc)
pp.pprint(small_doc)