Elite Document Structure - Revision history

40166222: /* Elite Dangerous */

2018-10-17T13:55:27Z

Elite Dangerous

← Older revision		Revision as of 13:55, 17 October 2018
Line 17:		Line 17:

	</pre>		</pre>
	Unlike the ~~<code>~~world~~</code>~~ collection, <~~code~~>null</~~code~~> and empty values are not stored in this database.<br/>		Unlike the '''world''' collection, <syntaxhighlight lang="JavaScript" inline>null</syntaxhighlight> and empty values are not stored in this database.<br/>
	This means that some documents will have fields that others do not. Some systems will be uninhabited and have no stations and some stations will have no listings.<br/>		This means that some documents will have fields that others do not. Some systems will be uninhabited and have no stations and some stations will have no listings.<br/><br/>
	To query ~~null~~ <b>or</b> non-existent fields use <~~code~~><field>: None</~~code~~>. or <~~code~~><field>: "null"</~~code~~><br/><br/>		To query <syntaxhighlight lang="JavaScript" inline>null</syntaxhighlight> '''or''' non-existent fields use <syntaxhighlight lang="JavaScript" inline><field>: None</syntaxhighlight>. or <syntaxhighlight lang="JavaScript" inline><field>: "null"</syntaxhighlight><br/><br/>
	A typical <code>commodities</code> document looks something like this.		A typical <code>commodities</code> document looks something like this.
	<syntaxhighlight lang="JavaScript">		<syntaxhighlight lang="JavaScript">
Line 29:		Line 29:
	}		}
	</syntaxhighlight>		</syntaxhighlight>
	~~<code>~~systems~~</code>~~ is much bigger, so some stations and listings have been removed from this example document to make it shorter.		'''systems''' is much bigger, so some stations and listings have been removed from this example document to make it shorter.
	*The system '''Kappa Cygni''' has two stations '''Kensey Ring''' and '''Hauck Enterprise'''.		*The system '''Kappa Cygni''' has two stations '''Kensey Ring''' and '''Hauck Enterprise'''.
	*At Kensey Ring you can buy the commodity '''Hydrogen Fuel''' for 93 credits per ton, you can sell it is 89 credits.		*At Kensey Ring you can buy the commodity '''Hydrogen Fuel''' for 93 credits per ton, you can sell it is 89 credits.

40166222: Add syntax highlighting

2018-10-17T12:55:49Z

Add syntax highlighting

← Older revision		Revision as of 12:55, 17 October 2018
Line 5:		Line 5:
	commodities:		commodities:
	_id, average_price, category, name		_id, average_price, category, name

	systems:		systems:
	_id, allegiance, faction, government, name, population, primary_economy, security, state, stations, updated_at, x, y, z		_id, allegiance, faction, government, name, population, primary_economy, security, state, stations, updated_at, x, y, z
Line 20:		Line 21:
	To query null <b>or</b> non-existent fields use <code><field>: None</code>. or <code><field>: "null"</code><br/><br/>		To query null <b>or</b> non-existent fields use <code><field>: None</code>. or <code><field>: "null"</code><br/><br/>
	A typical <code>commodities</code> document looks something like this.		A typical <code>commodities</code> document looks something like this.
	<~~pre>~~		<syntaxhighlight lang="JavaScript">
	~~<nowiki~~>
	{		{
	"_id" : ObjectId("55af74e7402aa43f1ce7e3a3"),		"_id" : ObjectId("55af74e7402aa43f1ce7e3a3"),
Line 28:		Line 28:
	"category" : "Chemicals"		"category" : "Chemicals"
	}		}
	</~~nowiki>~~		</syntaxhighlight>
	~~</pre~~>
	<code>systems</code> is much bigger, so some stations and listings have been removed from this example document to make it shorter.		<code>systems</code> is much bigger, so some stations and listings have been removed from this example document to make it shorter.
	*The system '''Kappa Cygni''' has two stations '''Kensey Ring''' and '''Hauck Enterprise'''.		*The system '''Kappa Cygni''' has two stations '''Kensey Ring''' and '''Hauck Enterprise'''.
	*At Kensey Ring you can buy the commodity '''Hydrogen Fuel''' for 93 credits per ton, you can sell it is 89 credits.		*At Kensey Ring you can buy the commodity '''Hydrogen Fuel''' for 93 credits per ton, you can sell it is 89 credits.
	*You cannot buy '''Mineral Oil''' there but you can sell it at 326.		*You cannot buy '''Mineral Oil''' there but you can sell it at 326.
	<~~pre>~~		<syntaxhighlight lang="JavaScript">
	~~<nowiki~~>		> db.systems.findOne({"name":"1 Kappa Cygni"}) // Query
	> db.systems.findOne({"name":"1 Kappa Cygni"})
			// Result
	{		{
	"_id" : ObjectId("55b0edf6369fd5074b349c48"),		"_id" : ObjectId("55b0edf6369fd5074b349c48"),
Line 115:		Line 115:
	"population" : 24843190		"population" : 24843190
	}		}
	</~~nowiki>~~		</syntaxhighlight>
	~~</pre~~>

40166222: /* Elite Dangerous */

2018-10-17T12:50:48Z

Elite Dangerous

← Older revision		Revision as of 12:50, 17 October 2018
Line 17:		Line 17:
	</pre>		</pre>
	Unlike the <code>world</code> collection, <code>null</code> and empty values are not stored in this database.<br/>		Unlike the <code>world</code> collection, <code>null</code> and empty values are not stored in this database.<br/>
	This means that some documents will have fields that others do not: Some systems will be uninhabited and have no stations~~. Some~~ stations will have no listings.<br/>		This means that some documents will have fields that others do not. Some systems will be uninhabited and have no stations and some stations will have no listings.<br/>
	To query null <b>or</b> non-~~existant~~ fields use <code><field>: None</code>. or <code><field>: "null"</code><br/><br/>		To query null <b>or</b> non-existent fields use <code><field>: None</code>. or <code><field>: "null"</code><br/><br/>
	A typical <code>commodities</code> document looks something like this.		A typical <code>commodities</code> document looks something like this.
	<pre>		<pre>

40166222 at 13:32, 15 June 2018

2018-06-15T13:32:16Z

← Older revision		Revision as of 13:32, 15 June 2018
Line 21:		Line 21:
	A typical <code>commodities</code> document looks something like this.		A typical <code>commodities</code> document looks something like this.
	<pre>		<pre>
			<nowiki>
	{		{
	"_id" : ObjectId("55af74e7402aa43f1ce7e3a3"),		"_id" : ObjectId("55af74e7402aa43f1ce7e3a3"),
Line 27:		Line 28:
	"category" : "Chemicals"		"category" : "Chemicals"
	}		}
			</nowiki>
	</pre>		</pre>
	<code>systems</code> is much bigger, so some stations and listings have been removed from this example document to make it shorter.		<code>systems</code> is much bigger, so some stations and listings have been removed from this example document to make it shorter.
Line 33:		Line 35:
	*You cannot buy '''Mineral Oil''' there but you can sell it at 326.		*You cannot buy '''Mineral Oil''' there but you can sell it at 326.
	<pre>		<pre>
			<nowiki>
	> db.systems.findOne({"name":"1 Kappa Cygni"})		> db.systems.findOne({"name":"1 Kappa Cygni"})
	{		{
Line 113:		Line 115:
	"population" : 24843190		"population" : 24843190
	}		}
			</nowiki>
	</pre>		</pre>

Andr3w at 21:12, 23 September 2015

2015-09-23T21:12:33Z

← Older revision		Revision as of 21:12, 23 September 2015
Line 29:		Line 29:
	</pre>		</pre>
	<code>systems</code> is much bigger, so some stations and listings have been removed from this example document to make it shorter.		<code>systems</code> is much bigger, so some stations and listings have been removed from this example document to make it shorter.
	*The system '''Kappa Cygni''' has ~~one station called~~ '''Kensey Ring'''.		*The system '''Kappa Cygni''' has two stations '''Kensey Ring''' and '''Hauck Enterprise'''.
	*At Kensey Ring you can buy the commodity '''Hydrogen Fuel''' for 93 credits per ton, you can sell it is 89 credits.		*At Kensey Ring you can buy the commodity '''Hydrogen Fuel''' for 93 credits per ton, you can sell it is 89 credits.
	*You cannot buy '''Mineral Oil''' there but you can sell it at 326.		*You cannot buy '''Mineral Oil''' there but you can sell it at 326.

Andr3w at 21:10, 23 September 2015

2015-09-23T21:10:50Z

← Older revision		Revision as of 21:10, 23 September 2015
Line 19:		Line 19:
	This means that some documents will have fields that others do not: Some systems will be uninhabited and have no stations. Some stations will have no listings.<br/>		This means that some documents will have fields that others do not: Some systems will be uninhabited and have no stations. Some stations will have no listings.<br/>
	To query null <b>or</b> non-existant fields use <code><field>: None</code>. or <code><field>: "null"</code><br/><br/>		To query null <b>or</b> non-existant fields use <code><field>: None</code>. or <code><field>: "null"</code><br/><br/>
	~~The average~~ <code>commodities</code> document looks something like this.		A typical <code>commodities</code> document looks something like this.
	<pre>		<pre>
	{		{
Line 29:		Line 29:
	</pre>		</pre>
	<code>systems</code> is much bigger, so some stations and listings have been removed from this example document to make it shorter.		<code>systems</code> is much bigger, so some stations and listings have been removed from this example document to make it shorter.
			*The system '''Kappa Cygni''' has one station called '''Kensey Ring'''.
			*At Kensey Ring you can buy the commodity '''Hydrogen Fuel''' for 93 credits per ton, you can sell it is 89 credits.
			*You cannot buy '''Mineral Oil''' there but you can sell it at 326.
	<pre>		<pre>

40166222 at 13:46, 26 July 2015

2015-07-26T13:46:41Z

← Older revision		Revision as of 13:46, 26 July 2015
Line 18:		Line 18:
	Unlike the <code>world</code> collection, <code>null</code> and empty values are not stored in this database.<br/>		Unlike the <code>world</code> collection, <code>null</code> and empty values are not stored in this database.<br/>
	This means that some documents will have fields that others do not: Some systems will be uninhabited and have no stations. Some stations will have no listings.<br/>		This means that some documents will have fields that others do not: Some systems will be uninhabited and have no stations. Some stations will have no listings.<br/>
	To query null <b>or</b> non-existant fields use <code><field>: None</code>. ~~In Mongo shell~~ <code><field>: null</code> ~~will also work.~~<br/><br/>		To query null <b>or</b> non-existant fields use <code><field>: None</code>. or <code><field>: "null"</code><br/><br/>
	The average <code>commodities</code> document looks something like this.		The average <code>commodities</code> document looks something like this.
	<pre>		<pre>

40166222 at 11:40, 26 July 2015

2015-07-26T11:40:20Z

← Older revision		Revision as of 11:40, 26 July 2015
Line 1:		Line 1:
	Questions on this database can be found here [[MAPREDUCE ~~elite]], [[More~~ elite]]		Questions on this database can be found here: [[MAPREDUCE elite]]
	==Elite Dangerous==		==Elite Dangerous==
	Keys used in this database.		Keys used in this database.

40166222 at 11:22, 26 July 2015

2015-07-26T11:22:19Z

← Older revision		Revision as of 11:22, 26 July 2015
Line 1:		Line 1:
	Questions on this database can be found here [[MAPREDUCE elite]], [[~~more~~ elite]]		Questions on this database can be found here [[MAPREDUCE elite]], [[More elite]]
	==Elite Dangerous==		==Elite Dangerous==
	Keys used in this database.		Keys used in this database.

40166222 at 11:21, 26 July 2015

2015-07-26T11:21:50Z

← Older revision		Revision as of 11:21, 26 July 2015
Line 1:		Line 1:
	Questions on this database can be found here [[MAPREDUCE elite]], [[~~AGGREGATE~~ elite]]		Questions on this database can be found here [[MAPREDUCE elite]], [[more elite]]
	==Elite Dangerous==		==Elite Dangerous==
	Keys used in this database.		Keys used in this database.