Cómo ejecutar MongoDB Search queries contra campos en documentos incrustados

# Create a new directory and initialize the project
mkdir atlas-search-project && cd atlas-search-project
npm init -y
# Add the MongoDB Node.js Driver to your project
npm install mongodb

1
const { MongoClient } = require('mongodb');
2
3
async function createSchoolsData() {
4
  // Connection URI
5
  const uri = '<connection-string>';
6
  
7
  // Create a new MongoClient
8
  const client = new MongoClient(uri);
9
10
  try {
11
    // Connect to the MongoDB server
12
    await client.connect();
13
    
14
    // Get the sample_mflix database
15
    const database = client.db('local_school_district');
16
    
17
    // Create the schools collection
18
    try {
19
      await database.createCollection('schools');
20
    } catch (err) {
21
      // Collection may already exist, which is fine
22
      console.log(`Note: ${err.message}`);
23
    }
24
    
25
    // Get the collection
26
    const collection = database.collection('schools');
27
    
28
    // Create and insert the first document - Springfield High
29
    const doc1 = {
30
      _id: 0,
31
      name: "Springfield High",
32
      mascot: "Pumas",
33
      teachers: [{
34
        first: "Jane",
35
        last: "Smith",
36
        classes: [{
37
          subject: "art of science",
38
          grade: "12th"
39
        },
40
        {
41
          subject: "applied science and practical science",
42
          grade: "9th"
43
        },
44
        {
45
          subject: "remedial math",
46
          grade: "12th"
47
        },
48
        {
49
          subject: "science",
50
          grade: "10th"
51
        }]
52
      },
53
      {
54
        first: "Bob",
55
        last: "Green",
56
        classes: [{
57
          subject: "science of art",
58
          grade: "11th"
59
        },
60
        {
61
          subject: "art art art",
62
          grade: "10th"
63
        }]
64
      }],
65
      clubs: {
66
        stem: [
67
          {
68
            club_name: "chess",
69
            description: "provides students opportunity to play the board game of chess informally and competitively in tournaments."
70
          },
71
          {
72
            club_name: "kaboom chemistry",
73
            description: "provides students opportunity to experiment with chemistry that fizzes and explodes."
74
          }
75
        ],
76
        arts: [
77
          {
78
            club_name: "anime",
79
            description: "provides students an opportunity to discuss, show, and collaborate on anime and broaden their Japanese cultural understanding."
80
          },
81
          {
82
            club_name: "visual arts",
83
            description: "provides students an opportunity to train, experiment, and prepare for internships and jobs as photographers, illustrators, graphic designers, and more."
84
          }
85
        ]
86
      }
87
    };
88
    
89
    await collection.insertOne(doc1);
90
    
91
    // Create and insert the second document - Evergreen High
92
    const doc2 = {
93
      _id: 1,
94
      name: "Evergreen High",
95
      mascot: "Jaguars",
96
      teachers: [{
97
        first: "Jane",
98
        last: "Earwhacker",
99
        classes: [{
100
          subject: "art",
101
          grade: "9th"
102
        },
103
        {
104
          subject: "science",
105
          grade: "12th"
106
        }]
107
      },
108
      {
109
        first: "John",
110
        last: "Smith",
111
        classes: [{
112
          subject: "math",
113
          grade: "12th"
114
        },
115
        {
116
          subject: "art",
117
          grade: "10th"
118
        }]
119
      }],
120
      clubs: {
121
        sports: [
122
          {
123
            club_name: "archery",
124
            description: "provides students an opportunity to practice and hone the skill of using a bow to shoot arrows in a fun and safe environment."
125
          },
126
          {
127
            club_name: "ultimate frisbee",
128
            description: "provides students an opportunity to play frisbee and learn the basics of holding the disc and complete passes."
129
          }
130
        ],
131
        stem: [
132
          {
133
            club_name: "zapped",
134
            description: "provides students an opportunity to make exciting gadgets and explore electricity."
135
          },
136
          {
137
            club_name: "loose in the chem lab",
138
            description: "provides students an opportunity to put the scientific method to the test and get elbow deep in chemistry."
139
          }
140
        ]
141
      }
142
    };
143
    
144
    await collection.insertOne(doc2);
145
    
146
    // Create and insert the third document - Lincoln High
147
    const doc3 = {
148
      _id: 2,
149
      name: "Lincoln High",
150
      mascot: "Sharks",
151
      teachers: [{
152
        first: "Jane",
153
        last: "Smith",
154
        classes: [{
155
          subject: "science",
156
          grade: "9th"
157
        },
158
        {
159
          subject: "math",
160
          grade: "12th"
161
        }]
162
      },
163
      {
164
        first: "John",
165
        last: "Redman",
166
        classes: [{
167
          subject: "art",
168
          grade: "12th"
169
        }]
170
      }],
171
      clubs: {
172
        arts: [
173
          {
174
            club_name: "ceramics",
175
            description: "provides students an opportunity to acquire knowledge of form, volume, and space relationships by constructing hand-built and wheel-thrown forms of clay."
176
          },
177
          {
178
            club_name: "digital art",
179
            description: "provides students an opportunity to learn about design for entertainment, 3D animation, technical art, or 3D modeling."
180
          }
181
        ],
182
        sports: [
183
          {
184
            club_name: "dodgeball",
185
            description: "provides students an opportunity to play dodgeball by throwing balls to eliminate the members of the opposing team while avoiding being hit themselves."
186
          },
187
          {
188
            club_name: "martial arts",
189
            description: "provides students an opportunity to learn self-defense or combat that utilize physical skill and coordination without weapons."
190
          }
191
        ]
192
      }
193
    };
194
    
195
    await collection.insertOne(doc3);
196
    
197
    console.log('Schools collection successfully created and populated.');
198
  } catch (err) {
199
    console.error(`Error: ${err.message}`);
200
    process.exit(1);
201
  } finally {
202
    // Close the connection
203
    await client.close();
204
  }
205
}
206
207
// Run the function and handle any errors
208
createSchoolsData().catch(console.error);

# Create a new directory and initialize the project
mkdir atlas-search-project && cd atlas-search-project
npm init -y
# Add the MongoDB Node.js Driver to your project
npm install mongodb

1
const { MongoClient } = require("mongodb");
2
3
// connect to your Atlas cluster
4
const uri = "<connection-string>";
5
const client = new MongoClient(uri);
6
7
async function run() {
8
    try {
9
        await client.connect();
10
11
        // set namespace
12
        const database = client.db("local_school_district");
13
        const coll = database.collection("schools");
14
15
        // define pipeline
16
        const agg = [
17
            {
18
                "$searchMeta": {
19
                  "index": "embedded-documents-tutorial",
20
                  "facet": {
21
                    "operator": {
22
                      "text":{
23
                        "path": "name",
24
                        "query": "High"
25
                      }
26
                    },
27
                    "facets": {
28
                      "gradeFacet": {
29
                        "type": "string",
30
                        "path": "teachers.classes.grade"
31
                      }
32
                    }
33
                  }
34
                }
35
              }
36
        ];
37
        
38
        // run pipeline
39
        const result = coll.aggregate(agg);
40
41
        // print results
42
        await result.forEach((doc) => console.dir(JSON.stringify(doc)));
43
    } finally {
44
        await client.close();
45
    }
46
}
47
run().catch(console.dir);