MongoDb - Revision history

Nicolas: /* Read Data */

2020-06-09T03:20:42Z

Read Data

← Older revision		Revision as of 03:20, 9 June 2020
Line 114:		Line 114:
	</syntaxhighlight>		</syntaxhighlight>

	* ~~joint~~		* Joint
	<syntaxhighlight lang="JavaScript">		<syntaxhighlight lang="JavaScript">
	db.collection.aggregate {		db.collection.aggregate {

2020-06-09T03:20:31Z

Read Data

@@ Line 112: / Line 112: @@
 db.collection.find().limit(x)
 db.collection.find().limit(x).pretty
 </syntaxhighlight>

2020-06-09T03:06:57Z

Read Data

2020-06-09T03:05:51Z

Read Data

@@ Line 112: / Line 112: @@
 db.collection.find().limit(x)
 db.collection.find().limit(x).pretty
 </syntaxhighlight>

2020-06-08T14:52:36Z

Explain / Log Setup

← Older revision		Revision as of 14:52, 8 June 2020
Line 138:		Line 138:
	=== Explain / Log Setup ===		=== Explain / Log Setup ===
	<div class="mw-collapsible-content">		<div class="mw-collapsible-content">
			* Explain Query
			<syntaxhighlight lang="JavaScript">
	db.collection.find({"country.city.population" : &lte 100000, country : "Italia" }).explain()		db.collection.find({"country.city.population" : &lte 100000, country : "Italia" }).explain()
			</syntaxhighlight>

			* Manage Log Information
			<syntaxhighlight lang="JavaScript">
			db.getLogComponents
			db.setLogLevel(2, 'query')
			</syntaxhighlight>

	</div>		</div>
	</div>		</div>

	<div class="toccolours mw-collapsible mw-collapsed">		<div class="toccolours mw-collapsible mw-collapsed">

	=== Database Engine Management ===		=== Database Engine Management ===
	<div class="mw-collapsible-content">		<div class="mw-collapsible-content">

2020-06-08T14:51:45Z

Database Engine Management

← Older revision		Revision as of 14:51, 8 June 2020
Line 148:		Line 148:
	<syntaxhighlight lang="JavaScript">		<syntaxhighlight lang="JavaScript">
	db.adminCommand( { shutdown: 1} )		db.adminCommand( { shutdown: 1} )
	~~</syntaxhighlight>~~

	* Manage Log Information
	~~<syntaxhighlight lang="JavaScript">~~
	~~db.getLogComponents~~
	~~db.setLogLevel(2, 'query')~~
	</syntaxhighlight>		</syntaxhighlight>

2020-06-08T14:49:50Z

Cheat sheet

← Older revision		Revision as of 14:49, 8 June 2020
Line 132:		Line 132:
	session.commit_transaction or session.abort_transaction		session.commit_transaction or session.abort_transaction
	</syntaxhighlight>		</syntaxhighlight>
			</div>
			</div>

			<div class="toccolours mw-collapsible mw-collapsed">
			=== Explain / Log Setup ===
			<div class="mw-collapsible-content">
			db.collection.find({"country.city.population" : &lte 100000, country : "Italia" }).explain()
	</div>		</div>
	</div>		</div>
Line 148:		Line 155:
	db.setLogLevel(2, 'query')		db.setLogLevel(2, 'query')
	</syntaxhighlight>		</syntaxhighlight>


	==== Replication ====		==== Replication ====

2020-06-08T14:45:28Z

Read Data

← Older revision		Revision as of 14:45, 8 June 2020
Line 106:		Line 106:
	db.collection.find({$or: [{"country.city" : "Arles"},{"country.city" : "Avignon"})		db.collection.find({$or: [{"country.city" : "Arles"},{"country.city" : "Avignon"})
	db.collection.find({"country.city" : { $in: ["Arles","Avignon"]}})		db.collection.find({"country.city" : { $in: ["Arles","Avignon"]}})
			db.collection.find({"country.city" : { $nin: ["Arles","Avignon"]}})
	db.collection.find({"country.city" : /Saint/i})		db.collection.find({"country.city" : /Saint/i})
	db.collection.find({"country.city" : /$Saint/i})		db.collection.find({"country.city" : /$Saint/i})

2020-06-08T14:44:55Z

Read Data

← Older revision		Revision as of 14:44, 8 June 2020
Line 101:		Line 101:
	db.collection.find()		db.collection.find()
	db.collection.find({("attributName" : "value" })		db.collection.find({("attributName" : "value" })
	db.collection.find({("address.~~zipCode~~" : "value" }).sort({"address.zipCode" : -1}).skip(5).limit(10)		db.collection.find({("address.city" : "value" }).sort({"address.zipCode" : -1}).skip(5).limit(10)
			db.collection.find({"country.city.population" : &lte 100000 }).sort({"country.city" : -1}).limit(10)
			db.collection.find({"country.city.population" : &lte 100000, country : "Italia" }).sort({"country.city" : -1}).limit(10)
			db.collection.find({$or: [{"country.city" : "Arles"},{"country.city" : "Avignon"})
			db.collection.find({"country.city" : { $in: ["Arles","Avignon"]}})
			db.collection.find({"country.city" : /Saint/i})
			db.collection.find({"country.city" : /$Saint/i})
	db.collection.find().count()		db.collection.find().count()
	db.collection.find().limit(x)		db.collection.find().limit(x)

2020-06-08T14:28:31Z

Read Data

← Older revision		Revision as of 14:28, 8 June 2020
Line 101:		Line 101:
	db.collection.find()		db.collection.find()
	db.collection.find({("attributName" : "value" })		db.collection.find({("attributName" : "value" })
	db.collection.find({("address.zipCode" : "value" })		db.collection.find({("address.zipCode" : "value" }).sort({"address.zipCode" : -1}).skip(5).limit(10)
	db.collection.find().count()		db.collection.find().count()
	db.collection.find().limit(x)		db.collection.find().limit(x)