Table for logging MongoDB operations using Mongoose

Question

Table for logging MongoDB operations using Mongoose

I am looking to develop a log table that logs data in its own table every time a user sends a request. I am also interested in retrieving data similar to the following:

{
            _id: ObjectId('4f442120eb03305789000000'),
            host: "127.0.0.1",
            logname: null,
            user: 'frank',
            time: ISODate("2000-10-10T20:55:36Z"),
            path: "/apache_pb.gif",
            request: "GET /apache_pb.gif HTTP/1.0",
            status: 200,
            response_size: 2326,
            referrer: "[http://www.example.com/start.html](http://www.example.com/start.html)",
            user_agent: "Mozilla/4.08 [en] (Win98; I ;Nav)"
            }

Not necessarily all of this information, but at least details on who made the request, the type of request, path, and timestamp. I am working with nodejs, mongodb, and mongoose.

javascript mongodb mongoose logging database-design

Answer 1

Answer №1

If you want to track all incoming requests to your server, consider implementing a custom middleware that logs the data to a MongoDB Database.

To make this task easier, check out these npm packages:

1 - useragent

2 - express-useragent

Answer 2

If you want to track all incoming requests to your server, consider implementing a custom middleware that logs the data to a MongoDB Database.

To make this task easier, check out these npm packages:

1 - useragent

2 - express-useragent

Answer 3

Answer №2

This is the method I used to solve the problem.

Middleware

const Log = require("../models/log");

const log = async (req, res, next) => {
    try {

    let user_id = req.user.id
    let firstName = req.user.firstName
    let method = req.method
    let path = req.path    

    const log = new Log({ user_id, firstName, method, path });

    try {
        await log.save()
    } catch (e) {
        res.status(400).send(e)
    }

      next();
    } catch (e) {
      res.status(401).send(e);
    }
  };

module.exports = log;

Data Model

const mongoose = require('mongoose')

const logSchema = new mongoose.Schema({
    user_id: {
        type: String,
    },
    firstName: {
        type: String,
    },
    method: {
        type: String,
    },
    path: {
        type: String,
    },
}, {
    timestamps: true
})

const Log = mongoose.model('Log', logSchema);

module.exports = Log;

Router Configuration

const express = require('express')
const Log = require('../models/log')
const auth = require('../middleware/auth')
const router = new express.Router()

//Create log
router.post('/logs', async (req, res) => {
    const log = new Log({
        ...req.body
    })

    try {
        await log.save()
        res.status(201).send(log)
    } catch (e) {
        res.status(400).send(e)
    }
})

//Sort and search
router.get('/logs', auth, async (req, res) => {
    const match = {}
    const sort = {}

    if (req.query.completed) {
        match.completed = req.query.completed === 'true'
    }

    if (req.query.sortBy) {
        const parts = req.query.sortBy.split(':')
        sort[parts[0]] = parts[1] === 'desc' ? -1 : 1
    }

    try {
        await req.user.populate({
            path: 'logs',
            match,
            options: {
                limit: parseInt(req.query.limit),
                skip: parseInt(req.query.skip),
                sort
            }
        }).execPopulate()
        res.send(req.user.logs)
    } catch (e) {
        res.status(500).send()
    }
})

module.exports = router;

Answer 4

This is the method I used to solve the problem.

Middleware

const Log = require("../models/log");

const log = async (req, res, next) => {
    try {

    let user_id = req.user.id
    let firstName = req.user.firstName
    let method = req.method
    let path = req.path    

    const log = new Log({ user_id, firstName, method, path });

    try {
        await log.save()
    } catch (e) {
        res.status(400).send(e)
    }

      next();
    } catch (e) {
      res.status(401).send(e);
    }
  };

module.exports = log;

Data Model

const mongoose = require('mongoose')

const logSchema = new mongoose.Schema({
    user_id: {
        type: String,
    },
    firstName: {
        type: String,
    },
    method: {
        type: String,
    },
    path: {
        type: String,
    },
}, {
    timestamps: true
})

const Log = mongoose.model('Log', logSchema);

module.exports = Log;

Router Configuration

const express = require('express')
const Log = require('../models/log')
const auth = require('../middleware/auth')
const router = new express.Router()

//Create log
router.post('/logs', async (req, res) => {
    const log = new Log({
        ...req.body
    })

    try {
        await log.save()
        res.status(201).send(log)
    } catch (e) {
        res.status(400).send(e)
    }
})

//Sort and search
router.get('/logs', auth, async (req, res) => {
    const match = {}
    const sort = {}

    if (req.query.completed) {
        match.completed = req.query.completed === 'true'
    }

    if (req.query.sortBy) {
        const parts = req.query.sortBy.split(':')
        sort[parts[0]] = parts[1] === 'desc' ? -1 : 1
    }

    try {
        await req.user.populate({
            path: 'logs',
            match,
            options: {
                limit: parseInt(req.query.limit),
                skip: parseInt(req.query.skip),
                sort
            }
        }).execPopulate()
        res.send(req.user.logs)
    } catch (e) {
        res.status(500).send()
    }
})

module.exports = router;

Table for logging MongoDB operations using Mongoose

Answer №1

Answer №2

Similar questions

Locate a deeply nested element within an array of objects using a specific string identifier

A guide on querying MongoDB using the PHP extension to retrieve the number of results from a cursor

Searching for a specific character sequence within a MongoDB database

Encountering a problem with Vite and PostCSS: "Assignment to invalid left-hand side"

Unable to collapse the Bootstrap dropdown menu

Ways to retrieve partial data from mongodb instead of fetching the entire dataset

Morphia fails to identify the @ID annotated field in my code

React router dom - A tool for efficient navigation in React applications

Is there a way to identify the specific '$or' clause to which each document corresponds in the results of a query?

Inactivity for more than 5 minutes causes Spring to disconnect from MongoDB Atlas

Leveraging HTML tables for input purposes

Retrieving output from a JavaScript function

Retrieving data from an anonymous function in AngularJS and outputting it as JSON or another value

Experiencing a bug in the production build of my application involving Webpack, React, postCSS, and potentially other JavaScript code not injecting correctly

Exploring the interplay between jQuery functions and the "Class" method in Javascript

What is Node.js's approach to managing concurrent operations?

The caret plugin feature in jQuery is dysfunctional in Internet Explorer

What is the most efficient method for storing counters in a MongoDB database?

What is the best way to stop an emitter.on from executing within a conditional statement?

Steps to activate the context menu for specific elements