Returning documents - Revision history

40166222: Convert py3 -> mongo

2018-04-09T00:13:35Z

Convert py3 -> mongo

← Older revision		Revision as of 00:13, 9 April 2018
Line 1:		Line 1:
	~~<pre class=setup>~~
	~~#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~~
	~~</pre>~~
	{{TopTenTips}}		{{TopTenTips}}
	<div style='height:25em;'>		<div style='height:25em;'>
	</div>		</div>
	<div class=q data-lang="~~py3~~">Return all documents		<div class="q" data-lang="mongo">Return all documents
	<pre class=def>		<pre class="def">
	~~pp.pprint(list(~~		db.world.find()
	db.world.find()		db.world.aggregate([{"$match":{}}])
	))

	~~pp.pprint(list(~~
	db.world.aggregate([{"$match":{}}])
	))
	</pre>		</pre>
	</div>		</div>

	<div class=q data-lang="~~py3~~">Returning the first document		<div class="q" data-lang="mongo">Returning the first document
	<pre class=def>		<pre class="def">
	~~pp.pprint(~~db.world.~~find_one~~())		db.world.findOne()
	~~pp.pprint(~~db.world.find()[0])		db.world.find()[0]
	~~pp.pprint(list(~~db.world.find().limit(1~~))[0]~~)		db.world.find().limit(1)
	~~pp.pprint(list(~~db.world.aggregate([{"$limit":1}~~]))[0~~])		db.world.aggregate([{"$limit":1}])
	</pre>		</pre>
	</div>		</div>

	<div class=q data-lang="~~py3~~">Returning the ~~<b>~~n~~</b>~~th document		<div class="q" data-lang="mongo">Returning the '''n'''th document
	<pre class=def>		<pre class="def">
	n = 50;		let n = 50;
	~~pp.pprint(~~db.world.find()[n-1])		db.world.find()[n-1]
	~~pp.pprint(list(~~db.world.find().skip(n-1).limit(1~~))[0]~~)		db.world.find().skip(n-1).limit(1)
	~~pp.pprint(list(~~db.world.aggregate([{"$skip":n-1},{"$limit":1}~~]))[0~~])		db.world.aggregate([{"$skip":n-1},{"$limit":1}])
	</pre>		</pre>
	</div>		</div>

	<div class=q data-lang="~~py3~~">Returning the last document		<div class="q" data-lang="mongo">Returning the last document
	<pre class=def>		<pre class="def">
	~~pp.pprint(~~db.world.find()[db.world.count()-1])		db.world.find()[db.world.count()-1]
	~~pp.pprint(list(~~db.world.find().skip(db.world.count()-1).limit(1~~))[0]~~)		db.world.find().skip(db.world.count()-1).limit(1)
	~~pp.pprint(list(~~db.world.aggregate([{"$skip":db.world.count()-1},{"$limit":1}~~]))[0~~])		db.world.aggregate([{"$skip":db.world.count()-1},{"$limit":1}])
	</pre>		</pre>
	</div>		</div>

40166222 at 16:24, 26 July 2015

2015-07-26T16:24:03Z

← Older revision		Revision as of 16:24, 26 July 2015
Line 22:		Line 22:
	pp.pprint(list(		pp.pprint(list(
	db.world.find()		db.world.find()
	)~~[0]~~)		))

	pp.pprint(list(		pp.pprint(list(
	db.world.aggregate([{"$match":{}}])		db.world.aggregate([{"$match":{}}])
	)~~[0]~~)		))
	</pre>		</pre>
	</div>		</div>

40166222 at 16:23, 26 July 2015

2015-07-26T16:23:41Z

← Older revision		Revision as of 16:23, 26 July 2015
Line 23:		Line 23:
	db.world.find()		db.world.find()
	)[0])		)[0])

	pp.pprint(list(		pp.pprint(list(
	db.world.aggregate([{"$match":{}}])		db.world.aggregate([{"$match":{}}])

40166222 at 16:23, 26 July 2015

2015-07-26T16:23:29Z

@@ Line 18: / Line 18: @@
 <div style='height:25em;'>
 </div>
 <div class=q data-lang="py3">Returning the first document
 <pre class=def>

40166222: 40166222 moved page Returning the first document to Returning documents

2015-07-26T16:21:17Z

40166222 moved page Returning the first document to Returning documents

← Older revision	Revision as of 16:21, 26 July 2015
(No difference)

40166222 at 16:21, 26 July 2015

2015-07-26T16:21:01Z

← Older revision		Revision as of 16:21, 26 July 2015
Line 18:		Line 18:
	<div style='height:25em;'>		<div style='height:25em;'>
	</div>		</div>
	<div class=q data-lang="py3">Returning the first ~~documents~~		<div class=q data-lang="py3">Returning the first document
	<pre class=def>		<pre class=def>
	pp.pprint(db.world.find_one())		pp.pprint(db.world.find_one())

40166222 at 16:20, 26 July 2015

2015-07-26T16:20:40Z

← Older revision		Revision as of 16:20, 26 July 2015
Line 38:		Line 38:
	<div class=q data-lang="py3">Returning the last document		<div class=q data-lang="py3">Returning the last document
	<pre class=def>		<pre class=def>
	~~n = 50;~~
	pp.pprint(db.world.find()[db.world.count()-1])		pp.pprint(db.world.find()[db.world.count()-1])
	pp.pprint(list(db.world.find().skip(db.world.count()-2).limit(1))[0])		pp.pprint(list(db.world.find().skip(db.world.count()-1).limit(1))[0])
	pp.pprint(list(db.world.aggregate([{"$skip":db.world.count()-2},{"$limit":1}]))[0])		pp.pprint(list(db.world.aggregate([{"$skip":db.world.count()-1},{"$limit":1}]))[0])
	</pre>		</pre>
	</div>		</div>

40166222 at 16:20, 26 July 2015

2015-07-26T16:20:04Z

← Older revision		Revision as of 16:20, 26 July 2015
Line 18:		Line 18:
	<div style='height:25em;'>		<div style='height:25em;'>
	</div>		</div>
	<div class=q data-lang="py3">		<div class=q data-lang="py3">Returning the first documents
	<pre class=def>		<pre class=def>
	pp.pprint(db.world.find_one())		pp.pprint(db.world.find_one())
Line 33:		Line 33:
	pp.pprint(list(db.world.find().skip(n-1).limit(1))[0])		pp.pprint(list(db.world.find().skip(n-1).limit(1))[0])
	pp.pprint(list(db.world.aggregate([{"$skip":n-1},{"$limit":1}]))[0])		pp.pprint(list(db.world.aggregate([{"$skip":n-1},{"$limit":1}]))[0])
			</pre>
			</div>

			<div class=q data-lang="py3">Returning the last document
			<pre class=def>
			n = 50;
			pp.pprint(db.world.find()[db.world.count()-1])
			pp.pprint(list(db.world.find().skip(db.world.count()-2).limit(1))[0])
			pp.pprint(list(db.world.aggregate([{"$skip":db.world.count()-2},{"$limit":1}]))[0])
	</pre>		</pre>
	</div>		</div>

40166222 at 16:05, 26 July 2015

2015-07-26T16:05:44Z

← Older revision		Revision as of 16:05, 26 July 2015
Line 29:		Line 29:
	<div class=q data-lang="py3">Returning the <b>n</b>th document		<div class=q data-lang="py3">Returning the <b>n</b>th document
	<pre class=def>		<pre class=def>
	~~n = 50;~~
	n = 50;		n = 50;
	pp.pprint(db.world.find()[n-1])		pp.pprint(db.world.find()[n-1])

40166222 at 16:05, 26 July 2015

2015-07-26T16:05:32Z

← Older revision		Revision as of 16:05, 26 July 2015
Line 30:		Line 30:
	<pre class=def>		<pre class=def>
	n = 50;		n = 50;
	~~pp.pprint(db.world.find_one()[~~n~~-1])~~		n = 50;
	pp.pprint(db.world.find()[n-1])		pp.pprint(db.world.find()[n-1])
	pp.pprint(list(db.world.find().skip(n-1).limit(1))[0])		pp.pprint(list(db.world.find().skip(n-1).limit(1))[0])