Difference between revisions of "FIND basics"
(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 = MongoClie...") |
|||
| Line 33: | Line 33: | ||
</div> | </div> | ||
| − | |||
<div class=q data-lang="py3"> | <div class=q data-lang="py3"> | ||
Use <code>sort()</code> to find the last document in world | Use <code>sort()</code> to find the last document in world | ||
<p class=strong>Show the last document of world</p> | <p class=strong>Show the last document of world</p> | ||
| + | <pre class=def> | ||
| + | </pre> | ||
| + | <div class=ans> | ||
| + | pp.pprint(list(db.world.find().sort("$natural", -1).limit(1))) | ||
| + | </div> | ||
| + | </div> | ||
| + | |||
| + | <div class=q data-lang="py3"> | ||
| + | Find all the countries in the continent of Asia | ||
| + | <p class=strong>List all the countries in the continent of Asia</p> | ||
<pre class=def> | <pre class=def> | ||
</pre> | </pre> | ||
<div class=ans> | <div class=ans> | ||
| − | pp.pprint(list(db.world.find(). | + | pp.pprint(list(db.world.find({"continent":"Asia"}, {"_id":0, "name":1}))) |
| + | </div> | ||
| + | </div> | ||
| + | |||
| + | <div class=q data-lang="py3"> | ||
| + | |||
| + | <p class=strong>Find the capital cities for countries with a population of over 70 million</p> | ||
| + | <pre class=def> | ||
| + | |||
| + | </pre> | ||
| + | <div class=ans> | ||
| + | pp.pprint(list(db.world.find({"population":{"$gt":70000000}},{"capital":1,"_id":0}))) | ||
| + | </div> | ||
| + | </div> | ||
| + | |||
| + | <div class=q data-lang="py3"> | ||
| + | |||
| + | <p class=strong>Find the countries that have a population of over 100 million or less than a million</p> | ||
| + | <pre class=def> | ||
| + | |||
| + | </pre> | ||
| + | <div class=ans> | ||
| + | pp.pprint(list(db.world.find({"$or":[{"population":{"$lt":1000000}},{"population":{"$gt":100000000}}]}, {"name":1, "_id":0}))) | ||
</div> | </div> | ||
</div> | </div> | ||
Revision as of 13:38, 27 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
These examples introduce NoSQL using MonogDB and PyMongo under Python3.4. We will be using the find() command and basic comparison functions on the collection world:
Use find() to return the 21st document in world
For help on this click here
Show the 21st document in world
pp.pprint(
db.world.find()
)
pp.pprint(db.world.find()[20])
Use sort() to find the last document in world
Show the last document of world
pp.pprint(list(db.world.find().sort("$natural", -1).limit(1)))
Find all the countries in the continent of Asia
List all the countries in the continent of Asia
pp.pprint(list(db.world.find({"continent":"Asia"}, {"_id":0, "name":1})))
Find the capital cities for countries with a population of over 70 million
pp.pprint(list(db.world.find({"population":{"$gt":70000000}},{"capital":1,"_id":0})))
Find the countries that have a population of over 100 million or less than a million
pp.pprint(list(db.world.find({"$or":[{"population":{"$lt":1000000}},{"population":{"$gt":100000000}}]}, {"name":1, "_id":0})))