With our Mongoose schema defined we need to turn our attention to our routes and the controller. The routes file, which
we'll put into a routes sub-directory, should look relatively familiar. However, we're going to leverage a
controller as well.
module.exports = (app) => {
const delis = require('../controllers/controller.js');
// New Deli
app.post('/delis', delis.create);
// Get Delis
app.get('/delis', delis.findAll);
// Single deli with deliId
app.get('/delis/:rest_id', delis.findOne);
// Update a deli with deliId
app.put('/delis/:rest_id', delis.update);
// Delete a deli with deliId
app.delete('/delis/:rest_id', delis.delete);
};The controller is where the database interaction takes place. Based on our schema we previously defined, we setup our CRUD operations in the controller.
const Deli = require('../models/model.js');
// Create and Save a new deli
exports.create = (request, response) => {
if(!request.body) {
return response.status(400).send({
message: "Hmmm, trying to save an empty deli isn't very heroic."
});
}
// Create a new Deli
const deli = new Deli({
name: request.body.name || "Mystery Deli",
rest_id: request.body.rest_id,
street: request.body.street,
district: request.body.district,
city: request.body.city,
state: request.body.state,
postal_code: request.body.postal_code,
specialty: request.body.specialty
});
// Save deli
deli.save().then(data => {
response.send(data);
}).catch(err => {
response.status(500).send({
message: err.message || "An error occurred while creating the deli."
});
});
};
// Get all delis
exports.findAll = (request, response) => {
Deli.find()
.then(delis => {
response.send(delis);
}).catch(err => {
response.status(500).send({
message: err.message || "Something happened while trying to get all the delis."
});
});
};
// Find a single deli based on deliId
exports.findOne = (request, response) => {
console.log(request.params.rest_id);
Deli.find({rest_id: request.params.rest_id})
.then(deli => {
if(!deli) {
return response.status(404).send({
message: "Deli not found with id " + request.params.rest_id
});
}
response.send(deli);
}).catch(err => {
if(err.kind === 'rest_id') {
return response.send(404).send({
message: "Deli not found with id " + request.params.rest_id
});
}
return response.status(500).send({
message: "Sorry, something happened while trying to get the deli with id " + request.params.rest_id
});
});
};
// Update deli
exports.update = (request, response) => {
if (!request.body) {
return response.status(400).send({
message: "Hmmm, trying to save an empty deli isn't very heroic."
});
}
Deli.findOneAndUpdate({rest_id: request.params.rest_id}, {
name: request.body.name || "Mystery Deli",
rest_id: request.body.rest_id,
street: request.body.street,
district: request.body.district,
city: request.body.city,
state: request.body.state,
postal_code: request.body.postal_code,
specialty: request.body.specialty
}, {new: true})
.then(deli => {
if (!deli) {
return response.status(404).send({
message: "Deli not found with id " + request.params.rest_id
});
}
response.send(deli);
}).catch(err => {
if (err.kind === 'rest_id') {
return response.send(404).send({
message: "Deli not found with id " + request.params.rest_id
});
}
return response.status(500).send({
message: "Sorry, something happened while trying to get the deli with id " + request.params.rest_id
});
});
};
// Delete
exports.delete = (request, response) => {
Deli.findOneAndDelete({rest_id: request.params.rest_id})
.then(deli => {
if (!deli) {
return response.status(404).send({
message: "Deli not found with id " + request.params.rest_id
});
}
response.send({message: "Deli successfully deleted!"});
}).catch(err => {
if(err.kind === 'rest_id' || err.name === 'NotFound') {
return response.status(404).send({
message: "Deli not found with id " + request.params.rest_id
});
}
return response.status(500).sent({
message: "Sorry, couldn't delete deli with id " + request.params.rest_id
});
});
};And put everything together in a new app.js
const mongoose = require('mongoose');
const express = require('express');
// Create Express app
const app = express();
// support parsing of application/x-www-form-urlencoded post data with Express native package
app.use(express.urlencoded({extended: true}));
// support parsing of application/json type post data with Express native package
app.use(express.json());
// Database setup
const dbName = 'mdbw18';
const mdbPort = 27017;
const url = 'mongodb://localhost:' + mdbPort + '/'+ dbName;
mongoose.Promise = global.Promise;
mongoose.connect(url).then(() => {
console.log("Successfully connected to the database.");
}).catch(err => {
console.log("Couldn't connect to the database. Exiting now...");
process.exit();
});
// Define Routes
app.get('/', (request, response) => {
response.json({"message": "Welcome to the Mongoose API."})
});
require('./routes/routes.js')(app);
// Listen for server requests
app.listen(3000, () => {
console.log("Express server is listening on Port 3000.")
});Voilà. Our API is now able to handle all the CRUD operations and is using the Mongoose ORM.
- MVC Design Pattern
- Final project code is available here
| Quest | Description | |
|---|---|---|
| Quest Zero | First quest to read. Provides some overview information and background. | |
| Quest 1 | Initialize your project and install some of the required software. | |
| Quest 2 | creating a quick test JavaScript. | |
| Quest 3 | Crafting your own tools: Building a server process using httpd and express |
|
| Quest 4 | Building Your App | |
| Quest 5 | Defining the data for our application | |
| Quest 6 | Enter MongoDB - Native JavaScript | |
| Quest 7 | Creating and Reading data using the Native MongoDB Driver | |
| Quest 8 | Mongoose - Object Data Modeling | |
| > | Quest 9 | Creating and Reading data using Mongoose |
Next quest: CONGRATULATIONS! Next Steps