Advanced Query Techniques with Mongoose

In this lesson, we'll learn how to retrieve and manipulate data more efficiently in a MongoDB database using Mongoose. By the end of this lesson, you'll be able to use powerful query methods to get exactly the data you need.

In this lesson you'll learn:

• Setting up Mongoose and Express
• Defining a schema and model for advanced queries
• Creating routes with advanced queries to get specific data

Let's set up our basic Express application and connect it to a MongoDB database using Mongoose. This is important because it lays the foundation for retrieving and manipulating data.

const express = require('express');
const mongoose = require('mongoose');

const app = express();
const PORT = 3000;

// Set mongoose strictQuery to true to suppress deprecation warning
mongoose.set('strictQuery', true);

// Connect to MongoDB
mongoose.connect('mongodb://127.0.0.1:27017/todo-app', {
    useNewUrlParser: true,
    useUnifiedTopology: true
}).then(() => {
    console.log('Connected to MongoDB');
}).catch((error) => {
    console.error('Connection error', error);
    process.exit(1);
});

app.use(express.json());

In this code chunk, we import the necessary modules (express and mongoose). We set up the Express application and specify the port for the server. We then configure Mongoose to connect to a MongoDB database named todo-app. If the connection is successful, a confirmation message is logged; otherwise, an error is printed, and the process exits.

Now we'll define a schema and model for ToDo items, which will help us organize and interact with our data more effectively.

// Define a schema and model for ToDo items
const todoSchema = new mongoose.Schema({
    task: { type: String, required: true },
    completed: { type: Boolean, default: false }
});

const Todo = mongoose.model('Todo', todoSchema);

In this code chunk, we define a schema using Mongoose. The schema includes fields for task (a required string) and completed (a boolean with a default value of false). We then create a model called Todo based on this schema, which provides an interface to interact with our ToDo items in the database.