Difference between revisions of "FIND from WORLD"
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 = MongoCli...") |
|||
| Line 20: | Line 20: | ||
<div class=q data-lang="py3"> | <div class=q data-lang="py3"> | ||
| − | + | Observe the result of running a simple mongoDB command. | |
| − | <p class=strong> | + | <p class=strong>FIND name, continent, population FROM world</p> |
<pre class=def> | <pre class=def> | ||
| − | pp.pprint( | + | pp.pprint(list( |
| − | db.world.find() | + | db.world.find({},{ |
| − | ) | + | "name":1, |
| + | "continent":1, | ||
| + | "population":1, | ||
| + | "_id":0 | ||
| + | }) | ||
| + | )) | ||
</pre> | </pre> | ||
<div class=ans> | <div class=ans> | ||
| − | pp.pprint(db.world.find() | + | pp.pprint(list(db.world.find({},{"name":1,"continent":1,"population":1,"_id":0}))) |
</div> | </div> | ||
</div> | </div> | ||
Revision as of 15:06, 28 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)
Working with the world collection of countries
This tutorial introduces NoSQL using MonogDB and PyMongo under Python3.4. We will be using the find() command and comparison functions on the collection world which contains details of around 250 countries of the world:
FIND examples are available.
Observe the result of running a simple mongoDB command.
FIND name, continent, population FROM world
pp.pprint(list(
db.world.find({},{
"name":1,
"continent":1,
"population":1,
"_id":0
})
))
pp.pprint(list(db.world.find({},{"name":1,"continent":1,"population":1,"_id":0})))