Largest and smallest documents: Difference between revisions
From NoSQLZoo
Created page with "<pre class=setup> #ENCODING import io import sys sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-16') #MONGO from pymongo import MongoClient client = MongoClien..." |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 7: | Line 7: | ||
from pymongo import MongoClient | from pymongo import MongoClient | ||
client = MongoClient() | client = MongoClient() | ||
client. | client.progzoo.authenticate('scott','tiger') | ||
db = client[' | db = client['progzoo'] | ||
#PRETTY | #PRETTY | ||
import pprint | import pprint | ||
| Line 23: | Line 23: | ||
biggest = 0 | biggest = 0 | ||
smallest = sys.maxsize | smallest = sys.maxsize | ||
big_doc = {} | |||
small_doc = {} | small_doc = {} | ||
for x in db. | for x in db.world.find(): | ||
size = len(bson.BSON.encode(x)) | size = len(bson.BSON.encode(x)) | ||
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 18: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)