When managing a database of puppy records, we often need to update information as puppies grow or remove records when needed. Think of it like maintaining a veterinary clinic's records - sometimes you need to update a puppy's weight after a checkup, and sometimes you need to remove records of puppies that have moved to different clinics.
We need to implement two main operations:
1. Updating specific attributes of a puppy record (like age, weight, and microchip status)
2. Removing a puppy record entirely from the database
Let's first look at how to update records in Sequelize. Think of this like updating a patient's chart with new information. We'll build a PUT endpoint that handles these updates:
// Complete PUT endpoint implementation
app.put('/puppies/:puppyId', async (req, res, next) => {
try {
// First, find the puppy by its ID
const puppy = await Puppy.findByPk(req.params.puppyId);
if (!puppy) {
// If no puppy is found, return an error
return res.status(404).json({
message: "Puppy not found"
});
}
// Extract only the permitted attributes from the request body
const { ageYrs, weightLbs, microchipped } = req.body;
// Update only the attributes that were provided
// This is like only updating the specific fields on a medical chart
if (ageYrs !== undefined) puppy.ageYrs = ageYrs;
if (weightLbs !== undefined) puppy.weightLbs = weightLbs;
if (microchipped !== undefined) puppy.microchipped = microchipped;
// Save the changes to the database
await puppy.save();
// Return success message and updated puppy data
res.json({
message: `Successfully updated puppy with id ${req.params.puppyId}.`,
puppy: puppy
});
} catch (error) {
// If anything goes wrong, pass the error to error handlers
next(error);
}
});Let's break down what's happening in our update code:
1. Finding the Record: First, we use findByPk() to locate the specific puppy:
const puppy = await Puppy.findByPk(req.params.puppyId);This is like looking up a specific patient file using their unique ID number.
2. Checking Existence: We verify that we found a record:
if (!puppy) {
return res.status(404).json({
message: "Puppy not found"
});
}This is similar to checking if a patient's file actually exists before trying to update it.
3. Selective Updates: We only update the fields that were provided:
if (ageYrs !== undefined) puppy.ageYrs = ageYrs;
if (weightLbs !== undefined) puppy.weightLbs = weightLbs;
if (microchipped !== undefined) puppy.microchipped = microchipped;This is like only updating the specific measurements that were taken during a checkup, leaving other information unchanged.
Now let's look at how to remove records entirely. This is like removing a patient's file when they transfer to a different clinic:
// Complete DELETE endpoint implementation
app.delete('/puppies/:puppyId', async (req, res, next) => {
try {
// First, find the puppy by its ID
const puppy = await Puppy.findByPk(req.params.puppyId);
if (!puppy) {
// If no puppy is found, return an error
return res.status(404).json({
message: "Puppy not found"
});
}
// Store the puppy data before deletion
const puppyData = puppy.toJSON();
// Remove the record from the database
await puppy.destroy();
// Return success message and the data of the deleted puppy
res.json({
message: `Successfully deleted puppy with id ${req.params.puppyId}.`,
puppy: puppyData
});
} catch (error) {
// If anything goes wrong, pass the error to error handlers
next(error);
}
});Let's break down the deletion process:
1. Finding the Record: Just like with updates, we first locate the specific puppy:
const puppy = await Puppy.findByPk(req.params.puppyId);This ensures we're removing the correct record.
2. Storing Data: Before deletion, we save the data to return in our response:
const puppyData = puppy.toJSON();This is like making a copy of a file before shredding the original.
3. Removing the Record: We use the destroy() method to remove the record:
await puppy.destroy();This permanently removes the record from the database.
You can test your update endpoint using Postman or curl:
// Example curl command for updating Callie's information
curl -X PUT http://localhost:8000/puppies/7 \
-H "Content-Type: application/json" \
-d '{
"ageYrs": 1.5,
"weightLbs": 26
}'Similarly, test your delete endpoint:
// Example curl command for deleting Cooper's record
curl -X DELETE http://localhost:8000/puppies/11. Always validate input data before applying updates
2. Only update the fields that were actually provided
3. Return the updated record in the response to confirm changes
4. Use try/catch blocks to handle potential errors
1. Always verify the record exists before attempting deletion
2. Consider implementing soft deletes for important data
3. Return the deleted data in the response for confirmation
4. Consider implementing deletion constraints for related data
For more complex updates or deletions, you might want to use transactions. Here's how:
const transaction = await sequelize.transaction();
try {
// Perform updates or deletions within the transaction
await puppy.update({ weightLbs: 26 }, { transaction });
await transaction.commit();
} catch (error) {
await transaction.rollback();
throw error;
}To deepen your understanding of Sequelize updates and deletions, try:
1. Implementing soft deletes using a 'deleted' flag
2. Adding validation hooks before updates
3. Creating bulk update and delete operations
4. Implementing cascading deletes for related records
5. Adding audit trails for tracking changes