Difference between revisions of "Largest and smallest documents"
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...") |
|||
| (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)