demesew

These are generic npm scripts that you can copy & paste into your package.json file as-is and get access to convinience scripts to manage your Docker images all in one place.

How to Use

npm i -g mrm-task-npm-docker
npx mrm npm-docker

Contribute

Here's the code repository https://github.com/expertly-simple/mrm-task-npm-docker

# Get documents, where writters are Joel Coen and Ethan Coen.
db.movieDetails.find({ "writters" : ["Joel Coen", "Ethan Coen"] }).count()

# Get documents, where Jeff Bridges is playing leading role.
> db.movieDetails.find({ "actors.0": "Jeff Bridges" }).pretty()

SQL to MongoDB Mapping Chart

SQL to MongoDB Mapping Chart¶

In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about MongoDB.

Executables¶

The following table presents the MySQL/Oracle executables and the corresponding MongoDB executables.

	/* Using this directive is as easy as 1, 2, 3.
	1. Grab the Tableau API JavaScript library as well as this module.
	a. <script src="path/to/tableau-2.0.0.min.js"></script>
	b. <script src="path/to/angular-tableau.js"></script>
	2. Import the module into your app by adding 'angular-tableau' to your dependencies.
	3. Use the directive like this:
	<tableau-viz height="'500px'"
	url="path/to/tableau-dashboard"
	filters={'field1':['item1', 'item2'], 'dateField':{'min':startDate, 'max':endDate}}">
	</tableau-viz>

	/**
	* Based on @ericprieto code https://github.com/strongloop/loopback/issues/651#issuecomment-140879983
	* place this file into common/mixins/disableAllMethods.js
	*
	**/


	module.exports = function(Model, options) {
	if(Model && Model.sharedClass) {
	var methodsToExpose = options.expose \|\| [];

	// a list of useful queries for profiler analysis. Starting with the most basic.
	// 2.4 compatible
	//

	// output explained:
	//
	{
	"ts" : ISODate("2012-09-14T16:34:00.010Z"), // date it occurred
	"op" : "query", // the operation type
	"ns" : "game.players", // the db and collection

	#!/bin/bash

	MONGO_DATABASE="your_db_name"
	APP_NAME="your_app_name"

	MONGO_HOST="127.0.0.1"
	MONGO_PORT="27017"
	TIMESTAMP=`date +%F-%H%M`
	MONGODUMP_PATH="/usr/bin/mongodump"
	BACKUPS_DIR="/home/username/backups/$APP_NAME"

	var collectionNames = db.getCollectionNames(), stats = [];
	collectionNames.forEach(function (n) { stats.push(db[n].stats()); });
	stats = stats.sort(function(a, b) { return b['size'] - a['size']; });
	for (var c in stats) { print(stats[c]['ns'] + ": " + stats[c]['size'] + " (" + stats[c]['storageSize'] + ")"); }


	//start mongodb
	mongod --dbpath data

	mongoimport --db opendata --collection atlenergy < energy_wb.json

	#restore database from mongodump
	mongorestore --collection col --db opendata opendata/col.bson