Actions

AGGREGATE Movies Tutorial

From NoSQLZoo

Revision as of 23:29, 14 October 2016 by Andr3w (talk | contribs) (→Casablanca)

Investigating the Movie Database

The movie database includes thousands of movies with documents such as: 

{
	"_id" : 10522,
	"title" : "Alien",
	"yr" : 1979,
	"director" : "Ridley Scott",
	"budget" : 11000000,
	"gross" : 104931801,
	"cast" : [
		"Tom Skerritt",
		"Sigourney Weaver",
		"Veronica Cartwright",
		"Harry Dean Stanton",
		"John Hurt",
		"Ian Holm",
		"Yaphet Kotto"
	]
}

Casablanca

Show the details of the movie Casablanca 

db.movies.aggregate([
    {$match:{
        title:'Alien'
    }},
]).pretty()

db.movies.aggregate([
    {$match:{
        title:'Casablanca'
    }}
]).pretty()
  • You have been served by: dill
    • Retrieved from "http://nosqlzoo.net/w/index.php?title=AGGREGATE_Movies_Tutorial&oldid=911"